Introducing Quest® NetVault® Backup Plug-in for Oracle
Quest 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
Choosing the location for the RMAN repository
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
Adding the Oracle user to the local administrator group on Windows
Determining the Oracle SID and Home directory in a non-RAC environment
Creating the RMAN repository
Recommended configuration for a single-instance non-RAC environment
Installing or upgrading the plug-in
Removing the plug-in
Configuring the Recovery Catalog database
Creating the Recovery Catalog owner
Creating the Recovery Catalog
Registering the target database
Enabling Control File Autobackups
Enabling Flashback Database
Enabling Block Change Tracking
Configuring a default Target Set for RMAN backups
Configuring default settings
Adding a database
Backing up data
Editing database information
Setting the database password
Removing a saved password
Removing a database
Viewing database details
Using RMAN Post-Backup Scripts
Language support
Performing User Managed backups
Performing RMAN backups
Using Plug-in for FileSystem to back up Oracle ACFS
Using the Oracle® Flashback Database
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
Maintaining the Recovery Catalog
Using the RMAN CLI
Understanding User Managed recovery
Performing User Managed restores
Determining which datafiles require recovery
Recovering datafiles and archive logs
Restoring Control Files
Understanding RMAN recovery
Preparing the database for recovery
Selecting data for a restore
Finalizing and submitting the job
Recovering the database
Opening the database for use
Using advanced User Managed restore procedures
Renaming or relocating Control File, Datafile, or individual Archived Log files
Renaming or relocating the Archive Log Directory
Performing RMAN restores
Selecting data for a restore
Setting restore options
Using RMAN types of recovery in a non-RAC environment
Viewing the contents of backup pieces
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
Restoring the Control File from an Autobackup
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
Renaming or relocating files
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
Using the Plug-in with Oracle® RAC
Verifying that the proper RMAN executable is in use (Linux only)
Ensuring an "SBT_TAPE" channel is established
Running the NetVault Backup 'nvpluginaccess' utility
Performing CLI-based backups
Example of a basic CLI backup
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
Configuring default attributes
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
Setting Destination Details
If the SYSDBA user name or password or the Oracle® SID for the database has changed since the time of backup, set the following options for the restore job on the Destination Details tab:
|
• |
Target Service: This option is required only if the current SID for the Oracle DBID has been changed since the backup was taken. |
|
• |
Oracle SYSDBA User Name: Specify the new SYSDBA user name if changed. |
|
• |
Oracle SYSDBA Password: Specify the password associated with the name specified in the preceding field. |
|
IMPORTANT: The Destination Details requires that the DBID of the backed-up or source database match the DBID of the destination database. When the goal of the restore is to create a duplicate of the source database to a database with a different DBID, using a Duplicate Database backup is required. For more information, see Duplicate Database backup. |
Setting the Recovery Catalog details
While the Recovery Catalog information is provided for backups on the Configure or Add, or Edit, Oracle Database dialog box, set the Recovery Catalog configuration for a particular restore job by configuring the Recovery Catalog information on the Recovery Catalog tab.
|
• |
Use Catalog: Select this option to use the RMAN repository in the Recovery Catalog and store information about this restore operation in a Recovery Catalog. Clear Use Catalog when performing a test recovery. |
|
• |
Catalog Instance Name: Enter the Oracle® Instance name, which might differ from the Oracle Net Service name, for the Recovery Catalog database. This instance name must be defined in the “tnsnames.ora” file on the Oracle Database Server so that the plug-in can connect to the Recovery Catalog database. If the Recovery Catalog was used during the backup, the Instance Name field defaults to the Oracle Instance name used during the backup job. |
|
• |
Catalog Owner: Specify the user that was specified as the owner of the Recovery Catalog and was granted the RECOVERY_CATALOG_OWNER role. |
|
• |
Catalog Password: Provide the password associated with the Catalog Owner name specified in the preceding field. |
Setting the Clone Database options
The Clone Database tab is available only when an RMAN DUPL DB backup is selected on the Create Selection Set page. You can use it to specify the options for restoring a Duplicate Database backup to a destination database. For more information on the prerequisites, see Duplicating a database in a non-RAC environment or Duplicating a database in a RAC environment.
|
• |
Duplicate Database: Select this option to restore the selected Duplicate Database backup to an alternate destination database. |
|
• |
Destination Database section: |
|
• |
Auxiliary Instance: Specify the Oracle® Net Service name of the auxiliary instance. This field defaults to auxdb. |
|
• |
Oracle Home: Specify the Oracle Home for the auxiliary instance. This field defaults to the Oracle Home of the source database. |
|
• |
Oracle SYSDBA User Name: Specify the SYSDBA user name that is used to connect to the auxiliary instance. This field defaults to the SYSDBA user name specified in the configuration of the source database. |
|
• |
Oracle SYSDBA Password: Enter the password for the SYSDBA user name specified in the preceding field. |
|
• |
Use nofilenamecheck Option: Select this option to prevent RMAN from verifying whether the datafiles and online redo logs files of the source database are in use when the source database files use the same names as the duplicate database files. You are responsible for determining that the duplicate operation does not overwrite useful data. |
|
• |
Duplicate From Database section |
|
• |
Target Database: Specify the Oracle SID of the target database. This field defaults to the Oracle SID of the database including in the backup. |
|
• |
Oracle Home: Specify the Oracle Home for the source database. This field defaults to the Oracle Home of the source database. |
|
• |
Oracle SYSDBA User Name: Specify the SYSDBA user name that is used to connect to the source database. This field defaults to the SYSDBA user name specified in the configuration of the source database. |
|
• |
Oracle SYSDBA Password: Enter the password for the SYSDBA user name specified in the preceding field. |
Setting Generate RMAN Script options
Intended for the advanced DBA, the Generate RMAN Script feature lets you generate most of an RMAN script through the WebUI. Later, before using the script, you can add more options or parameters. With this option, you do not need to create the script from scratch, which minimizes the risk of syntax errors in the scripts and that restores are not performed correctly.
You can set the following options for the Generate RMAN Script feature:
|
• |
Output RMAN Script to File: Select this option to use the feature and enable access to the remaining options, and then enter the name of the file to which the RMAN script is written. |
|
• |
RMAN Script Directory: Enter the name of the directory where the RMAN scripts are saved. The Generate Script Default Directory field defaults to the directory specified on the plug-in’s Configure dialog box. However, you can modify the field on a per-backup-job basis. The full path where the RMAN script is saved is built by concatenating the RMAN Script Directory with the filename provided in the Output RMAN Script to File field. |
|
• |
If Existing, Overwrite Destination File: Select this option to allow the destination file where the RMAN script is output to be overwritten if the file exists. If the file exists and this option is not selected, Generate RMAN Script fails and does not write output to the existing file. Select this option only if you are sure that you want to overwrite an existing file. |
|
• |
Generate RMAN Script and Submit Job: With this option selected, in addition to outputting the RMAN script to the specified file, the NetVault Backup Job is scheduled and submitted. Clearing this option ensures that the plug-in only generates the script, which lets you edit and run the script outside of NetVault Backup. |