new_db 发表于 2014-10-30 09:58:08

搭建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、这种情况下,是否需要重新恢复?
有没大神遇到过,谢谢指点

xifenfei 发表于 2014-10-30 10:05:18

数据库版本为11.2.0.3 ,请参考:
11G RAC TO 11G RAC ADG配置

主要注意:DB_UNIQUE_NAME

xifenfei 发表于 2014-10-30 10:13:10

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]
查看完整版本: 搭建rac环境DG,备库日志无法同步