立即与支持人员聊天
与支持团队交流

NetVault Plug-in for Oracle 7.1 - 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-inin a failover cluster environment Using the plug-in with Oracle Data Guard Troubleshooting Glossary About Dell

Selecting backup options

1
Click Create New next to the Plugin Options list.
2
In the Backup Method section, select the User Managed option to perform a User Managed backup.
Include Read-Only and Offline Tablespaces – By default, the plug-in does not back up read-only and offline tablespaces even if you selected them explicitly on the NetVault Backup Selections page. Read-only and offline tablespaces typically do not require backing up unless the read-only data has been updated or the offline tablespaces have been brought online. Eliminating these tablespaces from the Full User Managed backups reduces the backup window. To include read-only and offline tablespace in the backup, select this option.
Delete Archive Logs After Successful Backup – If you want to delete the archive logs automatically after they are backed up, thus eliminating the need to delete them manually, select this option. This is useful when you are backing up the archive logs to backup media.
*IMPORTANT: Selecting the Delete Archive Logs After Successful Backup option deletes the archive logs even if the backup job fails. Therefore, make sure that the option selected for Incomplete Backup of ALL Items Selected includes retaining a backup saveset to ensure that the archive logs can still be restored.
4
From the Incomplete Backup of ALL Items Selected list, select the default action for the plug-in.
When multiple items are included in a backup and the plug-in is unable to back up all the items selected, the plug-in lets you specify what action the backup should take. For example, if a job includes multiple tablespaces and archive logs, and the backup of the archive logs is unsuccessful while the tablespaces are backed up successfully, you can specify what action the backup job should take in this situation.
Complete with Warnings - Saveset Retained – The job returns a status of “Backup Completed with warnings” and a backup saveset is created that includes the items that were successfully backed up.
Complete without Warnings - Saveset Retained – The job completes and returns a status of “Backup Completed.” While errors are logged in the NetVault Backup binary logs, the errors are essentially ignored in the Job Status page and a backup saveset is created that includes the items that were successfully backed up.
Fail - Saveset Retained – The job returns a status of “Backup Failed.” However, a backup saveset is generated that includes the items that were successfully backed up.
Fail - No Saveset Retained – The job returns a status of “Backup Failed” and no saveset of backed up objects is kept. That is, even if some of the selected objects were successfully backed up, the saveset is discarded.
5
Click Save to save the set.
6
In the Create New Set dialog, specify a name for the set, and click Save.
In the Plugin Options list, select the existing Backup Options Set that you want to use.

Finalizing and submitting a job

1
Use the Schedule, Target Storage, and Advanced Options lists to configure any additional required options.
2
Click Save or Save & Submit, whichever is applicable.
*TIP: To run a job that you have already created and saved, select Manage Job Definitions in the Navigation pane, select the applicable job, and click Run Now.

Performing RMAN backups

1
In the Navigation pane, click Create Backup Job.
You can also start the wizard from the Guided Configuration link. In the Navigation pane, click Guided Configuration. On the NetVault Configuration Wizard page, click Create backup jobs.
2
In Job Name, specify a name for the job.
3
Click Create New next to the Selections list.
4
On the NetVault Backup Selections page, enter a name for the set in the Backup Selection Set box, and then open the NetVault Backup Client on which the plug-in is installed.
5
In the list of plug-ins, open Plug‑in for Oracle, and then open the database you want to back up.
Account Name – Specify an Oracle database user with SYSDBA privileges.
Password – Enter the password associated with the user name specified in the preceding field.
Database Node – When this node is selected and no individual sub-nodes are cleared, the whole Oracle database is backed up with the equivalent RMAN BACKUP DATABASE PLUS ARCHIVE LOG command. Unless performing specialized individual backups that only include Parameter File, Control Files, or Archive Logs, Dell recommends that you select this node when performing Full and Incremental Backups.
Parameter File – (This node is only available for selection if the Control File Autobackup Enabled option on the RMAN Details tab of the Add (or Edit) Oracle Database dialog is not selected.) Select this node to include the PFILE or the SPFILE for the Oracle database in the backup. If the Control File Autobackup Enabled option or the Use RMAN Commands to Backup SPFILE option on the Add (or Edit) Oracle Database dialog is enabled, the Parameter File node will not expand; otherwise, the Parameter File name is displayed when the Parameter File node is expanded.
Control File – (This node is only available for selection if the Control File Autobackup Enabled option on the RMAN Details tab of the Add (or Edit) Oracle Database dialog is not selected.) Select this node to perform a Manual Backup of the Control File. To ensure that a recent copy of the Control File is always available, include it with each RMAN-based backup. Note that if you are not using a Recovery Catalog, you cannot restore a Manual Control File backup via the plug-in. For more information on Manual Control File backups versus Control File Autobackups, see Manual Backups of Control File.
Archive Logs – Because archived redo logs are essential for PIT Recovery and should be backed up regularly, Dell strongly recommends that you select this node to include the Archive Logs in a Full or Incremental backup job. Additionally, the Archive Logs can be independently protected with the Archive Log backup type.
All Tablespaces – Select this node to back up all the tablespaces within the database, or open it and select individual tablespaces to include in the backup. In addition, you can expand the individual tablespaces to select individual datafiles. This is useful for backing up a subset of datafiles because performing whole-database backups takes longer than the allowed backup window.
External Configuration Files (for RMAN Backup Method only) – Select this node to include the External Configuration Files in the backup, or open it and select individual Oracle Network Configuration or Oracle Password files for backup. Plug‑in for Oracle will use Plug-in for FileSystem functionality to back up and restore the Oracle Network Configuration and Oracle Password files.
Post-Backup Scripts – To run a post-backup RMAN script using the plug-in, open this node and select the individual script to be run. For more information on post-backup scripts, see Using RMAN Post-Backup Scripts.
*IMPORTANT: The Database must be in an OPEN state to back up the tablespaces and datafiles. However, the Control Files, SPFILE, and Archive Logs can be backed up with the database in a MOUNT state.
8
Click Save to save the set.
1
In the Navigation pane, click Create Backup Job.
You can also start the wizard from the Guided Configuration link. In the Navigation pane, click Guided Configuration. On the NetVault Configuration Wizard page, click Create backup jobs.
2
In the Selections list, select an existing Backup Selection Set.

Setting backup options

1
Click Create New next to the Plugin Options list.
2
In the Backup Method section, select the RMAN option to perform RMAN backups.
*IMPORTANT: For backups that use the RMAN backup method, do not select the Ensure this backup is the first on the media option on the Target Storage section. The RMAN backup method generates more than one data stream. If you select the Ensure this backup is the first on the media option for such backups, each data stream targets a separate piece of media to exist as the first backup on the media.
When Flash Recovery Area is enabled on the Add (or Edit) Oracle Database dialog, the following options let you select the destination for the backup:
Tape (Backup to NetVault Backup Media) – Selecting this option sends the backup to whatever media you designated on the Target tab of the NetVault Backup WebUI, such as a physical tape, a NetVault Backup VTL stored on the disk, or a NetVault Backup SmartDisk. When you select this option, the plug-in allocates “SBT_TAPE” channels to perform the backup.
Disk (Backup to FRA) – Selecting this option sends the backup to the Oracle drive instead of the NetVault Backup Media. When you select this option, the plug-in allocates DISK channels to perform the backup.
Both Tape and Disk (Backup to FRA then Backup FRA to NetVault Backup Media) – Selecting this option sends the backup to the Oracle drive and then to whatever media you designated on the Target tab in NetVault Backup.
Delete File Copies from Disk After Successful Backup to Tape – Available only when a FRA backup type is selected. When selected, RMAN deletes the recovery files from the FRA after a successful backup. Selecting this option is equivalent to the following RMAN command:
*IMPORTANT: If you select the Delete File Copies from Disk After Successful Backup to Tape option, RMAN deletes the recovery files in the FRA even if the backup job fails. Therefore, make sure that the option selected for Incomplete Backup of ALL Items Selected includes retaining a backup saveset to ensure that the backup to disk can still be restored.

