NetVault Plug-in for Oracle 11.2

On the Create Selection Set page, navigate to the source NetVault Backup Client and database, select the Whole Database node, and click Edit Plugin Options.

Click the Restore Options tab, and select the Check Read-Only Datafiles and Restore if Necessary and Check Read-Only Datafiles and Recover if Not Current options to include read-only datafiles in the restore and recovery process.

Because recovery must be performed in a disaster recovery scenario, on the Perform Recovery tab, select Perform Database Point-in-Time Recovery.

PIT Recovery recovers the database to a specific time, log sequence number, or SCN. If the specific time or log sequence of the failure is not known, Quest recommends that you use the SCN option.

On the Recovery Catalog tab, clear the Use Catalog option.

Complete the Target Client, Schedule, and Advanced Options tabs, and submit the job.

RMAN automatically chooses the best available full, incremental, or Archived Log backups and restores and recovers the database.

In RMAN, enable Block Change Tracking.

SQL "ALTER DATABASE ENABLE BLOCK CHANGE TRACKING";

Update the RMAN metadata.

CROSSCHECK ARCHIVELOG ALL;

Exit RMAN.

Start all RAC instances.

>srvctl START DATABASE -d <database_name>

Start all RAC Services.

>srvctl START SERVICE -d <database_name>

Ensure that all RAC instances are running.

>srvctl STATUS DATABASE -d <database_name>


	IMPORTANT: After completing a disaster recovery, Quest recommends that you perform a Full or Incremental Level 0 backup with the entire database selected on the NetVault Backup Selections page.

Performing restores after node failure

If the multi-instance RAC database experiences a media failure or data corruption simultaneously with a failure of the node where the plug-in is installed, relocate the plug-in to an alternate node in the RAC environment to perform an RMAN-based restore and recovery. Relocating the plug-in is a two-step process:

Install the NetVault Backup Client software on an alternate node.

Install the NetVault Backup Client on an alternate node in the RAC environment. During the installation process, be sure to use the same NetVault Machine Name that was used during the installation of the NetVault Backup Client on the original node. For example, if PROD_RAC was the NetVault Machine Name specified during the installation of the original node, PROD_RAC should be used as the NetVault Machine Name on the alternate node.

Install Plug‑in for Oracle.

After the NetVault Backup Client has been installed on the selected node of the RAC environment, install the plug-in. The process is identical to installing the plug-in for a single-instance database environment except that you install the plug-in on the NetVault Backup Client that corresponds with the generic or virtual name provided as the NetVault Machine Name during the NetVault Backup Client installation.


	IMPORTANT: If the relocation of the plug-in is expected to be permanent or last longer than 45 days, visit https://support.quest.com/contact-us/licensing to request relocation of the RAC Database-Based Plug‑in for Oracle license keys.

With Plug‑in for Oracle installed on the alternate node, the restore process is similar to performing restores in a single-instance, non-RAC environment except for the following differences:

•

During the Selecting data for a restore phase of performing RMAN restores, select the backup set from the node on the Create Selection Set page where the Oracle SID equals the Oracle® SID of the instance where the plug-in was originally installed before the relocation.

•

During the Setting restore options phase, set the Target Database Authentication Details to the appropriate values for the local instance on the alternate node where the plug-in now resides. For more information, see Setting Destination Details.

For more information on preparing the database for recovery, selecting data items for a restore, setting restore options, finalizing and submitting the job, and opening the database for use, see Performing RMAN restores.

Duplicating a database in a RAC environment

A Duplicate Database backup lets you create a duplicate or clone of a source database for special purposes that must not affect the overall backup and restore procedures for the source database. In a RAC environment, Oracle® does not support duplicating a multi-instance database to a different multi-instance database. However, Oracle does support duplicating a multi-instance database to a single-instance database followed by converting the single-instance database to a multi-instance database. For more information, see the Oracle Real Application Clusters Installation Guide.

Restoring a Duplicate Database backup to the same RAC Environment is almost identical to restoring a Duplicate Database backup in a single-instance environment. The differences are described in the following topics.

Prerequisites

PFILE updated with auxiliary values: In addition to the updates to the PFILE as specified in the Non-RAC duplication procedures, the following additional updates must be made when the source database is a multi-instance database:

Comment out the RAC-related parameters by inserting a “#” (number sign) at the start of the entry.

Sample RAC-related parameters include:

•

.cluster_database_instances = N

•

.cluster_database=TRUE

•

<database/instance_name>.cluster_database=TRUE

•

<instance_name>.instance_number=N

•

<instance_name>.thread = N