Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can't delete old backup files in RMAN

user482717Jun 26 2006 — edited Jun 28 2006
I have this problem for the past 2 weeks.
I can't delete the old backup files in RMAN. I do crosscheck backup, and crosscheck backupset. all the files are marked available.
If I choose to crosscheck backupset 1125, 1126. it will check them as expired, and I can delete. Otherwise, when I do
delete obsolete
it shows me,
RMAN retention policy is set to redundancy 1
no obsolete backups found

I have about 10 dates of backup. I can delete them manually, but that is not quite what I want. I want them to be deleted when i am doing my rman backup.
Thank you very much.
Here is my rman per script:

$rman_script="backup device type disk filesperset = 1 tag '%TAG' database;
backup device type disk filesperset = 1 tag '%TAG' archivelog all delete all input;
allocate channel for maintenance type disk;
crosscheck backupset;
delete noprompt obsolete device type disk;
release channel;
";
$result = backup();
exit($result);

thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2006
Added on Jun 26 2006
16 comments
3,843 views