Rman创建DG环境

Oracle： 11.2.0.3
OS： redhat 5.7
Primary IP: 192.168.67.158
DB_NAME=test

Standby IP: 192.168.67.159
DB_NAME=test

一． Primary 端的配置

1. 主库设置为force logging 模式
SQL> alter database force logging;
主库备库设置：（自动同步主库DB的改变)
alter system set standby_file_management=AUTO;

2. 主库设为归档模式
SQL> archive log list;
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> archive log list;

3. 添加redo log file
添加一个新的Standby Redologs组（注意组号不要与当前存在的Online Redologs组重复），并为该组指定一个成员：
alter database add standby logfile group 4('/u01/app/oracle/oradata/test/redo04.log') size 50M;
alter database add standby logfile group 5('/u01/app/oracle/oradata/test/redo05.log') size 50M;
alter database add standby logfile group 6('/u01/app/oracle/oradata/test/redo06.log') size 50M;
alter database add standby logfile group 7('/u01/app/oracle/oradata/test/redo07.log') size 50M;

4. 修改listener.ora 和tnsnames.ora 文件（standby也做同样修改)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = test2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = /u01/app/oracle

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME =/u01/app/oracle/product/11g/db_1)
(SID_NAME = test)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =/u01/app/oracle/product/11g/db_1)
(PROGRAM = extproc)
)
)

TNSNAME.ORA 设置：

TEST_ST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.67.159)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)

TEST_PD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.67.158)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)
5、修改参数文件（添加）
主：
*.db_unique_name='test_pd'
*.log_archive_config='dg_config=(test_pd,test_st)'
*.log_archive_dest_1='location=/u01/app/oracle/arch1/ valid_for=(all_logfiles,all_roles) db_unique_name=test_pd'
*.log_archive_dest_2='service=test_st reopen=120 lgwr async AFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=test_st'
*.standby_file_management='auto'
*.fal_server='test_st'
*.fal_client='test_pd'

备：
*.db_unique_name='test_st'
*.log_archive_config='dg_config=(test_pd,test_st)'
*.log_archive_dest_1='location=/u01/app/oracle/arch2/ valid_for=(all_logfiles,all_roles) db_unique_name=test_st'
*.log_archive_dest_2='service=test_pd reopen=120 lgwr async AFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=test_pd'
*.standby_file_management='auto'
*.fal_server='test_pd'
*.fal_client='test_st'
*.log_file_name_convert='/u01/app/oracle/oradata/test','/u01/app/oracle/oradata/test2'
--备库需要log_file_name_convert参数 否则无法复制日志文件

standby 端创建：

[oracle@test2 test]$ mkdir /u01/app/oracle/admin/test/{a,dp,b}dump
[oracle@test2 test]$ mkdir /u01/app/oracle/admin/test/spfile
[oracle@test2 test]$ mkdir /u01/app/oracle/oradata/test/
[oracle@test2 oradata]$ pwd
/u01/app/oracle/oradata
oracle@test2 oradata]$ mkdir test
[oracle@test2 oradata]$ mkdir test2
[oracle@test2 dbs]$ orapwd file=/u01/app/oracle/product/11g/db_1/dbs/orapwtest password=paladin
startup nomount pfile='/u01/app/oracle/product/11g/db_1/dbs/inittest.ora';

[oracle@test2 dbs]$ rman target sys/paladin@test_pd auxiliary sys/paladin@test_st
duplicate target database for standby from active database nofilenamecheck;

alter database add standby logfile group 4('/u01/app/oracle/oradata/test2/redo04.log') size 50M;
alter database add standby logfile group 5('/u01/app/oracle/oradata/test2/redo05.log') size 50M;
alter database add standby logfile group 6('/u01/app/oracle/oradata/test2/redo06.log') size 50M;
alter database add standby logfile group 7('/u01/app/oracle/oradata/test2/redo07.log') size 50M;
--启动redo应用
alter database recover managed standby database using current logfile disconnect from session; --physical standby database
alter database start logical standby apply immediate; --logical standby database apply redo data
--开启DG
alter database recover managed standby database disconnect from session;

--关闭DG
alter database recover managed standby database cancel;

*********************************************************************************************************************************************
参数描写：
1、最高性能
LOG_ARCHIVE_DEST_2='SERVICE=Matrix_DR0 ASYNC NOAFFIRM'
2、最高可用性及最大保护模式

LOG_ARCHIVE_DEST_2='SERVICE=Matrix_DR0 SYNC AFFIRM'

3、切换保护模式：(primary数据上做）
ALTER DATABASE SET STANDBY TO MAXIMIZE PERFORMANCE;
ALTER DATABASE SET STANDBY TO MAXIMIZE AVAILABILITY;
ALTER DATABASE SET STANDBY TO MAXIMIZE PROTECTION;

**************************************************************************************************************************