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

  • October 4, 2016 | 14 views