Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN "delete obsolete" question

Re: RMAN "delete obsolete" question

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 11 Apr 2007 07:39:11 -0700
Message-ID: <1176302351.262305.221620@b75g2000hsg.googlegroups.com>


On Apr 11, 10:28 am, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> Target DB is 9.2.0.1
> Catalog is 10.2.0.2
>
> I have my retention policy configured to "recovery window of 30 days" on
> one of my databases but report/delete obsolete are listing backups that
> are < 30 days old. Also, there are many archived log backups > 30 days
> old that are not being picked up by report/delete obsolete. I can query
> them in the catalog with sqlplus and as far as I can tell, rman should
> be recognizing them as obsolete but it's not. What would cause this?
>
> TIA
>
> ===============RMAN output====================================
>
> RMAN> show all;
>
> RMAN configuration parameters are:
> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
> CONFIGURE BACKUP OPTIMIZATION ON;
> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
> CONFIGURE CONTROLFILE AUTOBACKUP ON;
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2;
> CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS
> 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpoc.opt)';
> CONFIGURE MAXSETSIZE TO UNLIMITED;
> CONFIGURE SNAPSHOT CONTROLFILE NAME TO
> '/oracle2/app/oracle/product/9.2.0/dbs/snapcf_PRD14.f'; # default
>
> RMAN> report obsolete;
>
> RMAN retention policy will be applied to the command
> RMAN retention policy is set to recovery window of 30 days
> Report of obsolete backups and copies
> Type Key Completion Time Filename/Handle
> -------------------- ------ ------------------ --------------------
> Backup Set 4632524 06-APR-07
> Backup Piece 4632526 06-APR-07 PRD142007040673iefaoi
> Backup Set 4659580 10-APR-07
> Backup Piece 4659582 10-APR-07 PRD14200704107oieps4r
> Backup Set 4663153 10-APR-07
> Backup Piece 4663154 10-APR-07 c-1453689907-20070410-00
>
> =============SQLPLUS Output============================================
> admin00:SQL>select db_key from rman.rc_database where name = 'PRD14';
>
> DB_KEY
> ----------
> 968946
>
> admin00:SQL>r
> 1 select backup_type, keep, count(*) from rman.rc_backup_set
> 2 where db_key = 968946
> 3 and completion_time < sysdate-31
> 4* group by backup_type, keep
>
> BACKUP_TYPE KEEP COUNT(*)
> ----------- ---- ----------
> L NO 323
> D NO 2

9.2.0.1?

How many complete backups are there within the last 30 days?

What kind of backups are they? Received on Wed Apr 11 2007 - 09:39:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US