This discussion is archived
4 Replies Latest reply: Nov 17, 2013 12:21 AM by 1001135 RSS

HELP : resetlogs doesn't work ...

1001135 Newbie
Currently Being Moderated

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 Expert
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points