Chat now with support
Chat with Support

NetVault Plug-in for Oracle 10.0.5 - User Guide

Introducing Dell™ 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 Glossary

CLI-based RMAN backups and restores: an overview

IMPORTANT: Before using this functionality, Dell recommends that you thoroughly review the Oracle® Database Backup and Recovery Advanced User’s Guide to familiarize yourself with the internals of RMAN.

Prerequisites for CLI-based backups and restores

Various installations of Linux® include more than one executable named as rman. Because of this inclusion, you must verify that the correct Oracle® RMAN application is started when you issue the rman command at the prompt. This step can be done by making the path to the Oracle RMAN executable ($ORACLE_HOME/bin) as the first search path in the PATH environmental variable.
Plug‑in for Oracle uses an Oracle® “SBT_TAPE” channel to conduct backups of an Oracle database. SBT is commonly used to specify a destination for RMAN commands used to back up to tape media. For complete information on establishing this type of channel for use, see Configuring and Allocating Channels for Use in Backups in the Oracle Database Backup and Recovery Advanced User’s Guide.
If the password for the NetVault Backup default user has been set or a non-default NetVault Backup user is used to run the backup and restore, you must run the nvpluginaccess utility on the NetVault Backup Server. You must then obtain the necessary security clearance for the plug-in to perform CLI backups and restores.
The nvpluginaccess utility is available in the “util” directory on the NetVault Backup Server.
On Linux® and UNIX®, the “util” directory is in “…/netvault/util”
On Windows®, the “util” directory is in “…\NetVault\util”
where “…” represents the path to the NetVault Backup Server installation directory.
nvpluginaccess -client <clientMachineName> -account <userName>
where <clientMachineName> is the name of the NetVault Backup Client machine on which the plug-in is installed and <userName> is the NetVault Backup user who performs the backups and restores.
5
Verify that the nvpluginaccess utility has been correctly configured by reviewing the contents of the “hookplugs.cfg” file located in the “config” directory:
On Linux and UNIX, the “config” directory is in “…/netvault/config”
On Windows®, the “config” directory is in “…\NetVault\config”
where “…” represents the path to the NetVault Backup Server installation directory.
NOTE: The Password field in the “hookplugs.cfg” file contains an encrypted view of the password. The actual password is not displayed.

Performing CLI-based backups

1
Log on to the Oracle® Database Server, and initiate a terminal session.
2
From the prompt, generate a “Run Block” as follows:

More parameters: the "format" clause

The “format” clause specifies the pattern to use in creating a filename for the backup pieces or image copies that it creates. The plug-in provides additional parameters that can be used as variables along with the “format” clause. These variables let you specify three parameters for a backup job:
The “format” clause is used within a run block and is specified immediately after the “backup” command in the syntax. (Use of the additional colon before the “%d_%u_%p_%c” variable is required; use of the “%d_%u_%p_%c” variable is critical because Oracle® usually generates a unique string that you can use to identify the separate backup segments in the NetVault Backup Media Manager.)
format '<Variable_1>:<Variable_2>:<Variable_3>::%d_%u_%p_%c'
Specific variables are included with this clause, each following a designated sequence (for example, “<Variable_1>”, “<Variable_2>”, and “<Variable_3>”). Each corresponds to specific NetVault Backup and RMAN values, and all are outlined in the following table. Ensure that each variable in the command is separated by a colon (“:”) and that a second colon is inserted before the “%d_%u_%p_%c” variable.
Table 2. Variables
NetVault Backup Server Name: The NetVault Backup Machine Name of the NetVault Backup Server from which you run the backup job. This value is required.
Target Set Name: To target a specific device during backup, specify a Target Set created for use with Oracle® RMAN backups. (Leave this option blank if you want to use NetVault Backup’s default setting of “Any Device.”) This option overrides the Target Set specified on the Configure dialog box. For more information on Target Sets, see the discussion of Selection Sets in the Dell NetVault Backup Administrator’s Guide.
Advanced Options Set Name: Specify an Advanced Options Set created for use with Oracle RMAN backups. (Leave this option blank if you want to use NetVault Backup’s default Advanced Options settings.) This option overrides the Advanced Options Set specified on the Configure dialog box.
When defining the CLI Backup Advanced Options Set, the Discard After Days/Weeks/Years option must be specified instead of Discard After Full Backups in the Backup Life section of the Advanced Options tab. CLI-based RMAN backups do not support backup-life generation for Full Backups, and backups might expire unexpectedly if the Discard After Full Backups option is specified. For more information on Advanced Option Sets, see the discussion of Selection Sets in the Dell NetVault Backup Administrator’s Guide.
%d: Specifies the name of the database.
%u: Specifies an eight-character name made up of a compressed representation of the backup set or image copy number and the time the set or copy was created.
%p: Specifies the piece number within the backup set.
%c: Specifies the copy number of the backup piece within a set of duplicated backup pieces.
NOTE: As an alternative, you can use “%d_%s_%t” or another combination of keywords that generates a unique identifier. For substitution variables that you can use with the formatSpec subclause, see your Oracle documentation.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating