Hi Howard, Thanks for your suggestion. Backup optimization is off. BTW - What was the solution in your case? Just turning off backup optimization or you figured out a workaround, solution? RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u03/flash_recovery_area/AIS/autobackup/%F'; CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE MAXSETSIZE TO 50 G; CONFIGURE ENCRYPTION FOR DATABASE OFF; CONFIGURE ENCRYPTION ALGORITHM 'AES128'; CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_AIS.f'; RMAN> Thanks, Paresh On Wed, Feb 15, 2012 at 8:52 AM, Howard Latham <howard.latham@xxxxxxxxx>wrote: > 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 > > > -- > //www.freelists.org/webpage/oracle-l > -- Thanks Paresh 416-688-1003 -- //www.freelists.org/webpage/oracle-l