Oracle RMAN recovery script for EMC NetWorker

June 27, 2016 by 6 Comments 

In this article I’ll share an Oracle RMAN script to do restore and recovery an Oracle database from tape library using EMC NetWorker. Apply this RMAN template to different recovery situations you might have. Before looking into the RMAN script see my notes below:

– Read about Oracle Recovery Manager (RMAN) concepts
– Look at the corresponding RMAN backup script for NetWorker
– The recovery script should work for Oracle database 11g, 12c (maybe 10g)
Oracle database name = ORCL
– I use 2 RMAN channels to speed up the recovery of database
– Recovery of spfile and/or control file is optional and depends on your recovery situation
– PARMS section includes instructions for EMC NetWorker server (depends on Networker server configuration)
– Choose appropriate database recovery scenario (by default -> compete DB recovery; I commented 3 options for incomplete DB recovery scenario)
– This script is independent from RMAN configuration parameters

Read more »

Oracle Recovery Manager (RMAN) concepts

June 27, 2016 by Leave a comment 

Recovery Manager (RMAN) is an Oracle utility that you use to manage the backup, restore, and recovery operations on Oracle database. RMAN has a powerful command language that is independent of the operating system.

Recovery Manager has a command-line interface. Oracle Enterprise Manager (OEM) also provides a graphical user interface for the Recovery Manager. Recovery Manager can be used on databases of Oracle8 or later releases.

RMAN provides several features not available when you make user-managed backups with operating system commands:

  • You can store frequently executed operations as scripts in the database.
  • Using the incremental block-level backup feature you can limit the backup to only those blocks that have changed since the previous backup. This may also reduce the time it takes to perform recovery operations in ARCHIVELOG mode.
  • You can use RMAN to manage the size of backup pieces and save time by parallelizing the backup operation.
  • RMAN operations can be integrated with the scheduling of the operating system to automate backup operations.
  • You can detect block corruption. The information relating to the block corruption that is detected during backup can be obtained by using the V$BACKUP_CORRUPTION and V$COPY_CORRUPTION dynamic views.
  • RMAN provides performance enhancements such as:

-Automatic parallelization of backup, restore, and recovery operations
-No generation of extra redo during online database backups
-Backups that are restricted to limit reads per file, per second to avoid interfering with OLTP work
-Prevention of flooding of any one file with reads and writes while still keeping a tape drive streaming, using multiplexing

  • RMAN has a media management API to work seamlessly with third-party media management tools interfacing with storage devices providing increased speed and reliability.
  • Under the user-managed method you need to keep track of all database files and backups. In a recovery situations you must locate backups for each datafile, copy them to the correct place using operating system commands, and choose which logs to apply. RMAN manages these tasks automatically.

Recovery Manager Components

Oracle recovery manager rman components

Oracle Recovery Manager (RMAN) components

Read more »

Oracle RMAN full backup script to disk with compression

April 12, 2013 by 9 Comments 

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

– Read about Oracle Recovery Manager (RMAN) concepts
– Script should work for Oracle 10g and 11g, 12c
Oracle database name = ORCL
– I use 4 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 backup sets
– I use backup compression in RMAN script (Oracle Advanced Compression license is required)
– The average compression factor can be different but to give you an idea it can be around 7.
– This script is independent from RMAN configuration parameters
Read more »

Oracle RMAN full backup script for EMC NetWorker

April 6, 2013 by 11 Comments 

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