Database Backup and Recovery (MOSC)

MOSC Banner

best way to delete old RMAN backups

edited May 1, 2014 8:24AM in Database Backup and Recovery (MOSC) 3 commentsAnswered

Hi, I have setup the RMAN retention policy to recovery window of 35 days and controlfile file keep time is 35 days. I am using the RMAN in not catalog mode and backing up to the SBT_TAPE. I need to delete  backups older than 35 days and I am using the below scripts. Please suggest me. Is it correct method or not?

run {
allocate channel ch1 type 'sbt_tape'
parms='BLKSIZE=1048576,SBT_LIBRARY=$ORACLE_HOME/lib/libddobk.so,ENV=(STORAGE_UNIT=unit_name,BACKUP_HOST=host_name)';

delete noprompt obsolete;
crosscheck backup;

RELEASE CHANNEL ch2;
}

Thanks

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