RE: What am I missing with my RMAN archivelog backups
- From: Michael Schmitt <mschmitt@xxxxxxxxxxxx>
- To: Michael Schmitt <mschmitt@xxxxxxxxxxxx>, "rjoralist3@xxxxxxxxxxxxxxxxxxxxx" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 2 May 2014 20:38:28 +0000
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@xxxxxxxxxxxxxxxxxxxxx'
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@xxxxxxxxxxxxxxxxxxxxx]
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
