9i data guard实施笔记:
环境:win2000+9205
primary:xyjpr 192.168.0.37
standby:xyjst 192.168.0.216
在PRIMARY和STANDBY上都使用PFILE参数文件(也可以使用SPFILE文件)
1、必须保证相关的init[sid].ora参数的定义正确
pr:
必须保证为ARCHIVE模式
log_archive_dest=''
standby_archive_dest=D:\oracle\ora92\database\arch (默认有相关路径,也可以指定新的路径)
log_archive_dest_2='SERVICE=node2 LGWR SYNC AFFIRM REOPEN'
log_archive_dest_1='LOCATION=D:\oracle\ora92\database\archive MANDATORY REOPEN'
fal_server=xyjst
fal_client=xthpr
control_files='D:\oracle\oradata\stand\CONTROL01.CTL','D:\oracle\oradata\stand\CONTROL02.CTL','D:\oracle\oradata\stand\CONTROL03.CTL'
#db_file_name_convert=('PROD2','PROD1')
#log_file_name_convert=('PROD2','PROD1')
log_archive_dest_state_2=enable
log_archive_dest_state_1=enable
db_name='stand'
instance_name='stand'
log_archive_format=arch%s.arc
log_archive_start=true
remote_archive_enable=true
standby_file_management=auto
DG_BROKER_start=true
db_domain=''
remote_login_passwordfile=EXCLUSIVE
compatible='9.2.0.0.0'
job_queue_processes=0(一定要为0)
aq_tm_processes=0 (一定要为0)
st:
可设置为archive或者noarchive模式
log_archive_dest=''
standby_archive_dest=D:\oracle\ora92\database\arch (默认有相关路径,也可以指定新的路径)
log_archive_dest_2='SERVICE=node2 LGWR SYNC AFFIRM REOPEN'
log_archive_dest_1='LOCATION=D:\oracle\ora92\database\archive MANDATORY REOPEN'
fal_server=xyjpr
fal_client=xyjst
control_files='D:\oracle\oradata\stand\CONTROL01.CTL','D:\oracle\oradata\stand\CONTROL02.CTL','D:\oracle\oradata\stand\CONTROL03.CTL'
#db_file_name_convert=('PROD2','PROD1')
#log_file_name_convert=('PROD2','PROD1')
log_archive_dest_state_2=defer (默认为enable,切换后好修改为enable)
log_archive_dest_state_1=enable
db_name='stand'
instance_name='stand'
log_archive_format=arch%s.arc
log_archive_start=true
remote_archive_enable=true
standby_file_management=auto
DG_BROKER_start=true
db_domain=''
remote_login_passwordfile=EXCLUSIVE
compatible='9.2.0.0.0'
job_queue_processes=0(一定要为0)
aq_tm_processes=0 (一定要为0)
环境:win2000+9205
primary:xyjpr 192.168.0.37
standby:xyjst 192.168.0.216
在PRIMARY和STANDBY上都使用PFILE参数文件(也可以使用SPFILE文件)
1、必须保证相关的init[sid].ora参数的定义正确
pr:
必须保证为ARCHIVE模式
log_archive_dest=''
standby_archive_dest=D:\oracle\ora92\database\arch (默认有相关路径,也可以指定新的路径)
log_archive_dest_2='SERVICE=node2 LGWR SYNC AFFIRM REOPEN'
log_archive_dest_1='LOCATION=D:\oracle\ora92\database\archive MANDATORY REOPEN'
fal_server=xyjst
fal_client=xthpr
control_files='D:\oracle\oradata\stand\CONTROL01.CTL','D:\oracle\oradata\stand\CONTROL02.CTL','D:\oracle\oradata\stand\CONTROL03.CTL'
#db_file_name_convert=('PROD2','PROD1')
#log_file_name_convert=('PROD2','PROD1')
log_archive_dest_state_2=enable
log_archive_dest_state_1=enable
db_name='stand'
instance_name='stand'
log_archive_format=arch%s.arc
log_archive_start=true
remote_archive_enable=true
standby_file_management=auto
DG_BROKER_start=true
db_domain=''
remote_login_passwordfile=EXCLUSIVE
compatible='9.2.0.0.0'
job_queue_processes=0(一定要为0)
aq_tm_processes=0 (一定要为0)
st:
可设置为archive或者noarchive模式
log_archive_dest=''
standby_archive_dest=D:\oracle\ora92\database\arch (默认有相关路径,也可以指定新的路径)
log_archive_dest_2='SERVICE=node2 LGWR SYNC AFFIRM REOPEN'
log_archive_dest_1='LOCATION=D:\oracle\ora92\database\archive MANDATORY REOPEN'
fal_server=xyjpr
fal_client=xyjst
control_files='D:\oracle\oradata\stand\CONTROL01.CTL','D:\oracle\oradata\stand\CONTROL02.CTL','D:\oracle\oradata\stand\CONTROL03.CTL'
#db_file_name_convert=('PROD2','PROD1')
#log_file_name_convert=('PROD2','PROD1')
log_archive_dest_state_2=defer (默认为enable,切换后好修改为enable)
log_archive_dest_state_1=enable
db_name='stand'
instance_name='stand'
log_archive_format=arch%s.arc
log_archive_start=true
remote_archive_enable=true
standby_file_management=auto
DG_BROKER_start=true
db_domain=''
remote_login_passwordfile=EXCLUSIVE
compatible='9.2.0.0.0'
job_queue_processes=0(一定要为0)
aq_tm_processes=0 (一定要为0)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28419/viewspace-613744/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28419/viewspace-613744/