Search This Blog

Friday, September 30, 2011

ORA-16047: DGID mismatch between destination setting and standby

SQL> show parameter config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /db/app/oracle/Db_1/dbs/dr1ORC
                                                 LDG.dat
dg_broker_config_file2               string      /db/app/oracle/Db_1/dbs/dr2ORC
                                                 LDG.dat
log_archive_config                   string
You can see the last parameter was not set on standby database that is why i was receiving error.
ORA-16047: DGID mismatch between destination setting and standby

Reason: the log archive config parameter wasnot set on standby db.

solution: set the parameter 

2 comments:

Anonymous said...

Wonderful work! This is the type of information that are
supposed to be shared around the web. Shame on the seek engines for not positioning
this put up upper! Come on over and discuss with my web site .
Thank you =)

My blog post :: real hcg drops gnc

Anonymous said...

Thanks mate, this helped me fix my issue today.