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

From: Howard Latham <howard.latham_at_gmail.com>
Date: Wed, 15 Feb 2012 05:52:01 -0800
Message-ID: <4196922402140849601_at_unknownmsgid>

I had this when I tried to duplicate a db. Is backup optimisation turned on may be the problem.

Sent from my Nascom I
From: Paresh Yadav
Sent: 15/02/2012 05:07
To: oracle-l_at_freelists.org
Subject: An unusual case of recovery asking for an archived log from long time a go.
Hi,
I am trying to recover rman backups from one host to other (recover Oracle 10.2.0.1 backups on RHEL-4, x86_64 to Oracle 11.2.0.3.0 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 :
/data/u03/flash_recovery_area/AIS/archivelog/2012_02_14/o1_mf_1_56645_%u_.arc

• 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"*

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

-- 
Thanks
Paresh
416-688-1003


--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 15 2012 - 07:52:01 CST