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

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

1 comment:

Sridevi Koduru (Oracleappstechnical.com) said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.