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

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@xxxxxxxxxxxxx
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


Other related posts: