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 data

When performing restores in a Data Guard environment where the backup is being restored to the same Database Server where the backup was taken, there is no difference between performing the restore in a Data Guard environment or a non-Data Guard environment. For more information on single-instance environments, see Performing RMAN restores. For more information on multi-instance environments, see Restoring data in a RAC environment.

When performing restores in a Data Guard environment where the backup is restored to an alternate Database Server in the Data Guard environment, the restore is identical to restoring to the same Database Server except for the differences detailed in the following topics.

Configuring a restore to an alternate server in a Data Guard environment

When performing backups from either the Primary or Standby Database Server, the index for the backup is stored in the NetVault Database under the NetVault Backup Client Name of the Database Server where the backup was performed. To restore to an alternate Database Server, the plug-in configuration of the alternate (target) server of the restore must be modified to specify the name of the source NetVault Backup Client.

To configure the backup taken from NetVault Backup Client option, perform the following steps.

1
In the Navigation Pane, click Create Backup Job, and click Create New next to the Selections list.
3
From the Actions list, select Configure.
4
On the Configure dialog box, complete the Restore Backup taken from NetVault Backup Client field by specifying the NetVault Backup Machine Name for the alternate or target Database Server.

Restoring data to an alternate server in a Data Guard environment

When performing restores in a Data Guard environment where the backup is restored to an alternate Database Server, the process is nearly identical to restoring to the same Database Server. The differences are described in the following topics.

To restore a backup that used the User Defined Backup Tag option, perform the following steps.

1
On the Restore Options tab, select the Restore/Recover from User Defined Backup Tag check box.
On the Create Restore Job page, use the Target Client list to select the NetVault Backup Machine Name of the alternate or target Database Server for the restore.

Recovering Whole Database to Primary Database Server

This type of recovery is performed when the current Control File and SPFILE are intact but all the datafiles are damaged on the Primary Database Server, and the backup from the Standby Database Server is used for the recovery. You can perform a Complete Recovery or recover the database to a specific point.

An overview of the process to recover the whole database from a backup of the Standby to the Primary Database Server follows.

1
On the Create Restore Job — Choose Saveset page, find the latest available backup on the Standby Database Server that included all the tablespaces, and click Next.
2
On the Create Selection Set page, select the Whole Database node, and click Edit Plugin Options.
3
Click the Restore Options tab, and then select the following:
In the Pre-Restore Options section, select Whole Database Restore.
In the Restore Options section, select Restore/Recover from User Defined Backup Tag, and specify the User Defined Backup Tag for the Standby Database Server.
Perform Complete Recovery: Recovers the database to the current time, that is, to the last committed transaction available in the archived and online redo logs.
Perform Database Point in Time Recovery: Recovers the database to a specific point-in- time, whether it is a specific time, log sequence number, or SCN.
5
On the Recovery Catalog tab, select the Use Catalog option, and specify the Recovery Catalog connection details.
6
If the Oracle® SID of the Primary Database Server is different from the Oracle SID in the standby database, select the Destination Details tab, and complete all fields.
Enter the Target Service of the Primary Database Server, the Oracle SYSDBA User Name, and the Oracle SYSDBA Password.
7
In the Target Client list, select the NetVault Backup Client Name of the Primary Database Server.
Related Documents