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

If you want use advanced RMAN features that are not supported through Plug‑in for Oracle’s interface, you can perform CLI-based RMAN backups and restores instead of, or with, the plug-in. During CLI-based RMAN backups and restores, the plug-in provides media management functionality for RMAN.
 
* 
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.
Before completing any additional or different steps that are outlined in this section, review the information provided in the previous sections, such as Installing and removing the plug-in and Configuring the plug-in.

Prerequisites for CLI-based backups and restores

The steps described in the following sections must be performed before initiating backups or restores from the command line:
•
Verifying that the proper RMAN executable is in use (Linux only)
•
Ensuring an “SBT_TAPE” channel is established
•
Running the NetVault Backup ‘nvpluginaccess’ utility
Verifying that the proper RMAN executable is in use (Linux only)
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.
Ensuring an “SBT_TAPE” channel is established
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.
 
* 
IMPORTANT: Jobs that are generated using the RMAN CLI cannot be re-run using the NetVault Backup WebUI. The RMAN CLI command (that is the RMAN script) is not sent from the RMAN CLI application back to NetVault Backup. So, if you select Run Now on the Job Status page, the job fails.
Running the NetVault Backup ‘nvpluginaccess’ utility
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.
To run this utility:
1
Initiate a command-line session, and navigate to the “util” directory:
•
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.
2
Run the following commands:
nvpluginaccess -remove -client <clientMachineName>
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.
Example:
nvpluginaccess -client DB_Server -account default
3
When the list of available plug-ins appears, enter the number that corresponds to the plug-in (“Oracle RMAN Plug-in”), and press Enter.
4
When the password prompt appears, enter the password for the specified NetVault Backup account.
A confirmation message appears stating that access has been granted for the specified NetVault Backup Client.
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.
The following entry in the “hookplugs.cfg” file corresponds to the preceding example.
[DB_SERVER]
Plug-ins=Oracle Rman!,Oracle Rman Plug-in
Account=default
Password=%G59j$#
 
* 
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

The following sections provide information for 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
Example of a basic CLI backup
This section shows how to take a Full Backup of the “USERS” tablespace using RMAN commands:
1
Log on to the Oracle® Database Server, and initiate a terminal session.
2
From the prompt, generate a “Run Block” as follows:
run {
allocate channel c1 device type 'SBT_TAPE';
backup
tablespace USERS;
release channel c1;
}
The preceding commands are the minimum required to perform a CLI-based backup. The plug-in provides several additional parameters that can be used to set different options for a CLI backup job. The sections that follow provide a description of these parameters.

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:
•
Server Name
•
Target Set
•
Advanced Options Set
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.)
run {
allocate channel c1 type 'SBT_TAPE';
backup
format '<Variable_1>:<Variable_2>:<Variable_3>::%d_%u_%p_%c'
tablespace USERS;
release channel c1;
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
Variable
Description
<Variable_1>
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.
<Variable_2>
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.
<Variable_3>
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_%u_%p_%c”
These values pertain to unique RMAN identifiers; that is, they are Oracle environmental variables. Oracle uses this variable to generate a unique string that can be used to identify the separate backup segments in the NetVault Backup Media Manager.
•
%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