Example of a basic CLI backup
This topic shows how to take a Full Backup of the “USERS” tablespace using RMAN commands:
|
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.
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.
|
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 Quest 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 Quest NetVault Backup Administrator’s Guide. | |||||||||
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. |
More parameters: the "send" and "PARMS" clauses
Use the parameters described in this topic with either the “send” or the “PARMS” command to set up the NetVault Backup options for a backup job run from the command line. This topic describes how the “send” and the “PARMS” clauses work.
|
• |
“send” clause: The parameters specified with the “send” clause are applied to a specific job. |
|
• |
“PARMS” clause: The parameters specified with the “PARMS” clause are applied to all the jobs run from the Oracle Instance. |
The following table describes the variables available for use with the “send” and “PARMS” clauses:
|
send 'NETVAULTCLIPASSWORD=<password>';
NOTE: Use of the NETVAULTCLIPASSWORD variable is a security risk. As an alternative, Quest recommends using the nvpluginaccess utility described in Running the NetVault Backup ‘nvpluginaccess’ utility. If the NETVAULTCLIPASSWORD variable is implemented, it displays the NetVault Backup password in plain text. | |||||||||
|
Use this variable to specify a template for an Advanced Options Set created for use with Oracle RMAN CLI backups to target a specific set of NetVault Backup Advanced Options during backup. This parameter overrides the Advanced Options Set that you specified on the Configure dialog box. For more information on Advanced Option Sets, see the discussion of Selection Sets in the Quest NetVault Backup Administrator’s Guide. | |||||||||
| |||||||||
|
The parameters within curly braces are optional. Count followed by full determines the number of generations that the backup is kept. This parameter is the default, that is, if nothing is specified with count, the number of backup generations is considered for the backup life. Days, weeks, or years represents the number of days, weeks, or years that the backup is kept before it is discarded. | |||||||||
|
Use this variable to select a specific group of media based on its group label. This variable must be used with the “NV_TARGET_MEDIA” variable; otherwise, it has no effect. | |||||||||
|
Use this variable to assign a title to the job. Quest recommends that only use this variable with the “send” command on a per job basis, that is, to avoid the chance of all future jobs being labeled with this job title, when applied with the “PARMS” clause. | |||||||||
|
Use this variable to select a specific piece of media based on its media label. This variable must be used with the “NV_TARGET_MEDIA” variable; otherwise, it has no effect. | |||||||||
|
Use this variable to compress backup data before it is transferred over the network, that is, in the same manner as the Advanced Options tab’s “Network Compression” option. The permissible values are:
| |||||||||
|
Use this variable with the “PARMS” clause to establish the machine name of the original NetVault Backup Client Machine Name where the backup was performed. PARMS="ENV=(NV_ORIGINAL_NV_CLIENT= <nv_client_machine_name>)" | |||||||||
|
Use this variable to run a script after completion of a backup job. The script to run must be saved in the “…\netvault\scripts” subdirectory on the Oracle Database Server, where “…” refers to the complete path to the installation of NetVault Backup. | |||||||||
|
Use this variable to run a script before a backup job. The script to run must be saved in the “…\netvault\scripts” subdirectory on the Oracle Database Server, where “…” refers to the complete path to the installation of NetVault Backup. | |||||||||
|
Use this variable to reset the Oracle environment after the “PARMS” clause has been used in the run block. | |||||||||
|
Use this variable to set a specific media as reusable. The permissible values are:
If the value is set as Never, no media marked for reuse is used for the backup. With the parameter set as Any, any media previously marked for reuse is considered for the backup. If the value is set as With same group label as the target media, any media containing the specified group label that has been previously marked for reuse is considered for the backup. | |||||||||
|
Use this variable to specify a Restore Device Source Set created for use with Oracle RMAN CLI restores. This variable lets you target a specific NetVault Backup set of devices and device options during a restore. Do not use this option if you want to use the default NetVault Backup setting of Any Device. NOTE: To use this variable, specify a Restore Device Source Set that was created from the Restore Source option on the Restore Options tab. Do not use NetVault Backup Backup Target Sets. A NetVault Backup Backup Target Set is used to specify target devices during a backup. A NetVault Backup Restore Source Set is used to specify a set of source devices and devices options during a restore.
Set this variable through the “send” or “PARMS” clause in the RMAN CLI.
| |||||||||
|
For more information on Schedule Sets, see the Quest NetVault Backup Administrator’s Guide. | |||||||||
|
Use this variable to set the media in the targeted device. The permissible values are:
| |||||||||
|
Use this variable to specify a Target Set created for use with Oracle RMAN CLI backups to target a specific NetVault Backup device during backup. Ignore this option if you want to use the NetVault Backup default setting of “Any Device.” This parameter overrides the Target Set specified on the Configure dialog box. For more information on Target Sets, see the discussion of Selection Sets in the Quest NetVault Backup Administrator’s Guide. | |||||||||
|
Use this variable to verify completion of a backup job. The permissible values are:
If set to True, the data transfer is checked and a job message is added to the NetVault Backup Job log stating “Backup job has verified successfully.” |
After the “PARMS” clause has been used, use either of the following lines of syntax to reset the RMAN environment:
|
IMPORTANT: Close any terminal session or window in which you have set the NETVAULTCLIACCOUNT and NETVAULTCLIPASSWORD variables. |
Querying the NetVault Backup media name
For RMAN CLI backups performed through the plug-in, you can use SQL*Plus to determine the physical media on which the RMAN backup pieces are stored. The following example shows how to query the media information using Oracle SQL*Plus.
SQL*Plus uses the following format to display the media information:
|
• |
The tape_barcode is shown in parentheses. |
|
• |