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
|
• |
Oracle Failover clustering environment in place – You must have a properly configured Oracle Cluster environment. |
|
• |
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 Server cluster, but have network connectivity to the nodes (hosts) within the cluster. |
Installing the software
Installation of the plug-in for a clustered environment is different than the traditional installation of this plug-in. This process is completed through the creation of a Virtual Client on the NetVault Backup Server. A Virtual Client is a group of nodes within the cluster that are seen by the NetVault Backup Server as a single client that is created to back up a single clustered service.
As noted earlier, the Virtual Client creation process is not plug-in-specific, and you can find complete details in the Dell NetVault Backup Administrator’s Guide. However, consider the following points during the Virtual Client creation process:
|
• |
Assign a name to the Virtual Client – Dell strongly recommends that you use the virtual-network name assigned to the Oracle Database as the NetVault Backup Virtual Client name; you can also use a name that is easily associated with the Oracle Database or cluster environment. This makes it easier to recognize the Oracle Database for which the NetVault Backup Virtual Client was created. |
|
• |
Only include relevant cluster nodes in the Virtual Client – The hosts that are to be included in the creation of a Virtual Client should only be those nodes within the cluster that are relevant to the Oracle Database Server that is to be backed up and restored. |
After the creation of the Virtual Client, the plug-in is transferred to all designated cluster nodes and installed locally. You can use the installed Plug‑in for Oracle via the Virtual Client to back up and restore shared data (you can only perform backups and restores of data established as shared within the cluster).
Licensing the plug-in
Another difference between using Plug‑in for Oracle in a clustered environment is how it is licensed for use. The plug-in supports backup and restore of shared data only. Hence, for an Oracle Database Server Failover Cluster environment, only a single license would be needed — a clustered application license for the Virtual Client.
For information on the licensing process, including how to obtain the proper license keys, refer to the Dell NetVault Backup Installation Guide.
Configuring the plug-in and adding a database
|
• |
Oracle SID – Enter the local SID to the active node in the cluster for the target Oracle database. The local SID is the Oracle instance name on the local node for the target database. |
|
• |
Control File Autobackup enabled – Dell recommends that you select this option. |
|
• |
PFILE usage – If the local instances in the cluster nodes of the targeted Oracle Database use PFILE instead of SPFILE, you might want to clear the Use RMAN Commands to Backup SPFILE option on the RMAN Details tab, which you can access via the Add Database or Edit Database options, and enter the applicable information in the Parameter File(s) Path box on the Oracle Instance Details tab. |
 IMPORTANT: If a failover to a different node occurs, you must use the Add Database option to add the Oracle Database information to the Plug‑in for Oracle on the active node (the one to which the cluster failed over). You only need to enter this information once; in subsequent failovers, the plug-in automatically retrieves the information. |