搭建rac环境DG，备库日志无法同步
主库修改的参数文件alter system set log_archive_config='dg_config=(sx3zhdb,Tdweb20)' scope=both sid='*';
alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles) db_unique_name=sx3zhdb' scope=both sid='*';
alter system set log_archive_dest_2='service=TDWEB20_SB lgwr valid_for=(online_logfiles,primary_role) db_unique_name=Tdweb20' scope=both sid='*';
alter system set fal_server=Tdweb20 scope=both sid='*';
alter system set fal_client=sx3zhdb scope=both sid='*';
alter system set
db_file_name_convert='/u01/app/oracle/oradata/sx3zhdb/datafile','+DATDG/sx3zhdb/datafile','/u01/app/oracle/oradata/sx3zhdb/tempfile','+DATDG/sx3zhdb/tempfile'
scope=spfile sid='*';
alter system set log_file_name_convert='/u01/app/oracle/oradata/sx3zhdb/onlinelog','+DATDG/sx3zhdb/onlinelog' scope=spfile sid='*';
alter system set standby_file_management=AUTO scope=both sid='*';
备库的参数文件
*.audit_file_dest='/u01/app/oracle/admin/sx3zhdb/adump'
*.audit_trail='db'
*.cluster_database=false
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/sx3zhdb/datafile/sx3zhdb.ctl'
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata/sx3zhdb/datafile'
*.db_domain=''
*.db_file_name_convert='+DATDG/sx3zhdb/datafile','/u01/app/oracle/oradata/sx3zhdb/datafile','+DATDG/sx3zhdb/tempfile','/u01/ap/oracle/oradata/sx3zhdb/tempfile'
*.db_name='sx3zhdb'
*.db_recovery_file_dest='/archivelog'
*.db_recovery_file_dest_size=322122547200
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=sx3zhdbXDB)'
*.fal_client='TDWEB20'
*.fal_server='SX3ZHDB'
*.log_archive_config='dg_config=(Tdweb20,sx3zhdb)'
*.log_archive_dest_1='location=/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=Tdweb20'
*.log_archive_dest_2='service=SX3ZHDB lgwr valid_for=(online_logfiles,primary_role) db_unique_name=sx3zhdb'
*.log_archive_format='%t_%s_%r.dbf'
*.log_file_name_convert='+DATDG/sx3zhdb/onlinelog','/u01/app/oracle/oradata/sx3zhdb/onlinelog','+FRA/sx3zhdb/onlinelog','/u01/app/oracle/oradata/sx3zhdb/onlinelog'
*.open_cursors=300
*.pga_aggregate_target=7175405568
*.processes=200
*.remote_login_passwordfile='exclusive'
*.sec_case_sensitive_logon=FALSE
*.sessions=225
*.sga_target=15084814336
*.standby_file_management='AUTO'
1、现在恢复后备库的数据库唯一名和主库的一样，备库的dest_1已经定义了，为什么没有读到？
2、这种情况下，是否需要重新恢复？
有没大神遇到过，谢谢指点
数据库版本为11.2.0.3 ，请参考：
11G RAC TO 11G RAC ADG配置
主要注意：DB_UNIQUE_NAME alter system set fal_server=Tdweb20 scope=both sid='*';
alter system set fal_client=sx3zhdb scope=both sid='*';
fal_*指定为tns
alter system set log_archive_dest_2='service=TDWEB20_SB lgwr valid_for=(online_logfiles,primary_role) db_unique_name=Tdweb20' scope=both sid='*';
这里的service=指定为tns
页:
[1]