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
Messages: 1
Registered: December 2008
Junior Member

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: Tue Oct 25 10:55:29 CDT 2016

Total time taken to generate the page: 0.10098 seconds