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 and 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
Determining the Oracle SID and Home directory in a non-RAC environment
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 the job
Recovering individual datafiles and 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
More parameters: the "format" clause
More 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-in in 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) does not start on Windows
Unable to add a database
Backup fails
Backup job hangs
Restore fails
Glossary
Viewing database details
|
1 |
|
3 |
Double-click Plug‑in for Oracle, and select the applicable database. |
|
4 |
|
• |
Database Name: Name of the selected database as identified in the NAME column of the sys.v$database v$ table. |
|
• |
DBID: Oracle® DBID for the selected database. DBID is the internal, uniquely generated number that differentiates databases and is required during the disaster recovery process. |
|
• |
Oracle Version: Oracle version or release of the selected database. When the selected database is the Oracle Enterprise Edition, this information is also displayed. If the selected database is any other edition of Oracle, only the Oracle version is displayed. |
|
• |
NLS_LANG: Displays the default language of the database. This language is used for messages, day and month names, symbols for AD, BC, a.m., and p.m., and the default sorting mechanism. |
|
• |
Flash Recovery Area Destination: When FRA is enabled, displays the destination of the FRA. |
|
• |
Flashback Database Enabled: Indicates YES if the Flashback Database feature is enabled or NO if not. |
|
• |
Real Application Clusters: Displays TRUE if the instance is part of multi-instance RAC environment or FALSE if the instance is a single-instance environment. |
|
• |
Block Media Recovery: Displays TRUE if Block Media Recovery is available for the selected database and is based on the Oracle Edition of the database. |
|
• |
Block Change Tracking: Displays ENABLED if Block Change Tracking has been enabled for the database or DISABLED if not. |
|
• |
Control File Autobackup: Displays ON if Control File Autobackups have been enabled for the database or OFF if not. |
|
• |
Log Mode: Displays ARCHIVELOG if the database has automatic archiving of the redo logs enabled or NOARCHIVELOG if not. |
Using RMAN Post-Backup Scripts
The plug-in provides a feature to run a script containing RMAN commands on completion of a backup job. For example, you can use this feature to perform an RMAN Repository crosscheck; this crosscheck ensures that data about backups in the RMAN Repository are synchronized with corresponding data in the NetVault Database by running a post-backup script that contains the appropriate RMAN commands. This functionality is designed for Oracle® DBAs with advanced RMAN and scripting experience.
|
1 |
|
3 |
Double-click Plug‑in for Oracle, and select the applicable database. |
|
4 |
|
b |
|
5 |
On the Add RMAN Post-Backup Script dialog box, enter the script details: |
|
• |
Script Name: Enter a name for the post-backup script. The script name must not contain the following characters: |
|
• |
|
• |
Script: Enter the RMAN commands, including the connection strings required for connecting to the target, Catalog, or auxiliary database used in the script. |
|
• |
Use ‘catalog’/Use ‘nocatalog’: Select whether the script connects to the Catalog with these options. |
|
6 |
Click Save to store the script and close the dialog box. |
|
1 |
Open the database node, and double-click the script listed beneath the Post-Backup Scripts node. |
|
1 |
Open the database node, and select the script listed beneath the Post-Backup Scripts node. |
|
2 |
|
3 |
Click Yes in the confirmation dialog box. |
Language support
The following table lists the default languages available for the plug-in, and their corresponding NLS_LANG values.