Chat now with support
Chat mit Support

NetVault Plug-in for Oracle 7.1 - User Guide

Introducing Dell™ 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-inin a failover cluster environment Using the plug-in with Oracle Data Guard Troubleshooting Glossary About Dell

Determining the local Oracle SID and Home directory in a RAC environment

In a multi-instance RAC environment, the local SID and Oracle Home can be determined with the srvctl config database commands.
To determine the SID and Oracle Home
1
From a terminal window, connect as the Oracle Software Owner to the node where plug-in is installed.
2
Execute the following command:
srvctl config database
A list of all databases in the RAC environment is displayed.
3
Execute the following command, where <database_name> represents the database that is being added to the plug-in:
srvctl config database -d <database_name>
The name of the node, local Oracle SID, and local Oracle Home are displayed for each node in the RAC environment in the format:
<node> <local Oracle SID> <local Oracle Home>
In the following example, Plug‑in for Oracle is being installed on the “faro” node, the local Oracle SID is “o10rac3,” and the local Oracle Home is “/home/o10g/db.”
Example
faro:/home/o10g => srvctl config database
o10grac
o10rac
faro:/home/o10g => srvctl config database -d o10rac
lisbon o10rac1 /home/o10g/db
evora o10rac2 /home/o10g/db
faro o10rac3 /home/o10g/db
faro:/home/o10g =>

Adding a database to the plug-in

Adding a multi-instance database in Plug‑in for Oracle is almost identical to adding a single-instance, non-RAC database except for the following differences:
•
Oracle SID – Enter the local SID for the target RAC database. The local SID is the instance name for the target RAC database on the node where the plug-in is installed.
•
Parameter File(s) Path – In a multi-instance RAC environment, the plug-in requires the usage of an SPFILE as a dynamic means of maintaining initialization parameters. The SPFILE must be stored on the shared storage in ASM. Because the SPFILE is included in the Control File Autobackups, this field should be left blank in a RAC environment.
•
Control File Autobackup enabled – Select this option because Control File Autobackups are required in a RAC environment.
For more information, see Configuring the plug-in.

Backing up data

RMAN-based backups are the only supported backup method for multi-instance RAC databases. RMAN is RAC-aware in that it automatically identifies that a database is a multi-instance RAC database and backs up the selected data accordingly.
With the plug-in installed on one of the nodes that hosts one of the instances for the RAC-enabled database, all RMAN-based backups and restores are performed from this single installation of the plug-in.
The Parameter File node is not selectable on the NetVault Backup Selection page.
For more information on selecting data for backup, setting backup options, and finalizing and submitting the job, see Performing RMAN backups.
Performing backups after node failure
If the node where the plug-in is installed in the RAC environment experiences a node failure and the node is, or will be, unavailable at the time of the next scheduled backup, you must relocate the plug-in to an alternate node in the RAC environment.
1
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 on the original node, PROD_RAC should be used as the NetVault Machine Name on the alternate node.
2
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, non-RAC environment except that plug-in is installed 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/licensing-assistance to request a relocation of the RAC Database-Based Plug‑in for Oracle license keys.
3
With the plug-in installed on the alternate node, update the Oracle SID field on the Edit Oracle Database dialog.
Enter the local SID for the target RAC database. The local SID is the instance name for the target RAC database on the node where the plug-in has been relocated. For more information, see Editing database information.
For more information on selecting data for backup, setting backup options, and finalizing and submitting the job, see Performing RMAN backups.

Restoring data in a RAC environment

