浪潮-Oracle Dataguard 物理备库标准化搭建文档.pdf

浮光墨影

925

37页

56次

2024-08-23

10墨值下载

Oracle Dataguard 物理备库标准化搭建文档



注意：生产环境请根据实际环境做相应的变更,适用于oracle 10g、oracle 11g



SQL> select force_logging from v$database;



FOR

---

YES

SQL>

/u01/app/oracle/diag/rdbms/db11g/db11g2/trace



SQL> ALTER DATABASE FORCE LOGGING;



Database altered.



SQL> select force_logging from v$database;



FORCE_LOG

---------

YES



：通常我们设置生产库的每个redo大小为512M～2048M之间，并且大于等于三组



SQL>set linesize 150;

set pagesize 50;

column MB format a5;

column STATUSformat a12;

column MEMBER format a50;

select l.GROUP#,l.THREAD#,l.BYTES/1024/1024||'MB' MB,l.STATUS, lf.TYPE,lf.MEMBER from v$log l,v$logfile lf where

l.GROUP#=lf.GROUP#;



GROUP# THREAD# MB STATUS TYPE MEMBER

---------- ---------- ----- ------------ ------- --------------------------------------------------

1 1 512MB INACTIVE ONLINE +DATAVG/orcl/onlinelog/group_1.279.879447445

3 1 512MB CURRENT ONLINE +DATAVG/orcl/onlinelog/group_3.278.879447453

2 2 512MB INACTIVE ONLINE +DATAVG/orcl/onlinelog/group_2.277.879447463

4 2 512MB CURRENT ONLINE +DATAVG/orcl/onlinelog/group_4.276.879447469

5 1 512MB INACTIVE ONLINE +DATAVG/orcl/onlinelog/group_5.296.879447083

6 2 512MB INACTIVE ONLINE +DATAVG/orcl/onlinelog/group_6.297.879447109

7 1 512MB INACTIVE ONLINE +DATAVG/orcl/onlinelog/group_7.298.879447309

8 2 512MB INACTIVE ONLINE +DATAVG/orcl/onlinelog/group_8.299.879447321

8 rows selected.

SQL>



以节点rac1为例，编辑/etc/hosts文件



172.17.0.3 rac1

172.17.0.4 rac2



10.0.0.1 rac1-priv

10.0.0.2 rac2-priv



172.17.0.1 rac1-vip

172.17.0.2 rac2-vip



172.17.0.14 ogg_standby



# vi /etc/hosts

添加以下内容：

172.17.0.14 ogg_standby 



172.17.0.3 rac1

172.17.0.4 rac2



编辑listener.ora文件，编辑后，启动或重载监听，查看是否启动服务

$ vi $ORACLE_HOME/network/admin/listener.ora

添加并确认以下内容：

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.



LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.0.14)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)



ADR_BASE_ORACLE = /u01/app/oracle



SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

of 37

10墨值下载

oracle 数据库安装部署 11g dg

关注

评论