Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-16047: DGID mismatch between destination setting and standby

427492Feb 9 2007 — edited Feb 9 2007
Based 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2007
Added on Feb 9 2007
0 comments
316 views