Chat now with support
Chat with Support

NetVault Backup Plug-in for Oracle 11.3 - User Guide

Introducing Quest® NetVault® Backup Plug-in  for Oracle Defining a backup strategy Installing and removing the plug-in Configuring the plug-in Backing up data Using the Oracle® Flashback Database Restoring data
Restoring and recovering data: an overview Performing User Managed restores Using advanced User Managed restore procedures Performing RMAN restores Using RMAN types of recovery in a non-RAC environment Using advanced procedures with RMAN restores
Maintaining the Recovery Catalog Using the RMAN CLI Using the Plug-in with Oracle® RAC Using the Plug-in in a failover cluster environment Using the plug-in with Oracle® Data Guard Troubleshooting

Restoring Control Files

You can recover a Control File using one of the following options:

Restoring a Lost Copy of a Multiplexed Control File: Use this procedure to recover a database if a permanent media failure has damaged one or more Control Files of a database, and at least one Control File has not been damaged by the media failure. For more information, see Restore Lost Copy of a Multiplexed Control File in the Oracle® Database Backup and Recovery Advanced User’s Guide or to Responding to the Loss of a Subset of the Current Control Files in the Oracle Database Backup and Recovery User’s Guide for Oracle 11g.
Restoring a Control File from Backup After Loss of All Current Control Files: Use this procedure to restore a Backup Control File if a permanent media failure has damaged all Control Files of a database and you have a backup of the Control File.

When a Control File is inaccessible, you can start the Instance, but not mount the database. If you attempt to mount the database when the Control File is unavailable, you get the following error message:

You cannot mount and open the database until the Control File is accessible.

The plug-in saves a copy of the snapshot of the Control File to the Control File Save Filename (Full Path) specified on the Add, or Edit, Oracle Database dialog box. You can copy the Control File from this location if you lose all current Control Files. If the snapshot is not available in the Control File Save Filename (Full Path), you can restore it from the backup by performing the following steps:

The plug-in restores it to the Control File Save Filename (Full Path). The restored file has a “.SAV” extension.
For more information on restoring a Backup Control File, see Restoring a Backup Control File to the Default Location in the Oracle Database Backup and Recovery Advanced User’s Guide.

Understanding RMAN recovery

Review the following topics regarding RMAN recovery:

How RMAN backups are selected for use in recovery operations

When the plug-in performs RMAN-based restores, RMAN itself is performing the restores and recovery operations. RMAN uses the record of available backups in the RMAN repository to select the best available backups for use in the restore operation. This step simplifies the recovery process by eliminating the need for less-experienced personnel to determine the order in which backups should be restored.

Choosing between Incremental Backups and Redo Logs

If RMAN has a choice between applying an Incremental Backup or applying redo logs to the restored datafiles to meet a recovery objective, it always chooses an Incremental Backup. If overlapping levels of Incremental Backup are available, RMAN automatically chooses the one covering the longest period.

RMAN automatically restores the datafiles that it needs from available backups, applies Incremental Backups to the datafiles if they are available, and then applies archive logs.

Related Documents