Re: What am I missing with my RMAN archivelog backups

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Fri, 2 May 2014 16:27:45 -0500
Message-ID: <CAEueRAWjYrjWaMT5aFCfPmzmxbi2s_0EHY3G-VfTsHAQfodDeg_at_mail.gmail.com>

I usually trouble obsolete backup issues with REPORT NEED BACKUP. Try these commands:

REPORT NEED BACKUP; REPORT NEED BACKUP DEVICE TYPE SBT; REPORT NEED BACKUP RECOVERY WINDOW OF 5 DAYS; REPORT NEED BACKUP RECOVERY WINDOWS OF 10 DAYS; On Fri, May 2, 2014 at 3:38 PM, Michael Schmitt <mschmitt_at_uchicago.edu>wrote:

> Hello,
>
> One other detail. RMAN is not preventing me from deleting these archive
> backups either. They just do not show up on the "delete obsolete" command
> which I believe they used to. I apologize if I am spamming the list
>
>
> RMAN> delete backup completed before 'sysdate-52' device type sbt_tape;
>
> allocated channel: ORA_SBT_TAPE_1
> channel ORA_SBT_TAPE_1: SID=1570 device type=SBT_TAPE
> channel ORA_SBT_TAPE_1: Data Domain Boost API
>
> List of Backup Pieces
> BP Key BS Key Pc# Cp# Status Device Type Piece Name
> ------- ------- --- --- ----------- ----------- ----------
> 134 131 1 1 AVAILABLE SBT_TAPE
> C9TST_ARCH_0306_0ip2gfc3.bkp
> 135 132 1 1 AVAILABLE SBT_TAPE
> C9TST_ARCH_0306_0jp2gfc6.bkp
> 178 175 1 1 AVAILABLE SBT_TAPE
> C9TST_ARCH_0307_0kp2hkgc.bkp
> ....
> Do you really want to delete the above objects (enter YES or NO)? YES
> deleted backup piece
> backup piece handle=C9TST_ARCH_0306_0ip2gfc3.bkp RECID=18 STAMP=841497987
> deleted backup piece
> backup piece handle=C9TST_ARCH_0306_0jp2gfc6.bkp RECID=19 STAMP=841497990
> deleted backup piece
> backup piece handle=C9TST_ARCH_0307_0kp2hkgc.bkp RECID=20 STAMP=841536012
> deleted backup piece
> ........
> Deleted 19 objects
>
>
> -----Original Message-----
> From: Michael Schmitt
> Sent: Friday, May 02, 2014 3:00 PM
> To: 'rjoralist3_at_society.servebeer.com'
> Cc: ORACLE-L
> Subject: RE: What am I missing with my RMAN archivelog backups
>
> Hi Rich,
>
> We do nightly fulls. Every Monday we do a "keep until time '31'" as part
> of the database backup command to keep that backup for the month. Expected
> behavior from me is that this would result in ~31days of archivelog backups
> stored on tape due to this. I would also expect the archivelog backups to
> go obsolete after the databases are past their keep time. I should add,
> the databases backups are turning obsolete and being deleted as expected
>
> In this case, my oldest archivelog backup is March 6th. This is actually
> the day this database was created.
>
> Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
> ------- -- -- - ----------- --------------- ------- ------- ---------- ---
> 131 B A A SBT_TAPE 06-MAR-14 1 1 NO
> TAG20140306T132627
>
> And now my oldest full backup is April 7th
>
> Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
> ------- -- -- - ----------- --------------- ------- ------- ---------- ---
> 6650 B F A SBT_TAPE 07-APR-14 1 1 NO
> TAG20140407T080105
>
>
>
>
> -----Original Message-----
> From: Rich Jesse [mailto:rjoralist3_at_society.servebeer.com]
> Sent: Friday, May 02, 2014 2:36 PM
> To: Michael Schmitt
> Subject: RE: What am I missing with my RMAN archivelog backups
>
> Hey Mike,
>
> > CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE
> > DEFAULT DEVICE TYPE TO 'SBT_TAPE'; CONFIGURE ARCHIVELOG BACKUP COPIES
> > FOR DEVICE TYPE SBT_TAPE TO 1; # default CONFIGURE ARCHIVELOG DELETION
> > POLICY TO NONE; # default ........
> >
> > * All of the database backups are full level 0 backups.
> >
> > * Archivelogs are backed up with the following command " backup format
> > 'XXXX_ARCH_%M%D_%u.bkp' archivelog all not backed up 3 times;"
>
> How far apart are the fulls done? If, for example, they are 6d23h apart,
> RMAN will keep 13d22h, since it will need that ~2week-old full to restore
> an archivelog that's 7d old.
>
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Fri May 02 2014 - 23:27:45 CEST