Introducing Quest® NetVault® Plug-in for Oracle
Quest NetVault 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
NetVault Policy Management
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
Using DR Series or QoreStor as the storagedevice for Oracle Database 12.x or later on Linux or UNIX
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 '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 media name
Performing CLI-based restores
Using the CROSSCHECK and CATALOG commands with backups
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
Using the plug-in with Oracle Container Databases (CDBs) and Pluggable Databases (PDBs)
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
Oracle PDBs: an overview
Enabling connection to a PDB
Querying CDB, PDB, and non-CDB databases
Restrictions for backing up and restoring a PDB
Backing up data
Restoring data
Troubleshooting
Installing the plug-in in a Data Guard environment
Before completing any additional or different steps that are outlined in the following topics, review the information provided in earlier topics, such as Installing and removing the plug-in and Configuring the plug-in.
Installation prerequisites
The following prerequisites must be met before you can install Plug‑in for Oracle in a Data Guard environment:
|
• |
Oracle Data Guard environment in place: You must have a properly configured Data Guard environment. The version of Oracle is listed as a Supported Data Guard environment in the Quest NetVault Compatibility Guide. |
|
• |
Oracle RAC environment in place: For Data Guard environments that include multi-instance Primary or Standby Database Servers, meet the Oracle RAC-required configuration that is specified in RAC configuration requirements. |
|
• |
Separate NetVault Server machine: The machine that is to serve as the NetVault Server must be properly configured. This machine must exist outside the Data Guard environment, but have network connectivity to the nodes and hosts within the Data Guard environment. |
|
• |
Separate Recovery Catalog Server: Quest recommends that you store the RMAN repository in a Recovery Catalog database on a server outside the Data Guard environment. Only the primary database can be registered with the Recovery Catalog. For more information, see Creating the RMAN repository. |
|
• |
Control File Autobackups are enabled: Automatic backups of the Control File and SPFILE must be enabled on the databases that meet the following criteria: |
|
• |
Back up from Primary Only strategy: Enable Autobackups of the Control File and SPFILE on the Primary Database Server. |
|
• |
Back up from both Primary and Standby strategy: |
|
• |
Oracle 10.2.x: Disable Autobackups of the Control File and SPFILE on both the Primary and all the Standby Database Servers where backups are performed. Manual Control File and SPFILE backups are performed on the Primary Database Server. |
|
• |
Oracle 11.x: Enable Autobackups of the Control File and SPFILE on all the database servers where backups are performed. For example, if Incremental Level 0 Backups are taken from Standby Database Server while Incremental Level 1 Backups are taken from the Primary Database Server, enable Autobackups on both the Primary and Standby Database Server. |
|
• |
Back up from Standby Only strategy: Enable Autobackups of the Control File and SPFILE on the Standby Database Servers where backups are being performed. |
|
• |
Flash Recovery Area recommended: Enabling FRA is recommended for Data Guard environments. For more information, see Configuring the Flash Recovery Area in the Oracle Database Backup and Recovery User’s Guide. |
|
• |
Flashback Database recommended: Enabling the Flashback Database is recommended on Data Guard Standby Database Servers. For more information, see Enabling Flashback Database and the Using Flashback Database After a Role Transition section in Oracle Data Guard Concepts and Administration. |
|
• |
Additional prerequisites: In addition to the preceding Data Guard-specific requirements, meet the non-Data Guard-specific requirements that are specified in Prerequisites. |
Optional RMAN configuration settings
The following settings are optional in a Data Guard environment.
|
• |
The logs are not needed by the BACKED UP … TIMES TO DEVICE TYPE deletion policy. If the BACKED UP policy is not set, this condition is always met. |
|
• |
Configuration for standby database where backups are not performed: |
|
IMPORTANT: In a switchover or failover where the databases change roles, the corresponding CONFIGURE commands must be re-run on the new primary and standby databases. |
Installing or upgrading the plug-in
In a Data Guard environment, you must install the plug-in on the Primary Database Server. Optionally, you can also install the plug-in on one or more Physical Standby Database Servers. For more information on the supported Data Guard deployments, see Deployment.
From the WebUI on the NetVault Server, open the Manage Clients page. Add the NetVault Clients installed on the primary and standby databases to the NetVault Clients list.
|
3 |