ORA-16047: DGID mismatch between destination setting and standby
427492Feb 9 2007 — edited Feb 9 2007Based on the Data Guard documentation and the given example, this is what I have:
Primary init.ora:
*.db_name='wcati10'
*.db_unique_name=wcati10
*.log_archive_config='DG_CONFIG=(wcati10,npc)'
*.log_archive_dest_1='LOCATION=/webcatiprod1_db_misc/wcati10/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=wcati10'
*.log_archive_dest_2='SERVICE=npc.tmo LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=npc'
*.fal_server=npc.tmo
*.fal_client=wcati10.tmo
*.db_file_name_convert=('/oracleapps_db2/','/webcatiprod1_db2')
*.log_file_name_convert=('/oracleapps_db0/','/webcatiprod1_db0/','/oracleapps_db1/','/webcatiprod1_db1')
*.standby_file_management=auto
Standby init.ora:
*.db_name='wcati10'
*.db_unique_name=npc
*.log_archive_config='DG_CONFIG=(wcati10,npc)
*.log_archive_dest_1='LOCATION=/oracleapps_db_misc/wcati10/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=npc'
*.log_archive_dest_2='SERVICE=wcati10.tmo LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=wcati10'
*.db_file_name_convert=('/webcatiprod1_db2/','/oracleapps_db2/')
*.log_file_name_convert=('/webcatiprod1_db0','/oracleapps_db0/','/webcatiprod1_db1','/oracleapps_db1/')
*.fal_server=wcati10.tmo
*.fal_client=npc.tmo
*.standby_file_management=auto
Am I missing something?
Thanks.
added more parameters.
Message was edited by:
FeNiCrC_Neil