Chat now with support
Chat with Support

NetVault Plug-in for Oracle 11.3 - User Guide

Introducing Quest® NetVault® Backup Plug-in  for Oracle Defining a backup strategy Installing and removing the plug-in Configuring the plug-in Backing up data Using the Oracle® Flashback Database Restoring data
Restoring and recovering data: an overview Performing User Managed restores Using advanced User Managed restore procedures Performing RMAN restores Using RMAN types of recovery in a non-RAC environment Using advanced procedures with RMAN restores
Maintaining the Recovery Catalog Using the RMAN CLI Using the Plug-in with Oracle® RAC Using the Plug-in in a failover cluster environment Using the plug-in with Oracle® Data Guard Troubleshooting

Viewing database details

To view database details about a previously configured database, including enabled database options and whether prerequisites for the plug-in have been met, perform the following steps.

1
In the Navigation Pane, click Create Backup Job, and click Create New next to the Selections list.
2
In the selection tree, open the applicable client node.
3
Double-click Plug‑in for Oracle, and select the applicable database.
4
From the Actions list, select View Details.
The Details dialog box displays the following information:
•
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.
5
To close the dialog box, click OK.

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.

•
Creating an RMAN Post-Backup Script
•
Updating a Post-Backup Script
•
Removing a Post-Backup Script

Creating an RMAN Post-Backup Script

 
* 
IMPORTANT: Selecting the database when adding an RMAN Post-Backup Script is not supported. If you want to use an RMAN Post-Backup Script for the backup job, you might not be able to select the database node because it selects all subitems by default, including any predefined scripts. Before submitting the backup job, verify that only one post-backup script is selected.
1
In the Navigation Pane, click Create Backup Job, and click Create New next to the Selections list.
2
In the selection tree, open the applicable client node.
3
Double-click Plug‑in for Oracle, and select the applicable database.
4
From the Actions list, select Add RMAN Post-Backup Script.
You can also access this command as follows:
a
Open the database node.
b
Double-click the Post-Backup Scripts item, and select Add RMAN Post-Backup Script.
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:
•
Colon (:)
•
Exclamation point (!)
•
Pipe (|)
•
Comma (,)
•
Semi colon (;)
•
Equals (=)
•
Less than (<)
•
Greater than (>)
•
Left square bracket (])
•
Right square bracket ([)
•
Quotation mark (“)
•
Backslash (\)
An error message appears if you include these 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.

Updating a Post-Backup Script

1
Open the database node, and double-click the script listed beneath the Post-Backup Scripts node.
2
Make the required changes, and click Save.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating