Home » RDBMS Server » Backup & Recovery » archivelogs older than retention policy don't delete
archivelogs older than retention policy don't delete [message #364962] Wed, 10 December 2008 11:51
netamego
Messages: 1
Registered: December 2008
Junior Member
Hi:

Whe have three rman scripts. One for backups (scheduled on sundays) , one for archivelogs (scheduled everyday) and one
for "delete obsolete" (schedule everyday).

The older backup is in agreement with "RETENTION POLICY TO RECOVERY WINDOW OF 35 DAYS", so "delete obsolete" erase correctly database backups, what's more, i see in delete obsolete logs, erase of backups. The problem is that archivelogs backups, are no deleted and i have archivelogs older than three months, skiping the retention policy. According documentation, this only possible if there were a data file o controlfile older than retention policy (keep clause), but is not the case.

So, are there any bug about this. I have Oracle 10g.

list backup of database;
3089496 Full 318.50G SBT_TAPE 06:58:42 19/10/08
BP Key: 3089535 Status: AVAILABLE Compressed: NO Tag: TAG20081019T100110
Handle: BOX1P_81427_DB.bak Media:
List of Datafiles in backup set 3089496
...
...


list backup;
1570280 9.93G SBT_TAPE 00:07:49 16/06/08
BP Key: 1570295 Status: AVAILABLE Compressed: NO Tag: TAG20080616T115015
Handle: BOX1P__77096_ARCH.bak Media:
List of Archived Logs in backup set 1570280
...
...


[Updated on: Wed, 10 December 2008 12:09]

Report message to a moderator

Previous Topic: How to Remove Old Tape Backups
Next Topic: restore tables
Goto Forum:
  


Current Time: Sun Dec 08 07:35:42 CST 2024