Chat now with support
Chat with Support

NetVault Plug-in for Oracle 12.2 - 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

Performing manual backups of Control File and SPFILE

For Oracle 10.2.x Data Guard environments where the back-up-from-both-Primary-and-Secondary strategy has been deployed or Oracle 11.x Data Guard environments where the Control File and SPFILE backups are the only backups that are performed on the Primary Database Servers, Manual Control File and SPFILE backups are performed.

1
Ensure that Control File and SPFILE Autobackups are disabled.
For more information, see Step 5 under Adding a database.
2
In the selection tree, select the Parameter File and Control File nodes.
3
On the Backup Option tab of the NetVault Backup Plugin Options page, select the following options:
•
In the Backup Method section, select RMAN.
•
In the Backup Destination section, select either NetVault Backup Media Manager or Both NetVault Backup Media Manager and Disk (Backup to FRA then Backup FRA to NetVault Backup Media). This step ensures that the Control File and SPFILE are stored on backup media for disaster recovery purposes.
•
In the Backup Method section, select Full.
4
Use the Schedule, Target Storage, and Advanced Options lists to configure any additional required options.
5
Click Save or Save & Submit, whichever is applicable.

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
•
Restoring data to an alternate server in a Data Guard environment
•
Recovering Whole Database to Primary Database Server

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, and select Plug‑in for Oracle.
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.
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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating