• Become a portal pro
• Download
• Print
• My Downloads ()

• Support
• Technical Documentation
• NetVault Plug-in for Oracle 10.0.5
• NetVault Plug-in for Oracle 10.0.5 - User Guide

NetVault Plug-in for Oracle 10.0.5 - User Guide

Table of Contents  

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

Recovery Manager (RMAN) backup method

Reviewing the supported Oracle file types Defining an RMAN backup strategy

Reviewing the RMAN Tablespace and Datafile backup types Reviewing the Control File backup types Reviewing the other backup types

Flash Recovery Area (FRA) backups

Developing a Recovery Catalog backup strategy Examples of backup sequences Defining a Backup Destination strategy

Oracle Flashback technology

Installing and removing the plug-in

Prerequisites Prerequisites for RMAN backups

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 the plug-in

Configuring a default Target Set for RMAN backups Configuring default settings Adding a 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

Backing up data

Performing User Managed backups

Selecting backup options Finalizing and submitting the job

Performing RMAN backups

Setting backup options Finalizing and submitting the job

Backing 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

Recovering datafiles and archive logs

Recovering datafiles and archive logs Restoring Control Files

Understanding RMAN recovery

Choosing between Incremental Backups and Redo Logs Choosing the restore source Datafile media recovery Block Media Recovery

Performing User Managed restores

Selecting data for a restore Finalizing and submitting the job Recovering the database

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

Setting restore options

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

Using RMAN types of recovery in a non-RAC environment

Recovering individual datafiles and tablespaces to the same server Recovering Whole Database to same server Performing disaster recovery with RMAN

Retrieving a Control File manually

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

Uses of table-level recovery Table-level requirements and limitations Configuring channels for table-level recovery Performing table-level recovery from the RMAN CLI Performing table-level recovery from the NetVault Backup WebUI

Maintaining the Recovery Catalog

Resynchronizing the Recovery Catalog

Using the RMAN CLI

CLI-based RMAN backups and restores: an overview Prerequisites for CLI-based backups and restores Performing CLI-based backups

More parameters: the "format" clause More parameters: the "send" and "PARMS" clauses Querying the NetVault Backup media name

Performing CLI-based restores

Using the Plug-in with Oracle® RAC

Oracle RACs: an overview Recommended additional reading Defining a deployment strategy

RMAN restore process for RAC environment

Licensing Installing the plug-in in a RAC environment

Installation prerequisites Installing the plug-in

Configuring the plug-in

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

Restoring SPFILE in a RAC environment Restoring Control Files in a RAC environment Performing disaster recovery in a RAC environment Performing restores after node failure Duplicating a database in a RAC environment

Post-restore procedure

Using the Plug-in in a failover cluster environment

Oracle Server Fail Safe Failover Clustering: an overview Installing the plug-in

Installing the software

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

Back up from both Primary and Standby Back up from Standby only

Deployment

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

Optional RMAN configuration settings

Optional RMAN configuration settings

Installing the plug-in

Backing up data

Creating a User Defined Backup Tag Performing manual backups of Control File and SPFILE

Restoring data

Configuring a restore to an alternate server in a Data Guard environment Restoring data to an alternate server in a Data Guard environment Recovering Whole Database to Primary Database Server

Troubleshooting

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 Topics 41 - 44 of 166

×

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:

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.

To create 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 (|)

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.

To update 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.

To remove a Post-Backup Script:

1	Open the database node, and select the script listed beneath the Post-Backup Scripts node.

2	From the Actions list, and select Delete Post-Backup Script.

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.

 

Table 1. Values

