Oracle 9i DG 配置简要步骤

因工作需要，简绍Oracle DG 9i配置过程，以供参考
一、主库操作：
1、主库需要配置的参数
log_archive_dest_1='LOCATION=/u01/oradata/test/archive'                                        
log_archive_dest_2 ='service=lsnode2 lgwr sync affirm'
log_archive_dest_1=enable;
log_archive_dest_state_2=enable;
standby_archive_dest='/u01/oradata/test/archive'
standby_file_management='auto'
fal_client='lsnode1'
fal_server='lsnode2'
+++++以下参数适用于主备datafile，redolog路径不一致，由于测试系统路径一致，故没有配置。++++
+++++注意以下路径仅作示例，以实际生产库为准++++++
db_file_name_convert=('/dev','/Tbackup/mctest/oradata')
log_file_name_convert=('/dev','/Tbackup/mctest/oradata')

2、添加standbyredolog

alter database add standby logfile group 4 ('/u01/oradata/test/stdredo4.log') size 100M;
alter database add standby logfile group 5 ('/u01/oradata/test/stdredo5.log') size 100M;
                               

二、备库操作：
1、备库需要配置的参数
log_archive_dest_1='LOCATION=/u01/oradata/test/archive'                                        
log_archive_dest_2 ='service=lsnode1 lgwr sync affirm'
log_archive_dest_1=enable;
log_archive_dest_state_2=defer;                
standby_archive_dest='/u01/oradata/test/archive'
standby_file_management='auto'
fal_client='lsnode2'
fal_server='lsnode1'
+++++以下参数适用于主备datafile，redolog路径不一致，由于测试系统路径一致，故没有配置。++++
+++++注意以下路径仅作示例，以实际生产库为准++++++
db_file_name_convert=('/Tbackup/mctest/oradata','/dev')
log_file_name_convert=('/Tbackup/mctest/oradata','/dev')

2、添加standbyredolog

alter database add standby logfile group 4 ('/u01/oradata/test/stdredo4.log') size 100M;
alter database add standby logfile group 5 ('/u01/oradata/test/stdredo5.log') size 100M;

三、切换操作

1、主库切换到备库
alter database commit to  switchover to physical standby with session shutdown;
2、备库切换到主库
alter database recover managed standby database finish;
alter database commit to switchover to primary;