The User Managed backup procedure includes the following steps:
Backup Selection Sets are essential for Incremental and Differential Backups. 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 Quest NetVault Backup Administrator’s Guide.
1 |
2 |
In Job Name, specify a name for the job. |
3 |
4 |
• |
Account Name: Specify an Oracle database user with SYSDBA privileges. |
• |
Password: Enter the password associated with the name specified in the preceding field. |
• |
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 |
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.
The database has the following tablespaces:
• |
• |
• |
• |
1 |
Create an ASIA_TS backup job that explicitly selects China_Sales, Japan_Sales, and Korea_Sales tablespaces. |
2 |
3 |
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. |
The next step involves creating the Backup Options Set or selecting an existing one.
1 |
2 |
• |
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. |
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. |
• |
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 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center