Database Backup and Recovery (MOSC)

MOSC Banner

Archive log backups

edited Mar 14, 2012 10:46PM in Database Backup and Recovery (MOSC) 2 comments
We take Level 0 backup on Sunday , Level 1 on Thursday and rest are level 2 backups. We have manual standby database on different system ( archives automatically transferred to that box).  We use controlfile as the recovery catalog and the retention policy is 30 days ( recovery window of 30days).

My Database version is 11.2.0.1 on Windows 2008.

We use following RMAN script to backup / purge the archive logs for all Level 0/1/2 backups ...

SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP AS COMPRESSED backupset archivelog all NOT BACKED UP 1 TIMES;
DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE DISK;
Report Obsolete;
Delete noprompt expired backup;
delete noprompt obsolete;

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