Because RMAN is RAC-aware, it restores the selected data accordingly. With Plug‑in for Oracle installed on one of the nodes that hosts one of the instances for the RAC-enabled database, all RMAN-based restores are performed from this single installation of the plug-in. The restore process is similar to restoring single-instance, non-RAC environments, with the following exceptions:
•
During the Selecting data for a restore phase of performing RMAN restores, you might select a backup set from a node where the Oracle SID equals the Oracle SID of the instance on which the plug-in is running. But you might also select a backup set from an Oracle SID of another RAC node for which backups were performed previously. For more information about performing restores after a node failure, see Performing restores after node failure.
•
During the Setting restore options phase, if authentication for the target database is needed, you must set the Target Database Authentication Details to the applicable values for the local Oracle instance on which the plug-in that is performing the restore 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.
 
 
*IMPORTANT: If the plug-in was relocated to an alternate node and backups were performed from multiple instances, use the current Oracle SID when selecting data on the Create Selection Set page.
The following sections outline additional types of RMAN recovery that are available in a RAC environment.
•
Recovering a Whole Database to the same RAC environment
•
Restoring SPFILE in a RAC environment
•
Restoring Control Files in a RAC environment
•
Performing disaster recovery in a RAC environment
•
Performing restores after node failure
•
Duplicating a database in a RAC environment
Recovering a Whole Database to the same RAC environment
This type of recovery is performed when the current Control File and SPFILE are intact but all the datafiles are damaged or lost. You can perform a Complete Recovery or recover the database to a specific point-in-time. Following is an overview of the process to recover the whole database in a RAC environment.
1
From a terminal window, connect as the Oracle Software Owner to the node where Plug‑in for Oracle is installed.
2
Set the ORACLE_SID environment variable to the local instance.
export ORACLE_SID = <local_SID>
3
Start SQL*Plus, and connect with administrator privileges to the local instance.
SQLPLUS SYS AS SYSDBA
4
Shut down the local instance.
SHUTDOWN ABORT;
5
Start the local instance with the NOMOUNT option.
STARTUP FORCE NOMOUNT;
6
Disable the CLUSTER_DATABASE initialization parameter for the local instance.
ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE SID='<local_SID>';
7
Shut down the local instance.
SHUTDOWN ABORT;
8
Exit SQL*Plus.
9
Shut down all RAC instances.
> srvctl STOP DATABASE -d <database_name> -o abort
10
Ensure that all RAC instances are shut down.
>srvctl STATUS DATABASE -d <database_name>
11
Start SQL*Plus, and connect with administrator privileges to the local instance.
SQLPLUS SYS AS SYSDBA
12
In SQL*Plus, start the local instance with the MOUNT option.
STARTUP MOUNT;
13
On the Create Restore Job - Choose Saveset page, find the latest available backup that included all the tablespaces, and click Next.
14
On the Create Selection Set page, select the Whole Database node, and click Edit Plugin Options.
15
Click the Restore Options tab, and select the applicable options:
•
To include read-only datafiles in the restore and recovery process, select Check Read-Only Datafiles and Restore if Necessary and Check Read-Only Datafiles and Recover if Not Current. The read-only files are included only if they are needed to complete recovery. If they are not damaged, RMAN omits them.
•
To delete the restored archive logs that Oracle deems unnecessary, select the Delete Archive Logs No Longer Needed option.
16
To perform recovery on the database (that is, to reconstruct the database up to the current or specified point-in-time), select one of the following options 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 be a specific time, log sequence number, or SCN.
17
On the Recovery Catalog tab, select the Use Catalog option, and specify the Recovery Catalog connection details.
18
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.
19
From a terminal window, connect as the Oracle Software Owner to the node where Plug‑in for Oracle is installed.
20
Start SQL*Plus, and connect with administrator privileges to the local instance.
SQLPLUS SYS AS SYSDBA
21
Enable the CLUSTER_DATABASE initialization parameter for the local instance.
ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE SID='<local_SID>';
22
Shut down the local instance.
SHUTDOWN ABORT;
23
Exit SQL*Plus.
24
Start all RAC instances.
>srvctl START DATABASE -d <database_name>
25
Start all RAC Services.
>srvctl START SERVICE -d <database_name>
26
Ensure that all RAC instances are running.
>srvctl STATUS DATABASE -d <database_name>
 
 
*IMPORTANT: After completing a restore of the Whole Database, Dell strongly recommends that you perform a Full or Incremental Level 0 backup with the entire database selected on the NetVault Backup Selections page.
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen