Hi DBAs,
During an audit I discovered that one of the preprod DB was down. After checking logs couldn't find anything that made the DB down.
So I started the primary DB and after that wanted to recover the standby DB.
Here's what I did:
Following error occurs in preprodDB alert log file and MRP0 process shutdowns automatically and recovery not happening:
after starting the standby DB by following commands:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.0689E+11 bytes
Fixed Size 2240984 bytes
Variable Size 1.0657E+11 bytes
Database Buffers 268435456 bytes
Redo Buffers 55267328 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Database altered.
After this I saw the alert logs and found DB is automatically cancelling the recovery with following error logs:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
Attempt to start background Managed Standby Recovery process (preprodDB)
Wed Nov 12 11:38:52 2014
MRP0 started with pid=33, OS id=124345
MRP0: Background Managed Standby Recovery process started (preprodDB)
started logmerger process
Wed Nov 12 11:38:57 2014
Managed Standby Recovery starting Real Time Apply
Warning: Recovery target destination is in a sibling branch
of the controlfile checkpoint. Recovery will only recover
changes to datafiles.
Datafile 1 (ckpscn 12017964846227) is orphaned on incarnation#=2
MRP0: Detected orphaned datafiles!
Recovery will possibly be retried after flashback...
Errors in file /u01/app/oracle/diag/rdbms/preprodDB/preprodDB/trace/preprodDB_pr00_124347.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/u02/app/oracle/DATA/preprodDRDB/preprodDB/system01.dbf'
Managed Standby Recovery not using Real Time Apply
Slave exiting with ORA-19909 exception
Errors in file /u01/app/oracle/diag/rdbms/preprodDB/preprodDB/trace/preprodDB_pr00_124347.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/u02/app/oracle/DATA/preprodDRDB/preprodDB/system01.dbf'
Recovery Slave PR00 previously exited with exception 19909
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
Wed Nov 12 11:39:17 2014
MRP0: Background Media Recovery process shutdown (preprodDB)
Wed Nov 12 11:42:05 2014
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=MEMORY;
Wed Nov 12 11:42:30 2014
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
ORA-16136 signalled during: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL...
Please help in syncing the DB with primary.
Regards,
Ritz