Friday, 30 November 2012

ORA-16047: DGID mismatch between destination setting and standby



ORA-16047: DGID mismatch between destination setting and standby



SQL> show parameter config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/orcl11g/
                                                 11.2.0/dbs/dr1inc04p.dat
dg_broker_config_file2               string      /u01/app/oracle/orcl11g/
                                                 11.2.0/dbs/dr2inc04p.dat
log_archive_config                   string





See the last parameter was not set on standby database that is why i was receiving the error.

ORA-16047: DGID mismatch between destination setting and standby

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

solution: set the parameter 


No comments:

Post a Comment