NetVault Plug-in for Oracle 10.0.5

An RMAN Full Backup is a backup of a datafile that includes every allocated block in the file being backed up. A Full Backup of a datafile can be an image copy, in which case every data block is backed up. You can also store it in a backup set, in which case datafile blocks not in use may be skipped. An RMAN Full Backup cannot be part of an Incremental Backup strategy, that is, it cannot be the parent or base of a subsequent Incremental Backup.

Incremental Backup

An Incremental Backup of a datafile captures images of blocks in the datafile that have changed since a specific point, usually the time of a previous Incremental Backup. Incremental backups are smaller than full datafile backups, unless every block in the datafile is changed. RMAN Incremental Backups are only available for datafiles.

During media recovery, RMAN uses the block images from Incremental Backups to update changed blocks to their contents at the SCN where the block was created. RMAN completes this process in a single step. Without Incremental Backups, all changes must be applied one at a time from the archived redo logs. To reduce downtime, RMAN always chooses an Incremental Backup over reapplying individual changes stored in archived redo logs.

Multilevel Incremental Backups

RMAN’s Incremental Backups are multilevel. Each incremental level is denoted by a value of 0 or 1.

•

Level 0 Incremental Backup: A Level 0 Incremental Backup, which is the base for subsequent Incremental Backups, copies all blocks containing data, backing up the datafile into a backup set just as a Full Backup would.

The only difference between a Level 0 Incremental Backup and a Full Backup is that a Full Backup cannot be included in an incremental strategy.

•

Level 1 Incremental Backup: A Level 1 Incremental Backup can be either of the following types:

•

Cumulative Incremental Backup: In a Cumulative Incremental Backup, RMAN backs up all the blocks used since the most recent Level 0 Incremental Backup. Cumulative Incremental Backups speed up restores by reducing the number of Incremental Backups you need to include in the recovery process. Cumulative Backups require more space and time than Differential Backups because they duplicate the work done by previous backups at the same level.

Cumulative Backups are preferred over Differential Backups when recovery time is more important than disk space, because fewer Incremental Backups need to be applied during recovery.

•

Differential Incremental Backup: In a Differential Incremental Backup, RMAN backs up all blocks that have changed since the most recent Cumulative or Differential Incremental Backup, whether at Level 1 or Level 0.

RMAN determines which Level 1 backup occurred most recently and backs up all blocks modified since that backup. If no Level 1 is available, RMAN copies all blocks changed since the Level 0 backup.

Differential Incremental Backups lead to longer restores because multiple Incremental Backups must be applied during recovery.

Archive Log backup

Archived redo logs are important for PIT Recovery and must be backed up regularly. You can back up the archive logs separately or together with the datafiles and other supported files. The plug-in also provides the option to force an additional log switch before backing up the archive logs and the option to delete the archive logs from the disk after backing them up to the backup sets.

Reviewing the Control File backup types

Protecting the Control File is critical in many recovery situations. Plug‑in for Oracle provides two methods for protecting the Control File: Manual Backups and Autobackups. However, when using the RMAN method, you can perform either Control File Autobackups or Manual Backups but not both. When the Control File Autobackups are enabled for a database, Manual Control File Backups are not available.

Manual Backups of Control File

The User Managed and RMAN backup methods both support Manual Backup of the Control File.

•

Manual Backup of Control File with User Managed backup method: With the User Managed backup method, the plug-in does not use the active Control File for backup and restore. During backup, the plug-in saves a snapshot of the Control File to the user-specified Control File Save Filename (Full Path), and then backs up this copy of the Control File. This process ensures that a consistent copy of the Control File is protected. During restoration, the plug-in restores the Control File to the Control File Save Filename (Full Path) to ensure that the active Control File is not inadvertently overwritten. You must manually copy this file to the original location as required. To ensure that a recent copy of the Control File is always available, include it with each User Managed backup.

•

Manual Backup of Control File with RMAN backup method: When Control File Autobackups are disabled and the Control File node is explicitly selected on the NetVault Backup Selections page, the plug-in uses RMAN’s BACKUP CURRENT CONTROLFILE to back up the Control Files. To ensure that a recent copy of the Control File is always available, include it with each RMAN backup.

Autobackups of Control File

An Autobackup of the Control File also includes the SPFILE. The Autobackups are made after every RMAN-based backup or after making structural changes to the database. Structural changes include adding a tablespace, altering the state of a tablespace or datafile, adding an online redo log, renaming a file, adding a redo thread, and so on.

Manual vs. Autobackups

A Manual Control File backup lets you restore a specific copy of a Control File. This option is ideal when data corruption has occurred and you need to restore the version most recently saved before data corruption. You are responsible for ensuring that the Control File is backed up with every RMAN-based backup and after every database structural change. While Manual Control File backups offer the ability to restore specific Control File backups, they cannot be used during disaster recovery or in multi-instance RAC environments.

Control File Autobackups provide the most reliability to ensure that there is always a recent backup of the Control File. In addition, they are required for disaster recovery and in multi-instance RAC environments.

Reviewing the other backup types

Other backup types include:

•

Duplicate Database backup

•

Flash Recovery Area (FRA) backups

Duplicate Database backup

A Duplicate Database backup lets you duplicate or clone a source database for special purposes that must not affect the overall backup and restore procedures for the source database. RMAN supports duplicating databases to increase a DBA’s flexibility when performing the following tasks:

•

Testing backup and recovery procedures.

•

Testing an upgrade to a new release of Oracle® Database.

•

Testing the effect of applications on database performance.

•

Generating reports.

For example, you can duplicate the production database on hostA to hostB, and then use the duplicate database on hostB to practice restoring and recovering this database without damaging the production database.

The plug-in’s support for Oracle’s Database Duplication is backup-based duplication. For additional information on Oracle’s Duplicate Database functionality, see Duplicating a Database in the Oracle Database Backup and Recovery User’s Guide.

Flash Recovery Area (FRA) backups

Oracle® introduced FRA in Oracle 10g. FRA is a disk location used to store recovery-related files such as Control Files, archived redo logs, and RMAN backups. Oracle and RMAN manage the files in the FRA automatically.

An FRA minimizes the need to manage disk space manually for backup-related files and balance the use of space among the different types of files stored in the FRA. In this way, FRA simplifies the ongoing administration of your database. Oracle recommends that you enable a recovery area to simplify backup management.

Enabling FRA can speed up restores by enabling RMAN to restore the needed datafiles from the FRA versus restoring the files from backup media managed by NetVault Backup. However, storing backups in the FRA does not provide you with offsite protection for disaster recovery protection. Therefore, the plug-in provides the following Backup Destination options when FRA is enabled for the database:

•

Tape (Backup to NetVault Backup Media)

•

Disk (Backup to FRA)

•

Both Tape and Disk (Backup to FRA then Backup FRA to NetVault Backup Media)

Additionally, the plug-in lets you perform a separate backup of the backup recovery files stored in the FRA-to-backup media managed by NetVault Backup. Backup recovery files include: Full and Incremental Backup sets, Control File Autobackups, datafile copies, and archived redo logs. If an archived redo log file is missing or corrupted, RMAN looks outside the recovery area for a good copy of the log that it can use for the backup. Flashback logs, the current Control File, and online redo logs are not backed up.