Database Backup and Recovery (MOSC)

MOSC Banner

RMAN backup maintenance

edited Oct 27, 2010 11:22PM in Database Backup and Recovery (MOSC) 4 commentsAnswered
We have RMAN backups scheduled to run incremental level 0 full on Sundays and incremental level 1 on weekdays. The generic RMAN backup script is as follows:
{
backup
 incremental level $LEVEL
 database plus archivelog
 delete input filesperset 1;
 release channel d1;
}

We also run a maintenance script to clear the records in recovery catalog. The contents of the maintenance script are as follows:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 21 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE disk;
CROSSCHECK BACKUP;
REPORT OBSOLETE RECOVERY WINDOW OF 21 DAYS;

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