Re: An unusual case of recovery asking for an archived log from long time a go.
Date: Wed, 15 Feb 2012 10:45:12 -0500
Message-ID: <CAPXEL0+-R3Qvu_P2iS9FYVOYOVVeL2iNfT=huhTz7=gpJOkSpA_at_mail.gmail.com>
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_at_gmail.com>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_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
>
-- Thanks Paresh 416-688-1003 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 15 2012 - 09:45:12 CST