Skip to Content
avatar image
Former Member

Oracle Database Recovery not successful

Hello Experts,

We are running on Oracle 11 and planning for a restore and recovery from PRD to QAS

We had a successful online backup in our PRD system and Archive logs are also available.

However, as a pre-requisite step we did not generate Control file in PRD before trigger of online backup and proceeded with the Oracle restore in QAS.

We had online backup of PRD which was completed @ 5:00 AM, however we have generated Control file in PRD @ 3 PM post completion of online backup to use it in QAS


Below are the steps we did to restore data in QAS but unsuccessful in Recovery:

We had deleted all the files in QAS

Placed PRD files in QAS and changed the SID respective to QAS.

There are no addition of data files after online backup, so we generated control file in PRD after the completion of online backup and used to recover database using command "Recover database using backup controlfile until cancel;" (Changed contents of control as usual)

However, system is continuously requesting for Archive log files which are not even generated in PRD yet

Below is the error: (initially requested for archive sequence 1111. After giving 1111, it is again asking for 1112)

ORA-00279: change 504756556 generated at 06/21/2016 22:05:47 needed for thread 1

ORA-00289: suggestion : /oracle/QAS/oraarch/QASarch1_1112_857256673.dbf

ORA-00280: change 504756556 for thread 1 is in sequence #1112

ORA-00278: log file '/oracle/QAS/oraarch/QASarch1_1111_857256673.dbf' no longer

needed for this recovery

ORA-00308: cannot open archived log

'/oracle/QAS/oraarch/QASarch1_1112_857256673.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Could you please assist on how to proceed further?

Thanks,

Subbu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 22, 2016 at 08:55 AM

    Hi, if the archive logs don't exist, issue the command "cancel" then open the database with the resetlogs option: "alter database open resetlogs".


    You can also check if the file 1112 wasn't archived yet - issue the following command at the source (PRD) system.

    select sequence# from v$log where status= 'CURRENT';

    Then you can issue the command "ALTER SYSTEM SWITCH LOGFILE;" and copy the archive logs to QAS system.


    Regards,

    André Nunes

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2016 at 06:23 PM

    Hi,

    If you have the file 1112,  then you have to copy the file to the proper location and issue the recover command.  If there are no more logfiles, it is time for you to open the database with the "alter database open resetlogs" command.  But remember, once you opened the database, you will not be able to re-start the recovery.

    thanks

    Samson

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2016 at 10:35 PM

    Hi,

    Once the recovery session is cancelled due to unavailability of archive log, fire "alter database open resetlogs".

    It will alter your database and opens it in read/write mode for use.

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded