Skip to Main Content

Database Software

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!

RMAN clean-up

441309Jun 12 2006 — edited Aug 8 2011
Hi,

I do the whole backup every day (full).
I want to keep the backups from yesterday and today and clean up backups from 2 days ago. (oracle 9i)
Can I put the delete backup at bottom of the same script like the following?
or should I setup a new script performing the clean up?
How can I verify the lastnight backup succeeded to perform a delete?

run
{
allocate channel CH1 device type disk format '/u01/egbkup/rman/%b_%u.bkp';
backup maxsetsize=1500m database plus archivelog delete all input;
backup spfile;
crosscheck backup
delete backup completed before 'sysdate-2' device type disk;
}

Thanks,
Amir
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2011
Added on Jun 12 2006
31 comments
37,833 views