部署环境
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