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

Retrieving a Control File manually

When Control File Autobackups are not available, the RMAN Catalog is not used, and only Control File backups were performed by selecting the Control File node on the NetVault Backup Selections page, you might be able to use the following procedure to extract the Control File from a backup piece.

1
On the Create Restore Job — Choose Saveset page, find the latest available backup that is marked with “Controlfile Included.”
('<destination PathAndNameOfControlFile>');
('<backupSegment NameIdentifiedEarlier>',done=>done);
3
Use the replicate controlfile command to copy the restored Control File.
SET DBID <Source_DBID>;
'<sourcePathAndNameOfControlFile>';

Using advanced procedures with RMAN restores

This topic contains subtopics that describe other restore operations that can be performed with Plug‑in for Oracle.

Renaming or relocating files

With the RMAN backup method, the plug-in lets you rename the Control File and datafiles during restore. Renaming files can be useful if you do not want to overwrite the existing version and want to create a copy of the file. You can also relocate the files to a different directory while restoring it with the plug-in.

2
In the Navigation pane, click Create Restore Job, select Plug‑in for Oracle from the Plugin Type list.
4
On the Create Selection Set page, select the datafile or Control File to restore.
5
From the Actions list, select Rename.
6
In the Rename/Relocate dialog box, enter the applicable information.
Rename: Enter the new name.
Relocate: Enter the new path.
The plug-in uses the set newname RMAN command to restore or rename — or both — RMAN backups. The set newname command has precedence over the DB_CREATE_FILE_DEST parameter. If the full path is not specified for a restore or rename, the plug-in behaves as follows:
SPFILE: The file is restored to the “$ORACLE_HOME/dbs” directory with the new name.

Duplicating a database in a non-RAC environment

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

For more information on duplicating a multi-instance RAC database, see Duplicating a database in a RAC environment. For more information on Oracle’s Duplicate Database functionality, see Duplicating a Database in the Oracle Database Backup and Recovery User’s Guide.

The plug-in provides the following restore scenarios for the Duplicate Database backup:

Related Documents