Standby database recovery Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Standby database recovery

  1. #1
    Join Date
    Aug 2010

    Standby database recovery

    Hi ,
    i got the following error message while opening the standby database..,

    SQL> startup mount
    ORACLE instance started.

    Total System Global Area 535662592 bytes
    Fixed Size 1334380 bytes
    Variable Size 167773076 bytes
    Database Buffers 360710144 bytes
    Redo Buffers 5844992 bytes
    Database mounted.
    SQL> alter database recover managed standby database disconnect from session;

    Database altered.

    SQL> recover managed standby database cancel;
    Media recovery complete.
    SQL> alter database open read only;
    alter database open read only
    ERROR at line 1:
    ORA-16004: backup database requires recovery
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'G:\APP\WHITYS\ORADATA\ORCLSBY1\SYSTEM01.DBF'

    SQL> recover database;
    ORA-00283: recovery session canceled due to errors
    ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

    SQL> recover database using backup controlfile;
    ORA-00283: recovery session canceled due to errors
    ORA-01666: control file is for a standby database

    pls send me the solution for my problem.....

  2. #2
    Join Date
    Sep 2002
    well you need to apply more archive logs, in the first command you cancelled it - why?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width