Skip to Content
avatar image
Former Member

DR problem

Hi,

We are trying to switch database from standby to primary state. The problem arises, when we executed "alter database recover managed standby database finish;". System generated error, below;

Tue Jan 19 16:29:17 2010

alter database recover managed standby database finish

Tue Jan 19 16:29:17 2010

SKIP STANDBY LOGFILE option no longer needed for RECOVERFINISH. Option ignored

Managed Standby Recovery not using Real Time Apply

parallel recovery started with 3 processes

Media Recovery Waiting for thread 1 sequence 68128

Begin: Standby Redo Logfile archival

End: Standby Redo Logfile archival

Terminal Recovery timestamp is '01/19/2010 16:29:18'

Cannot recover datafiles with current logs containing different

Terminal Recovery Stamps (TRSTAMP). The datafiles must be

restored from backups to clear the TRSTAMP and then recovered

up to the current log.

Log file TRSTAMP: Count: 708712158l

Datafile #1: Count: 708619448l

Terminal recovery failed with error 16131

Recovery interrupted!

Tue Jan 19 16:29:20 2010

Media Recovery failed with error 16131

ORA-283 signalled during: alter database recover managed standby database finish...

Please find the steps below;

1) startup mount

2) register gaps and apply them

3) alter database recover managed standby database finish;

At this point we are facing with this problem,

Anybody have a suggestion?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 19, 2010 at 07:43 PM

    Hello Orkun,

    if possible please upload the complete alert.log of your standby database to a file hoster (like rapidshare) and post the link here.

    We need to know what you have done exactly before this error.

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 21, 2010 at 09:17 AM

    solved

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2010 at 05:22 AM

    What u did ?

    Add comment
    10|10000 characters needed characters exceeded