Home » RDBMS Server » Backup & Recovery » RMAN Not Removing Obsolete Backups ( - Windows Server 2003 R2 SP2)
RMAN Not Removing Obsolete Backups [message #420606] Mon, 31 August 2009 14:40 Go to next message
Messages: 19
Registered: January 2009
Location: NJ
Junior Member
RMAN is not removing obsolete backups, causing my flashback area to fill.

Only parameter I have changed in RMAN is: REDUNDANCY 5.
When I do a "crosscheck backup", it does find backups from 07/17/2009 and says they are still there (48 files, 90gig). I had just run a full backup using enterprise manager 1 hour ago..

When I run:

RMAN>delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 5
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=129 devtype=DISK
no obsolete backup found

Not sure where else to look. My archive logs are getting cleaned up just fine, so is the autobackup directory root. But items in the "backup" root of the flash_recovery_area are not getting obsoleted. I have done 5 backups since 7/31/09....so any files earlier than that should be deleted.

Any thoughts would help.


[Updated on: Mon, 31 August 2009 14:47]

Report message to a moderator

Re: RMAN Not Removing Obsolete Backups [message #420641 is a reply to message #420606] Tue, 01 September 2009 03:19 Go to previous message
Messages: 80
Registered: May 2007
Location: lahore


you have to shutdown your database then start it up in monut mode
hope it will solve your problem.
Do you have an idea?
what is meant redoudancy?

Previous Topic: Scheduling controlfile backup
Next Topic: creating test database
Goto Forum:

Current Time: Mon Aug 21 14:55:06 CDT 2017

Total time taken to generate the page: 0.16022 seconds