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

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:

2
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:

<database/instance_name>.cluster_database=TRUE
<instance_name>.instance_number=N
<instance_name>.thread = N
<instance_name>.undo_tablespace = '<tablespace_name>'
<auxiliary_instance_name>.undo_tablespace='<undo_tablespace>'

Post-restore procedure

After completion of the Restore Duplicate Database Procedure as defined in the Duplicating a database in a non-RAC environment, you can convert the resulting single-instance database to a multi-instance database. To do so, use one of the procedures detailed in Converting to Oracle Real application Clusters from Single-Instance Oracle Databases in the Oracle Real Application Clusters Installation Guide.

Related Documents