Hi Gurus,
I have mistakenly hit ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH on standby.
I want to make it back to normal standby. Whenever I am starting recovery, its giving below errors. Can somone please help here.
DB - 11.2.0.2. (Enterpirse edition)
Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 8 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log +DG_ARCH/ch_ptpsprd/archivelog/2015_09_27/thread_1_seq_181466.1196.891494015
Identified End-Of-Redo (failover) for thread 1 sequence 181466 at SCN 0x25.518a862a
Resetting standby activation ID 0 (0x0)
Incomplete Recovery applied until change 160281822762 time 09/27/2015 02:07:04
MRP0: Background Media Recovery applied all available redo. Recovery will be restarted once new redo branch is registered
Errors in file /opt/app/oracle/diag/rdbms/ch_ptpsprd/PTPSPRD1/trace/PTPSPRD1_pr00_23680.trc:
ORA-19906: recovery target incarnation changed during recovery
Recovery interrupted!