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

Performing User Managed backups

The User Managed backup procedure includes the following steps:
•
Selecting data for a backup
•
Selecting backup options
•
Finalizing and submitting the job
Selecting data for a backup
You must use sets (Backup Selection Set, Backup Options Set, Schedule Set, Target Set, and Advanced Options Set) to create a backup job.
Backup Selection Sets are essential for Incremental and Differential Backups. You must create the Backup Selection Set during a Full Backup, and use it for Full, Incremental, and Differential Backups. The backup job reports an error if you do not use a Selection Set for the Incremental or Differential Backup. For more information, see the Dell NetVault Backup Administrator’s Guide.
To create a Backup Selection 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 Job Name, specify a name for the job.
Assign a descriptive name that lets you easily identify the job when monitoring its progress or restoring data. The job name can contain alphanumeric and non-alphanumeric characters, but it cannot contain non-Latin characters. On Linux®, the names can have a maximum of 200 characters. On Windows®, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
3
Next to the Selections list, click Create New.
4
In the list of plug-ins, open Plug‑in for Oracle, and then open the database you want to back up.
5
If you have not configured the plug-in’s authentication details, enter the required information when the prompt appears, and then click OK.
•
Account Name: Specify an Oracle® database user with SYSDBA privileges.
•
Password: Enter the password associated with the name specified in the preceding field.
6
After the plug-in connects to the database and lists the supported file types for selection, select the data that you want to back up.
The plug-in supports the following file types for User Managed backups:
•
Parameter File: Select this check box to include the PFILE or the SPFILE for the Oracle database. You can open this node and see the filename; however, file selection is not permitted at that level.
•
Control File: When selected, the plug-in takes a snapshot of the Control File and saves it to the path and file specified in the Control File Save Filename (Full Path) field on the Add (or Edit) Oracle Database dialog box. The snapshot copy of the Control File is then backed up to the backup device.
•
Archive Logs: Select this option to back up all the archived redo logs specified in the Archive Log Destination Directory field on the User Managed Details tab. (The plug-in does not delete the backed-up archived redo logs automatically.)
•
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. Currently, the plug-in does not support backing up individual datafiles for User Managed backup selections, but you can select an individual datafile for restoration.
•
External Configuration Files (for RMAN Backup Method only): This option applies to the RMAN backup method. If External Configuration Files are included in the selections for the User Managed backup method, a Warning message is shown in the NetVault Backup binary logs. However, the backup job status is not set to Backup Completed for Warnings for this single warning. That is, the backup task ignores the logged warning.
•
Post-Backup Scripts: This option applies to the RMAN backup method.
 
* 
IMPORTANT: Selecting individual datafiles for backup with the User Managed backup method results in a backup error and a message in the NetVault Backup binary logs, “Individual Datafile Level Backup is not supported by the User Managed Backup Method.”

If the files stored in Oracle’s ASM are selected for backup with the User Managed backup method, the backup job fails. This selection includes any datafile, SPFILE, Control File, or any other file stored in ASM. If ASM is enabled for this database, the RMAN backup method must be used.
7
Click Save, enter a name in the Create New Set dialog box, and click Save.
The name can contain alphanumeric and non-alphanumeric characters, but it cannot contain non-Latin characters. On Linux®, the names can have a maximum of 200 characters. On Windows®, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
To use an existing Backup Selection 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.
Inclusive Oracle tablespace backup selection
If a large Oracle® database has been split over a number of separate backup jobs, the content for these jobs is typically explicitly defined; that is, tablespaces are explicitly or manually selected with a large green check mark. If new tablespaces are created within the Oracle Instance, they are not included in the existing backup jobs; they are excluded because the tablespaces have been manually selected while the new tablespaces have not been included in the list of tablespaces to back up.
To ensure that new tablespaces are included in the backups, create another inclusive backup job where the All Tablespaces node is explicitly or manually selected. This step allows newly created tablespaces to be backed up as part of the inclusive backup job.
Example
The database has the following tablespaces:
•
China_Sales
•
Japan_Sales
•
Korea_Sales
•
LA_Sales
•
London_Sales
•
NY_Sales
•
SD_Sales
•
UK_Sales
1
Create an ASIA_TS backup job that explicitly selects China_Sales, Japan_Sales, and Korea_Sales tablespaces.
2
Create a US_TS backup job that explicitly selects LA_Sales, NY_Sales, and SD_Sales tablespaces.
3
Create an EMEA_TS backup job that explicitly selects London_Sales and UK_Sales tablespaces.
4
Create an All_TS backup job that explicitly selects the All Tablespaces node and clears all the tablespaces included in the other backup jobs.

