DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.