Language	NLS_LANG value
Arabic	ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256
Brazilian Portuguese	BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252 BRAZILIAN PORTUGUESE_BRAZIL.UTF8 BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1 BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P15
Catalan	CATALAN_CATALONIA.WE8ISO8859P1 CATALAN_CATALONIA.WE8MSWIN1252 CATALAN_CATALONIA.WE8ISO8859P15
Chinese Simplified	SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280 SIMPLIFIED CHINESE_CHINA.UTF8 SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Chinese Traditional	TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5
Croatian	CROATIAN_CROATIA.EE8MSWIN1250
Czech	CZECH_CZECH REPUBLIC.EE8MSWIN1250
Danish	DANISH_DENMARK.WE8ISO8859P1 DANISH_DENMARK.WE8MSWIN1252 DANISH_DENMARK.WE8ISO8859P15
Dutch	DUTCH_THE NETHERLANDS.WE8ISO8859P1 DUTCH_THE NETHERLANDS.WE8MSWIN1252 DUTCH_THE NETHERLANDS.WE8ISO8859P15
English	AMERICAN_AMERICA.AL32UTF8 AMERICAN_AMERICA.US7ASCII AMERICAN_AMERICA.UTF8 AMERICAN_AMERICA.WE8ISO8859P1 AMERICAN_AMERICA.WE8ISO8859P15 AMERICAN_AMERICA.WE8MSWIN1252 ENGLISH_UNITED KINGDOM.WE8ISO8859P1 ENGLISH_UNITED KINGDOM.WE8ISO8859P15 ENGLISH_UNITED KINGDOM.WE8MSWIN1252
Finnish	FINNISH_FINLAND.WE8ISO8859P1 FINNISH_FINLAND.WE8MSWIN1252 FINNISH_FINLAND.WE8ISO8859P15
French	FRENCH_FRANCE.UTF8 FRENCH_FRANCE.WE8ISO8859P1 FRENCH_FRANCE.WE8ISO8859P15 FRENCH_FRANCE.WE8MSWIN1252
German	GERMAN_GERMANY.UTF8 GERMAN_GERMANY.WE8ISO8859P1 GERMAN_GERMANY.WE8ISO8859P15 GERMAN_GERMANY.WE8MSWIN1252
Greek	GREEK_GREECE.EL8MSWIN1253
Hebrew	HEBREW_ISRAEL.IW8MSWIN1255 HEBREW_ISRAEL.UTF8
Hungarian	HUNGARIAN_HUNGARY.EE8MSWIN1250
Italian	ITALIAN_ITALY.UTF8 ITALIAN_ITALY.WE8ISO8859P1 ITALIAN_ITALY.WE8ISO8859P15 ITALIAN_ITALY.WE8MSWIN1252
Japanese	JAPANESE_JAPAN.JA16EUC JAPANESE_JAPAN.JA16SJIS JAPANESE_JAPAN.UTF8
Korean	KOREAN_KOREA.KO16KSC5601 KOREAN_KOREA.KO1616KSCCS KOREAN_KOREA.UTF8
Norwegian	NORWEGIAN_NORWAY.WE8ISO8859P1 NORWEGIAN_NORWAY.WE8ISO8859P15 NORWEGIAN_NORWAY.WE8MSWIN1252
Polish	POLISH_POLAND.EE8MSWIN1250
Portuguese	PORTUGUESE_PORTUGAL.WE8ISO8859P1 PORTUGUESE_PORTUGAL.WE8ISO8859P15 PORTUGUESE_PORTUGAL.WE8MSWIN1252
Romanian	ROMANIAN_ROMANIA.EE8MSWIN1250
Russian	RUSSIAN_CIS.CL8MSWIN1251
Slovak	SLOVAK_SLOVAKIA.EE8MSWIN1250
Spanish	SPANISH_SPAIN.UTF8 SPANISH_SPAIN.WE8ISO8859P1 SPANISH_SPAIN.WE8ISO8859P15 SPANISH_SPAIN.WE8MSWIN1252
Spanish Latin American	LATIN AMERICAN SPANISH_AMERICA.WE8ISO8859P1 LATIN AMERICAN SPANISH_AMERICA.WE8ISO8859P15 LATIN AMERICAN SPANISH_AMERICA.WE8MSWIN1252
Swedish	SWEDISH_SWEDEN.WE8ISO8859P1 SWEDISH_SWEDEN.WE8ISO8859P15 SWEDISH_SWEDEN.WE8MSWIN1252
Turkish	TURKISH_TURKEY.WE8ISO8859P9

Backing up data

•	Performing User Managed backups

•	Performing RMAN backups

•	Backing up Oracle ACFS

•  Previous
• Viewing Topics 41 - 44 of 166
• Next 

Search this document Search all documents

×

 Welcome to Quest Support

You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center