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
Defining a deployment strategy
Determining a strategy for protecting and recovering a Data Guard environment is essential to deploying and using the plug-in in the Data Guard environment. All strategies are valid for any of the supported deployments as detailed in Deployment.
Back up from both Primary and Standby
|
• |
Oracle 10.2.x – Backing up the datafiles and the archived redo log files can be offloaded to the Standby Database Server while the backups of the Control Files and the SPFILE must be performed on the Primary Database Server. In addition, backups of the datafiles and archived redo log files can be used to recover either the Primary or Standby Database Server, regardless of whether the backups were taken from the Primary or Standby Database Server. For more information, refer to RMAN to Back Up and Restore Files in Oracle 10.2.x Data Guard Concepts and Administration. |
|
• |
Oracle 11.x – Backups of the datafiles, archived redo log files, Control Files, and SPFILE are interchangeable between the Primary and Standby Database Server, which means that all backups can be performed from one of the Standby Database Servers. In addition, backups can be used to recover either the Primary or Standby Database Server, regardless of whether the backups were taken from the Primary or the Standby Database Server. For more information, refer to Using RMAN to Back Up and Restore Files in Oracle 11.x Data Guard Concepts and Administration. |
 NOTE: For Oracle versions prior to Oracle 11.x, backups of SPFILE were assumed to be usable at any other standby database. However, in practice, all standby databases cannot use the same SPFILE. Therefore, RMAN does not allow an SPFILE backup taken at one database site to be used at another database site. This restriction is in place only when the COMPATIBLE initialization parameter is set to 11.0.0.The standby database lets you offload all backup operations to one specific standby database, except the backups of SPFILE. However, if the COMPATIBLE initialization parameter is set to 11.0.0, the SPFILE can be backed up to disk and cataloged manually at standby sites where backups are written to tape or NetVault Backup media. The additional metadata stored in SPFILE backup sets enables RMAN to identify which database SPFILE is contained in which backup set. Thus, the appropriate SPFILE backup is chosen during restore from tape or NetVault Backup media. |
When implementing a Back up from both Primary and Standby strategy for an Oracle 10.2.x Data Guard environment, you must consider the accompanying Backup Destination strategy, which is detailed in Defining a Backup Destination strategy.
In Oracle 11.x Data Guard environments, the Oracle parameter db_unique_name allows the Recovery Catalog to distinguish the origin of backups to the FRA. When selecting FRA-to-tape backups, RMAN backs up the backup sets in the FRA of the Database Server performing the FRA-to-tape backup.
For more information on performing backups to tape, see Setting backup options. For more information on FRA backups, see Flash Recovery Area (FRA) backups.