DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2000

    standby database recovery error

    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
    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

  2. #2
    Join Date
    Apr 2001
    Bangalore, India
    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)


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.