Selecting the Backup Destination of Disk (Backup to FRA) is not supported for External Configuration Files or Parameter Files that are manually input on the Add (or Edit) Oracle Database dialog. This is because the FRA is a portion of disk managed by Oracle. External Configuration Files and Parameter Files that are manually input on the Add (or Edit) Oracle Database dialog are backed up via the Plug-in for FileSystem functionality.
Flash Recovery Area (only available for Oracle 10g and later)
Delete Recovery Files from Flash Recovery Area After Successful Backup – Available only when the FRA backup type is selected. When selected, RMAN will delete the recovery files from the FRA after a successful backup. Selecting this option is equivalent to the following RMAN commands:
*IMPORTANT: FRA backups will fail if previous backups have not been performed with a Backup Destination of Disk or Both Tape and Disk. You must use the FRA as a Backup Destination before you can back up the FRA using the Flash Recovery Area backup type.

When NetVault Backup instructs backups to Disk (Backup to FRA), Incremental Level 0 backups (INCR LVL0) are stored in separate backup sets. Additionally, the first Incremental Level 1 backup (INCR LVL1) — Differential or Cumulative — will generate the base Incremental Level 0 backup copy image, as well as the Incremental Level 1 backup copy image. Subsequent Incremental Level 1 backups will generate only the necessary Level 1 backup copy image update. For Incremental Backups to Disk (Backup to FRA), NetVault Backup uses the Oracle-recommended strategy backup copy image method to maintain incrementally updated copies of the datafiles included in the selection set. For Incremental Level 0 to Disk (Backup to FRA), NetVault Backup instructs Oracle to perform a backupset backup type.
Delete Archive Logs After Successful Backup – If you want to delete the archive logs automatically after they are backed up, thus eliminating the need to delete them manually, select this option. This is useful when backing up the archive logs from disk to tape. This option is equivalent to the RMAN command:
*IMPORTANT: Selecting the Delete Archive Logs After Successful Backup option deletes the archive logs even if the backup job fails. Therefore, make sure that the option selected for Incomplete Backup of ALL Items Selected includes retaining a backup saveset to ensure that the archive logs can still be restored.
Force Additional Log Switch Before Archive Logs Backup – Selecting this option ensures that an additional log switch is performed before the backup of the archived redo logs is started by issuing the SQL statement:
Skip Offline Tablespaces – Select this option if you want the plug-in to ignore the offline tablespaces and omit them from the backup.
Skip Read Only Tablespaces – You should back up read-only tablespaces after an update is performed, but you can skip them in subsequent backups to reduce the size of the backup. Select this option if you want the plug-in to ignore read-only tablespaces and omit them from the backup.
Skip Inaccessible Tablespaces – Operations within Oracle might render a tablespace inaccessible. For example, if a datafile has been removed at the OS level, but not dropped inside the Oracle database or if a raw device mount point link is dismounted, the tablespace might become inaccessible. Select this option if you want the plug-in to skip inaccessible databases that were selected on the NetVault Backup Selections page without causing the backup job to fail.
User Defined Backup Tag – Select this option if you want to create a tag name for the backup set. If you do not specify a tag, RMAN creates a default tag for backups (except for Control File Autobackups) in the format TAGYYYYMMDDTHHMMSS. You can specify the tag rather than the file name when executing the RESTORE command. Tags are stored in uppercase, regardless of the case used when entering them. The maximum length of a tag is 30 bytes.
Files per Backup Set – Backup information is stored in a logical structure called backup set. A backup set contains the data from one or more datafiles, archived redo logs, Control Files, or SPFILE. Note that datafiles and archive logs cannot be combined together in the same backup set. By default, each backup set contains 4 or fewer datafiles, or 16 or fewer archive logs. Use the For Tablespaces/Datafiles and For Archive Logs fields to specify the maximum number of files to include in each backup set created by the plug-in.
Number of Channels – You can control the degree of parallelism within a backup job by allocating the desired number of channels. Allocating multiple channels simultaneously allows a single job to read or write multiple backup sets in parallel. The number of channels should be less than or equal to the number of drives for the backup devices specified on the Target tab. For example, if you are targeting a VTL configured with two drives, the number of channels should be 2 or less. Use the For Tablespaces/Datafiles and For Archive Logs fields to specify the number of channels.
Channel Rate – Use these settings to specify a job-specific RATE for the channels that are used during backups. (RATE is part of the ALLOCATE CHANNEL command.) While defining this RATE does not determine the actual RATE used, it does establish the maximum level for transfers, which prevents RMAN from consuming excessive bandwidth and subsequently degrading performance. Use the For Tablespaces/Datafiles and For Archive Logs fields, and their associated unit settings, to specify the upper-limits. By default, the unit field is blank, which represents bytes. You can also select K (kilobytes), M (megabytes), or G (gigabytes).
Backup as Compressed Backupset – To add the “AS COMPRESSED BACKUPSET” clause to the RMAN BACKUP command, select this check box. It allows RMAN to perform binary compression of backupsets. The compressed backupsets do not require any additional steps during recovery.
Backup <selections> Not Backed up Since (days ago) – Select this option if you want to force the plug-in to resume backups automatically after an interruption occurs. Additionally, you can specify the number of days (the default is 1; the range is 0 through 90) to check backward since the backup was last completed. This feature is useful if your backups are large and prone to possible interruptions.
6
From the Incomplete Backup of ALL Items Selected list, select the default action for the plug-in.
When multiple items are included in a backup and the plug-in is unable to back up all the items selected, even if RMAN successfully cataloged some of the selected items, the plug-in lets you specify what action the backup should take. For example, if a job includes multiple tablespaces and archive logs, and the backup of the archive logs is unsuccessful while the tablespaces are backed up successfully, you can specify what action the backup job should take.
Complete with Warnings - Saveset Retained – The job returns a status of “Backup Completed with warnings” and a backup saveset is created that includes the items that were successfully backed up.
Complete without Warnings - Saveset Retained – The job completes and returns a status of “Backup Completed.” While errors are logged in the NetVault Backup binary logs, the errors are essentially ignored in the Job Status page and a backup saveset is created that includes the items that were successfully backed up.
Fail - Saveset Retained – The job returns a status of “Backup Failed.” However, a backup saveset is generated that includes the items that were successfully backed up.
Fail - No Saveset Retained – The job returns a status of “Backup Failed” and no saveset of backed-up objects is kept. That is, even if some of the selected objects were successfully backed up, the saveset is discarded.
Intended for the advanced DBA, the Generate RMAN Script feature lets you generate the majority of an RMAN script via the NetVault Backup WebUI and later edit the script to add more options or parameters before using the script to perform a backup. With this option, you do not need to create the entire script from scratch, which minimizes the risk of syntax errors in the scripts or that backups are not performed correctly.
When the Output RMAN Script to File option is selected, the commands that the plug-in would have automatically sent to RMAN are stored in a file in a directory that is specified on the plug-in’s Configure dialog. The Oracle DBA can then edit the script as needed and run the script via the RMAN CLI. Backup jobs performed using the automatically generated RMAN scripts are stored in the NetVault Backup Job database.
You can set the following options for the Generate RMAN Script feature:
Output RMAN Script to File – Select this option to use the feature and enable access to the remaining options, and then enter the name of the file to which the RMAN script will be written.
RMAN Script Directory – Enter the name of the directory where the RMAN scripts will be saved. The Generate Script Default Directory field defaults to the directory specified on the plug-in’s Configure dialog. However, you can modify the field on a per-backup-job basis. The full path where the RMAN script will be saved is built by concatenating the RMAN Script Directory with the file name provided in the Output RMAN Script to File field.
If Existing, Overwrite Destination File – Select this option to allow the destination file where the RMAN script will be output to be overwritten if the file exists. If the file exists and this option is not selected, Generate RMAN Script fails and does not write output to the existing file. Select this option only if you are sure that you want to overwrite an existing file.
Generate RMAN Script and Submit Job – With this option selected, in addition to outputting the RMAN script to the specified file, the NetVault Backup Job will be scheduled and submitted. Clearing this option ensures that the plug-in just generates the script, which lets you edit and execute the script outside of NetVault Backup.
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级