Introducing Dell™ NetVault™ Backup Plug‑in for Oracle®
Dell NetVault Backup Plug‑in for Oracle – At a Glance
Key benefits
Feature summary
Target Audience
Recommended additional reading
Defining a backup strategy
Defining a strategy – overview
Reviewing the available backup methods
Reviewing the supported Oracle file types
Defining an RMAN backup strategy
Installing and removing the plug-in
Reviewing the RMAN Tablespace/Datafile backup types
Reviewing the Control File backup types
Reviewing the other backup types
Developing a Recovery Catalog backup strategy
Examples of backup sequences
Defining a Backup Destination strategy
Oracle Flashback technology
Prerequisites
Prerequisites for RMAN backups
Configuring the plug-in
Creating the RMAN repository
Registering the target database
Enabling Control File Autobackups
Enabling Flashback Database
Enabling Block Change Tracking
Recommended configuration for a single-instance non-RAC environment
Installing the plug-in
Removing the plug-in
Configuring a default Target Set for RMAN backups
Configuring default settings
Adding a database
Backing up data
Using the Oracle Flashback Database
Editing database information
Setting the database password
Removing a saved password
Removing a database
Viewing database details
Using RMAN Post-Backup Scripts
Language support
Flashback Database – an overview
Viewing Flashback Database status
Flashback Database options
Flashback Database restrictions
Restoring data with the plug-in and Flashback Database
Restoring data
Restoring and recovering data – an overview
Performing User Managed restores
Using advanced User Managed restore procedures
Maintaining the Recovery Catalog
Using the RMAN CLI
Renaming or relocating Control File, Datafile, or individual Archived Log files
Renaming or relocating the Archive Log Directory
Performing RMAN restores
Setting restore options
Using RMAN types of recovery in a non-RAC environment
Setting the Pre-Restore and general Restore Options
Setting recovery options
Setting Block Media Recovery options
Setting Post Recovery options
Setting Destination Details
Setting the Recovery Catalog details
Setting the Clone Database options
Setting Generate RMAN Script options
Finalizing and submitting a job
Recovering individual datafiles/tablespaces to the same server
Recovering Whole Database to same server
Performing disaster recovery with RMAN
Using advanced procedures with RMAN restores
Duplicating a database in a non-RAC environment
Restoring a Duplicate Database to the same server
Restoring a Duplicate Database to an alternate server with the same directory structure
Restoring a Duplicate Database to an alternate server with an alternate directory structure
Performing table-level recovery
CLI-based RMAN backups and restores – an overview
Prerequisites for CLI-based backups and restores
Performing CLI-based backups
Using the Plug-in with Oracle RAC
Additional parameters: the "format" clause
Additional parameters: the "send" and "PARMS" clauses
Querying the NetVault Backup media name
Performing CLI-based restores
Oracle RACs – an overview
Recommended additional reading
Defining a deployment strategy
Licensing
Installing the plug-in in a RAC environment
Configuring the plug-in
Using the Plug-inin a failover cluster environment
Determining the local Oracle SID and Home directory in a RAC environment
Adding a database to the plug-in
Backing up data
Restoring data in a RAC environment
Oracle Server Fail Safe Failover Clustering – an overview
Installing the plug-in
Licensing the plug-in
Configuring the plug-in and adding a database
Backing up data
Restoring data
Using the plug-in with Oracle Data Guard
Oracle Data Guard – an overview
Defining a deployment strategy
Deployment
Troubleshooting
Single-instance to single-instance Data Guard deployment
Multi-instance RAC to single-instance Data Guard deployment
Multi-instance RAC to multi-instance RAC Data Guard deployment
Installing the plug-in in a Data Guard environment
Backing up data
Restoring data
NetVault Backup 10.x service (netvault-pgsql) will not start on Windows
Unable to add a database
Backup fails
Backup job hangs
Restore fails
Glossary
About Dell
Installing the plug-in in a RAC environment
Before completing any additional or different steps that are outlined in this section, make sure that you review the information provided in earlier sections, such as Installing and removing the plug-in and Configuring the plug-in.
|
• |
The version of Oracle and the platform are listed as a supported RAC environment in Dell NetVault Backup Plug-in Compatibility Guide. |
Figure 6 and Figure 7 provide an overview of supported single and multiple RAC database deployments.
Figure 6. Supported single-database deployments
Figure 7. Supported multiple-database deployments
Installation prerequisites
|
• |
Oracle RAC environment in place – You must have a properly configured Oracle RAC environment that matches the configuration as specified in RAC configuration requirements. |
|
• |
Separate NetVault Backup Server machine – The machine that is to serve as the NetVault Backup Server must be properly configured, and it must exist outside the Oracle RAC environment, but have network connectivity to the nodes/hosts within the RAC environment. |
|
• |
Separate Recovery Catalog Server – Dell strongly recommends that you store the RMAN repository in a Recovery Catalog database on a server outside the Oracle RAC environment. For more information, see Creating the RMAN repository. |
|
• |
Additional prerequisites – In addition to the preceding RAC-specific requirements, you must meet the requirements that are specified in Prerequisites. |
|
• |
Oracle 11g Release 2 and later – If you are using Oracle 11g Release 2 or later, you must ensure that the snapshot Control File is shared by all nodes in the RAC database. The snapshot Control File must be saved in a shared location, such as in one ASM instance or on a shared drive. The location of the snapshot Control File is managed by the snapshot Control File name RMAN parameter. In Oracle 11g Release 2, by default, this parameter refers to a persistent file in the local file system on each of the RAC nodes. If this applies to your environment, ensure that you change the parameter to point to a shared location. Otherwise, RMAN backups that include the Control File might fail with an “ORA-00245: control file backup operation failed” message. |
Control File Autobackups are required in a RAC environment. For more information, see Reviewing the Control File backup types. For more information on single-instance RAC databases, see Enabling Control File Autobackups.
IMPORTANT: Installing the plug-in
|
1 |
Install the NetVault Backup Client software. |
During installation of the NetVault Backup Client software on the selected node of the RAC environment, a name that represents the entire RAC environment should be specified as the NetVault Machine Name versus the machine name of the selected node. For example, if the machine name for the node where the NetVault Backup Client software is being installed is called RAC_NODE_1, RAC_NODE_1 should not be specified as the NetVault Machine Name; it should be a generic or virtual name that represents the entire RAC environment such as PROD_RAC.
Configuring the plug-in
|
• |
|
• |
NetVault Backup (required for RMAN backups in a RAC environment) – Specify the name of the NetVault Backup Server where the Oracle Database Server was added as a NetVault Backup Client. |
|
• |
Do Restores from NetVault Backup Server (required for RMAN backups in a RAC environment) – Specify the name of the NetVault Backup Server where the Oracle Database Server was added as a NetVault Backup Client. |
|
• |
CLI Backup/Autobackup Target Set (required for RMAN backups in a RAC environment) – Specify the name of the Backup Target Set that was specified in the Configuring a default Target Set for RMAN backups. |