ORA-00309: log belongs to wrong database

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

sqlplus / as sysdba

show parameter config

dg_broker_config_file1               string                            /u01/oracle/product/11.2.0.4/db_1/dbs/dr1TEST_TESTHOST.dat
dg_broker_config_file2               string                            /u01/oracle/product/11.2.0.4/db_1/dbs/dr2TEST_TESTHOST.dat
log_archive_config                   string                            DG_CONFIG=(PRIMARY_PRODHOST,TEST_TESTHOST)

Check PRIMARY_PRODHOST and TEST_TESTHOST are correct Primary and Standby Hosts

  • October 4, 2016 | 14 views