《ORACLE生产环境RAC下部署DG》-----Pure Love

部署环境

RAC：Linux 6.8 + ORACLE 11.2.0.4

DG：Linux 6.4 + ORACLE 11.2.0.4

生产环境，要求速度部署！！！

准备工作

先在备库将归档开启，修改归档路径，调整tnsnames.ora文件，以及pfile文件，测试监听。

测试没问题以后，用pfile文件将数据库启动到nomount状态，

[oracle@standby dbs]$ cat initorcldg.ora
orcldg.__db_cache_size=327155712
orcldg.__java_pool_size=4194304
orcldg.__large_pool_size=8388608
orcldg.__oracle_base='/u01/app'#ORACLE_BASE set from environment
orcldg.__pga_aggregate_target=318767104
orcldg.__sga_target=469762048
orcldg.__shared_io_pool_size=0
orcldg.__shared_pool_size=121634816
orcldg.__streams_pool_size=0
*.audit_file_dest='/u01/app/admin/orcldg/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/u01/app/oradata/orcldg/control01.ctl','/u01/app/oradata/orcldg/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.diagnostic_dest='/u01/app'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orcldgXDB)'
*.memory_target=786432000
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.db_unique_name=orcldg
*.log_archive_config='dg_config=(orcldg,orcl)'
*.log_archive_dest_1='location=/u01/app/oradata/orcldg/arch valid_for=(all_logfiles,all_roles) db_unique_name=orcldg'
*.log_archive_dest_2='service=orcl1 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.log_archive_format=%t_%s_%r.arc
*.fal_server=‘orcl1,orcl2'
*.fal_client=orcldg
*.standby_file_management=auto
*.log_file_name_convert='+DBDATA/orcl/onlinelog/','/u01/app/oradata/orcldg/'
*.db_file_name_convert='+DBDATA/orcl/datafile/','/u01/app/oradata/orcldg/'

主库操作

节点1：

alter database force logging;

因为当前的rac环境，归档未开启，所以，需要修改一下归档的模式以及路径。

关闭节点2；

关闭节点1；

在节点1做以下操作：

startup mount
alter database archivelog;
alter database open;
alter system set log_archive_dest_1='location=+DBDATA/orcl/archivelog' scope=spfile;

startup force

重启节点1：

添加到rac中的spfile文件

*.db_unique_name=orcl1
*.log_archive_config='dg_config=(orcl,orcldg)'
*.log_archive_dest_1='location=+DBDATA/orcl/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=orcl'
*.log_archive_dest_2='service=orcldg lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=standby'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.log_archive_format=%t_%s_%r.arc
*.fal_server=orcldg
*.fal_client=orcl
*.standby_file_management=auto
*.log_file_name_convert='/u01/app/oradata/orcldg/','+ORADATA/orcl/onlinelog/'
*.db_file_name_convert='/u01/app/oradata/orcldg/','+ORADATA/orcl/datafile/'

startup force 重启

启动节点2；

节点1操作：

alter database create standby controlfile as '/u01/app/oracle/control01.ctl';

scp /u01/app/oracle/control01.ctl   DG:/u01/app/oradata/orcldg/control01.ctl

scp /u01/app/oracle/control01.ctl  DG:/u01/app/oradata/orcldg/control02.ctl

开始Duplicate

备库操作：

rman target sys/PASSWORD@orcl auxiliary sys/PASSWORD@orcldg
duplicate target database for standby from active database nofilenamecheck;

完成部署

节点1操作：

主库创建redo日志组：
alter database add standby logfile group 5 '+DBDATA/orcl/onlinelog/redo05.log' size 100M;
alter database add standby logfile group 6 '+DBDATA/orcl/onlinelog/redo06.log' size 100M;

备库创建redo日志组：
alter database add standby logfile group 4 '/u01/app/oradata/orcldg/redo04.log' size 100M;
alter database add standby logfile group 5 '/u01/app/oradata/orcldg/redo05.log' size 100M;
alter database add standby logfile group 6 '/u01/app/oradata/orcldg/redo06.log' size 100M;
alter database add standby logfile group 7 '/u01/app/oradata/orcldg/redo07.log' size 100M;
alter database add standby logfile group 8 '/u01/app/oradata/orcldg/redo08.log' size 100M;

开启日志应用：

alter database recover managed standby database using current logfile disconnect from session;

查看日志应用：

select sequence#,name,applied from v$archived_log order by sequence#;

SQL> select sequence#,name,applied from v$archived_log order by sequence#;

 SEQUENCE# NAME                                               APPLIED
---------- -------------------------------------------------- ---------
        36 /u01/app/oradata/archivelog/2_36_952076435.arc     YES
        37 /u01/app/oradata/archivelog/2_37_952076435.arc     YES
        38 /u01/app/oradata/archivelog/2_38_952076435.arc     YES
        39 /u01/app/oradata/archivelog/2_39_952076435.arc     YES
        40 /u01/app/oradata/archivelog/2_40_952076435.arc     YES
        41 /u01/app/oradata/archivelog/2_41_952076435.arc     YES
        42 /u01/app/oradata/archivelog/2_42_952076435.arc     YES
        43 /u01/app/oradata/archivelog/2_43_952076435.arc     YES
        44 /u01/app/oradata/archivelog/2_44_952076435.arc     YES
        45 /u01/app/oradata/archivelog/2_45_952076435.arc     YES
        46 /u01/app/oradata/archivelog/2_46_952076435.arc     YES

......

 SEQUENCE# NAME                                               APPLIED
---------- -------------------------------------------------- ---------
       143 /u01/app/oradata/archivelog/1_143_952076435.arc    YES
       144 /u01/app/oradata/archivelog/1_144_952076435.arc    YES
       145 /u01/app/oradata/archivelog/1_145_952076435.arc    YES
       146 /u01/app/oradata/archivelog/1_146_952076435.arc    YES
       147 /u01/app/oradata/archivelog/1_147_952076435.arc    YES
       148 /u01/app/oradata/archivelog/1_148_952076435.arc    YES
       149 /u01/app/oradata/archivelog/1_149_952076435.arc    YES
       150 /u01/app/oradata/archivelog/1_150_952076435.arc    YES
       151 /u01/app/oradata/archivelog/1_151_952076435.arc    YES
       152 /u01/app/oradata/archivelog/1_152_952076435.arc    YES
       153 /u01/app/oradata/archivelog/1_153_952076435.arc    YES

 SEQUENCE# NAME                                               APPLIED
---------- -------------------------------------------------- ---------
       154 /u01/app/oradata/archivelog/1_154_952076435.arc    YES

111 rows selected.

此文内容基于生产环境，部分地方路径为修改后的，有错误的地方还请看客提出，收到消息一定火速修改！

------欢迎转载，QQ：794189449