standby database recovery error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: standby database recovery error

  1. #1
    Join Date
    Aug 2000
    Posts
    21

    standby database recovery error

    Hi
    I am getting the following error while using the following command.

    our standby database was not operational for the last 2 months for some issues, but I am starting it now after copying all from the primary server.

    all the arcive files are moved out of the ARCHIVE folder and I have only this month's archive files in the folder.

    I need to start this in readonly mode and show them that the standby is working.

    How do I recover to date and start it? could some body give me any clue!!!

    -----------------------------------------------------
    SQL> recover standby database;
    ORA-00279: change 7524911449 generated at 04/24/2007 18:13:58 needed for thread
    1
    ORA-00289: suggestion : G:\ARCHIVE\ARC51607_0557592862.001
    ORA-00280: change 7524911449 for thread 1 is in sequence #251607


    ORA-00308: cannot open archived log 'G:\ARCHIVE\ARC51607_0557592862.001'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.


    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01195: online backup of file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\SYSTEM01.DBF'
    ---------------------------------------------------------------


    Thanks in advance
    BSR

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    It looks like there is an archivelog gap and those archive logs are missing. ( see Oracle is looking for a file created on ORA-00279: change 7524911449 generated at 04/24/2007 ). Check this archivelog availability, and if not existing, re-create the Standby DB back again.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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