An unusual case of recovery asking for an archived log from long time a go.

From: Paresh Yadav <>
Date: Wed, 15 Feb 2012 00:05:32 -0500
Message-ID: <>

I am trying to recover rman backups from one host to other (recover Oracle backups on RHEL-4, x86_64 to Oracle RHEL-5, x86_64). This is a test environment.
  • The database was changed to archivelog mode and (re)started on
  • 09-FEB-2012 21:29:40
  • I copied incremental level 0 backups taken on 2012-Feb-13 to the new host along with latest control file autobackup and archive logs till "now"
  • Recovered spfile from autobackup, converted to pfile, edited necessary parameters, converted back to spfile and started the instance in NOMOUNT mode
  • Recovered controlfile from autobackup
  • Cataloged backup pieces and archivelogs because they are in different location on the new host
  • Renamed redo log file members because they are in different location on the new host
  • Ran set new name (because the datafiles are in different location on the new host), restore database and switch all file commands in rman, *so far so good*
  • When I try to recover, the recovery is asking for an archived log sequence that was created from a time even before the database was started.

SQL> recover database using backup controlfile until cancel; -- FYI Sequence 57023 is from Feb 13 19:27 (o1_mf_1_57023_7mmbmq84_.arc) ORA-00279: change 371904991 generated at *02/08/2012 23:51:56* needed for thread 1
ORA-00289: suggestion :

  • I don't have this archive log ORA-00280: change 371904991 for thread 1 is in sequence #56645

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

*Of course cancelling will give me "file 1 was not restored from a sufficiently old backup"*

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/data/u01/oradata/AIS/system01.dbf'

ORA-01112: media recovery not started

I have tried this using one other incremental backup from Feb 11 too with same results.

Why is the recovery asking for that archive log from Feb 08 when the incremental level 0 backup is from Feb 13? Incremental 0 backups are suppose to be equivalent to full backups and as far as I read only difference between the two is that full backups can't be part of incremental backup cycles.

Thanks in advance.


Received on Tue Feb 14 2012 - 23:05:32 CST

Original text of this message