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!

deleting backups

KDL1981Jul 19 2010 — edited Jul 21 2010
Hi,

i am interested in setting up automatic deletion of backups on disk, after copied to tape.
level 0 full backup done end of week and incrementals done daily.
i want to delete incrementals on disk that were taken before 7 days , i.e before the last level 0

should i use:
run{
DELETE BACKUP COMPLETED BEFORE 'SYSDATE-7' DEVICE TYPE DISK;
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-7';
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE FILESPERSET 4 PLUS ARCHIVELOG;
}

or should i do it this way:

run{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS
CROSSCHECK BACKUP;
DELETE OBSOLETE;
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE FILESPERSET 4 PLUS ARCHIVELOG;
}

which is oracle recommended? or will both work?

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2010
Added on Jul 19 2010
4 comments
1,393 views