Database Backup   «Prev  Next»
Lesson 4 Preparation for using RMAN
Objective Discuss the preparation involved in using RMAN.

Preparation for using RMAN

As with other Oracle tools, you have many options and decisions to make before you start to use Recovery Manager. Assuming that you decide to use Recovery Manager, your biggest decision is whether or not to have a recovery catalog. Every database environment is unique. As you start to manage multiple installations, your effort to support these sites becomes less manageable. One option to minimize your DBA work is to use RMAN with a recovery catalog.

Recovery catalog

The first major decision that you need to make is whether or not to use the recovery catalog. There are some benefits to the recovery catalog, such as using it to store frequently used scripts and to maintain historical information about your backup activities. Specific RMAN features that require the recovery catalog include:
  1. Tablespace point-in-time recovery
  2. Stored scripts
  3. Restore and recovery when the control file is lost

Control Files

If you do not elect to use a recovery catalog, you must protect your production database control files. This should be done by using multiplexed control files and by keeping them on separate disks. You must also maintain excellent backup records that identify which files are backed up and where each piece is stored. Oracle recommends that you use Recovery Manager with a recovery catalog.

Password files and OS file backup

Password files are used to protect your environment when using Recovery Manager with an unsecured Net8 connection. This may be the situation when you are using Recovery Manager to manage the backup of several databases from a remote location. This may also be the case when you are connecting to the production database with a TNS alias. You must back up the password files, init.ora files, and any operating system files required for the running of your production database.

Recovery Manager packages

When you run the catproc.sql script, you create several packages stored in the $ORACLE_HOME/rdbms/admin subdirectory:
  1. DMBS_RCVCAT is used to maintain information in the recovery catalog.
  2. DBMS_RCVMAN is used to query information from the production database control files or the recovery catalog.
  3. DBMS_BACKUP_RESTORE is used to interface with the operating system (OS).

For instance, on your Windows installation, these packages are stored in the C:\Oracle\rdbms\admin directory. In the next lesson, we will introduce a component of Oracle Enterprise Manager known as Backup Manager.

Recovery Manager Components

Click the link below to learn more about Recovery Manager.
Recovery Manager Components