Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to recover from ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH

LANCERIQUESep 27 2015 — edited Oct 6 2015

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!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 3 2015
Added on Sep 27 2015
6 comments
3,668 views