Database Backup and Recovery (MOSC)

MOSC Banner

UNABLE TO DELETE BACKUPS AFTER A FULLBACKUP WITH THE KEEP UNTIL OPTION.

Our table libraries are running out of space because normal backups of the archive logs with a retention of 2 weeks are not being deleted with the "delete obsolete" command. Every end of the month we run a full backup with the keep option enabled. This backupset remains until its keep time expires which is the correct and expected behavior. But it seems it prevents the archivelog backups after it to be cancelled. We need to cancel all the tons of archivelog backups in between the FULL KEEP backups.

run

{

allocate channel t1 type 'SBT_TAPE';

allocate channel t2 type 'SBT_TAPE';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center