DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Tuesday, October 4, 2016

ORA-00309: log belongs to wrong database

ORA-00309: log belongs to wrong database
The system cannot access the archived redo log because it belongs to another database.
Specify the correct redo log file, then retry the operation.

sqlplus / as sysdba

show parameter config

dg_broker_config_file1               string                            /u01/oracle/product/
dg_broker_config_file2               string                            /u01/oracle/product/
log_archive_config                   string                            DG_CONFIG=(PRIMARY_PRODHOST,TEST_TESTHOST)

Check PRIMARY_PRODHOST and TEST_TESTHOST are correct Primary and Standby Hosts

1 comment:

Sridevi Koduru ( said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.