Selecting backup options

The next step involves creating the Backup Options Set or selecting an existing one.
To create a Backup Options Set:
1
Next to the Plugin Options list, click Create New.
2
In the Backup Method section, select the User Managed option to perform a User Managed backup.
3
If applicable, select the following options:
•
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 option is useful when you are backing up the archive logs to backup media.
The plug-in backs up each log sequence number and then delete the file that it has backed up. If you have multiple archive destinations for your redo logs, the other copies of the same log sequence number are not deleted.
 
* 
IMPORTANT: Selecting the Delete Archive Logs After Successful Backup option deletes the archive logs even if the backup job fails. Therefore, ensure 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.
•
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.” The errors are logged in the NetVault Backup binary logs and ignored on the Job Status page. A backup saveset is created that includes the items that were 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 objects were successfully backed up, the saveset is discarded.
5
Click Save to save the set.
6
In the Create New Set dialog box, specify a name for the set, and click Save.
The name can contain alphanumeric and non-alphanumeric characters, but it cannot contain non-Latin characters. On Linux®, the names can have a maximum of 200 characters. On Windows®, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
To use an existing Backup Options Set:
In the Plugin Options list, select the existing Backup Options Set that you want to use.

Finalizing and submitting the job

To finalize and submit a backup 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.
You can monitor progress on the Job Status page and view the logs on the View Logs page. For more information, see the Dell NetVault Backup Administrator’s Guide.

Performing RMAN backups

The RMAN backup procedure includes the following steps:
•
Selecting data for a backup
•
Setting backup options
•
Finalizing and submitting the job
Selecting data for a backup
You must use sets (Backup Selection Set, Backup Options Set, Schedule Set, Target Set, and Advanced Options Set) to create a backup job.
Backup Selection Sets are essential for Incremental and Differential Backups. You must create the Backup Selection Set during a Full Backup, and use it for Full, Incremental, and Differential Backups. The backup job reports an error if you do not use a Selection Set for the Incremental or Differential Backup. For more information, see the Dell NetVault Backup Administrator’s Guide.
To create a Backup Selection 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 Job Name, specify a name for the job.
Assign a descriptive name that lets you easily identify the job when monitoring its progress or restoring data. The job name can contain alphanumeric and non-alphanumeric characters, but it cannot contain non-Latin characters. On Linux®, the names can have a maximum of 200 characters. On Windows®, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
3
Next to the Selections list, click Create New.
4
In the list of plug-ins, open Plug‑in for Oracle, and then open the database you want to back up.
5
If you have not configured the plug-in’s authentication details, enter the required information when the prompt appears, and then click OK.
•
Account Name: Specify an Oracle® database user with SYSDBA privileges.
•
Password: Enter the password associated with the name specified in the preceding field.
6
After the plug-in connects to the database and lists the supported file types for selection, select the data that you want to back up.
The plug-in supports the following file types for RMAN backups:
•
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 box 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 box is enabled, the Parameter File node does 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 box 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. If you are not using a Recovery Catalog, you cannot restore a Manual Control File backup by using 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 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 option 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 uses Dell NetVault Backup Plug-in for FileSystem (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.
7
Click Save, enter a name in the Create New Set dialog box, and click Save.
The name can contain alphanumeric and non-alphanumeric characters, but it cannot contain non-Latin characters. On Linux®, the names can have a maximum of 200 characters. On Windows®, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
To use an existing Backup Selection 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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating