Database Backup and Recovery (MOSC)

MOSC Banner

remove old incarnation and subsequent backup metadata from rman catalog

edited Sep 16, 2015 10:04PM in Database Backup and Recovery (MOSC) 10 commentsAnswered

Hi dba's

I'm cleaning my rman catalog and found old incarnation backup metadata that I cannot delete.

The rman cleanup script used does the following:

...allocate channels...

configure retention policy to recovery window of 28 days;

configure controlfile autobackup on;

crosscheck backup of database completed before 'sysdate - 28';

crosscheck backup of archivelog all completed before 'sysdate -28';

report obsolete recovery window of 28 days device type 'sbt';

delete force noprompt obsolete recovery window of 28 days device type 'sbt';

delete backup of database completed before 'sysdate-28';

delete backup of archivelog all completed before 'sysdate-28';

backup current controlfile;

...release channels...

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