Oracle RMAN full backup script for EMC NetWorker

In this article I’ll share an RMAN script to backup the entire Oracle database including archived redo logs to tape library using EMC NetWorker. Before looking into the script see my notes below:

– Read about Oracle Recovery Manager (RMAN) concepts
– Script should work for Oracle database 10g and 11g
Oracle database name = ORCL
– I use 2 RMAN channels to speed up the backup
– I backup intentionally control file manually and automatically
– I limit the size of backup sets by number of files per set and size of a backup set
– PARMS section includes instructions for EMC NetWorker server
– After the backup I allocate a maintenance channel crosschecking the backups
– I do not use backup compression in RMAN script, since it’s done on NetWorker server
– This script is independent from RMAN configuration parameters
– The script can be scheduled by EMC NetWorker server daily
Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email