4 Replies Latest reply: Nov 17, 2013 2:21 AM by 1001135 RSS

    HELP : resetlogs doesn't work ...

    1001135

      Hello,

      after "restore database" from a rman backup, the "recover until time"  and "open resetlogs" don't work.

       

      ALTER DATABASE RECOVER  database until time '2013-11-13:21:04:09'  using backup controlfile;

      ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

      ORA-01194: file 2 needs more recovery to be consistent

      ORA-01110: data file 2: '/oracle/HO6/sapdata6/crm09d_101/crm09d.data101'

      I assume that these messages are warning and aren"t critical. (Am I wrong ?)

      In the alert.log, we can see :

      Incomplete Recovery applied until change 209677033553 time 11/13/2013 21:04:09

      Media Recovery Complete (HO6)

       

      I check the header datafiles from v$datafile_header, all datafiles have change the same checkpoint_change# and checkpoint_time as specified above in the alert.

      But resetlogs failed.

      alter database open resetlogs

      ORA-1194 signalled during:  alter database open resetlogs...

       

      How can this occur ?

      I don't understand why "open resetlogs" doesn't work, when ALL the datafile are recovered until the same SCN !!

       

      $ oerr ora 1194

       

      01194, 00000, "file %s needs more recovery to be consistent"

       

      // *Cause: An incomplete recovery session was started, but an insufficient

       

      // number of logs were applied to make the file consistent. The

       

      // reported file was not closed cleanly when it was last opened by

       

      // the database. It must be recovered to a time when it was not being

       

      // updated. The most likely cause of this error is forgetting to

       

      // restore the file from a backup before doing incomplete recovery.

       

      // *Action: Either apply more logs until the file is consistent or restore

       

      // the file from an older backup and repeat recovery.

       

       

      So, please help.

      Thank in advance,

        • 1. Re: HELP : resetlogs doesn't work ...
          Anar Godjaev

          HI,

          ALTER DATABASE RECOVER  database until time '2013-11-13:21:04:09'  using backup controlfile;

          ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

          ORA-01194: file 2 needs more recovery to be consistent

          ORA-01110: data file 2: '/oracle/HO6/sapdata6/crm09d_101/crm09d.data101'

           

           

           

          Please check Oracle support id : DATAFILE NEEDS MORE RECOVERY TO BE CONSISTENT ORA-1194 ORA-1547 ORA-1110 (Doc ID 1528788.1)

           

          Thank you

          • 2. Re: HELP : resetlogs doesn't work ...
            1001135

            Thank you very much for this very interesting answer.

            I read the suggested metalink note, and I found this note very usefull.

             

            but, in this note, I found that we cannot open resetlogs the database after recover until ANY or ANY SCN ...

            and this is what I don'understand ...

            for me, if all datafiles are covered until one SCN, we can open database with resetlogs.

            because, on every SCN the database is in consistent state.

            Am I wrong ?

            • 3. Re: HELP : resetlogs doesn't work ...
              saratpvv

              Can you post the result

              select distinct  checkpoint_change#  from v$datafile_header;

              select hxfil file_id, fhscn scn, fhthr thread, fhrba_seq sequence, fhsta status from x$kcvfh

              • 4. Re: HELP : resetlogs doesn't work ...
                1001135

                Hello, too late the database was recovered until a sufficient SCN and opened with reserlogs.

                I Will open another post to speak about why we cannot recover until any scn.

                thanks for all.