Chat now with support
Chat with Support

NetVault Plug-in for Oracle 12.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 Using the plug-in with Oracle Container Databases (CDBs) and Pluggable Databases (PDBs) Troubleshooting

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.
2
In the selection tree, open the NetVault Backup Client that is configured as the alternate or target Oracle Database Server, click Plug‑in for Oracle, and select Configure from the context menu.
3
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.
When a restore is performed by the plug-in, this field indicates the NetVault Backup Client from which the original backup was performed.

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.
2
Complete the associated field by specifying the tag that corresponds to the backup set for the Database Server from which you want to restore.
3
Ensure that the backup is restored to an alternate Database Server.
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.
4
To perform recovery on the database, that is, reconstruct the database up to the current or specified point, select one of the following options in the Recovery Type section on the Perform Recovery tab:
•
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.
 
* 
IMPORTANT: In a Data Guard environment, the primary database and standby database have the same database name and the same DBID. However, the Oracle SID might not be the same to differentiate the database servers.
7
In the Target Client list, select the NetVault Backup Client Name of the Primary Database Server.
8
Continue with the restore procedure, including completion of the Schedule and Advanced Options lists.
For more information, see Finalizing and submitting the job.
RMAN automatically chooses the best available Full, Incremental, or Archived Log backups and restores and recovers the database.

Using the plug-in with Oracle Container Databases (CDBs) and Pluggable Databases (PDBs)

•
Oracle PDBs: an overview
•
Enabling connection to a PDB
•
Querying CDB, PDB, and non-CDB databases
•
Restrictions for backing up and restoring a PDB
•
Backing up data
•
Restoring data
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating