NetBackup™ for Oracle Administrator's Guide

Tablespace or datafile options

Number of parallel streams is the number of parallel backup streams that can be used in a backup operation.

When an Oracle RAC is included in the policy, setting the Number of parallel streams option sets the streams per node. For example, if the Oracle RAC has two nodes that are active and the Number of parallel streams is set to 2, NetBackup uses four streams. NetBackup uses two parallel streams per active node.

Select Specify read-only tablespace options to enable read-only tablespace options. SKIP means to skip the read-only tablespace during backup. FORCE means that RMAN backs up all files.

Select Offline (cold) database backup to shut down the Oracle database and put it in the mount state.

Select Skip offline datafiles to direct the backup operation to not access offline data files.

Tablespace or datafile options (continued)

The Data Guard backup options let you specify a policy to always back up the primary or a standby database:

MSDP storage

The option Use multiple MSDP nodes allows backups of Oracle data files in parallel, which accelerates the backup and restore jobs. You can use multiple MSDP storage units, a storage unit of an MSDP cluster, or a storage unit of an MVG (MSDP volume group) volume.

By default, FILESPERSET is set to 1 for the best deduplication ratio. You can modify this value manually to tune the restore performance for the Oracle RAC environment.

On each Oracle RAC node, in the /usr/openv/netbackup/bp.conf, add a configuration parameter ORACLE_MULTIPLE_STORAGE_OVERRIDE_FILESPERSET. For example, ORACLE_MULTIPLE_STORAGE_OVERRIDE_FILESPERSET = 8.

Specify maximum limits

Select Specify maximum limits to access several I/O and backup set limits. The following parameters should only have to be modified on rare occasions. If these values are not changed, the backup uses the default values that are defined in RMAN. RMAN default values usually provide the best performance.

Backup identifier options

Backup set identifier: (TAG) specifies a user-specified tag name for a backup set, proxy copy, data file copy, or control file copy. The tag is applied to the output files that the backup generates.

Datafile copy tag: This option specifies a user-specified tag name when the Whole Database - Datafile Copy Share option is used. The tag is associated with the data files that are located on the appliance and is used during the incremental merge process.

Archived redo log options

Select Include archived redo logs in full and incremental schedules to include the archived redo logs on the full and the incremental schedule backups.

Select Delete after making copies to delete the archived redo logs after the selected number of backups are successful. Clear the box or set to 0 to skip the delete operation and retain the logs after backup.

Select Delete archived redo logs after (Hours) so that only the redo logs that are older than the selected value are deleted after a backup.

Number of parallel streams controls the degree of parallelism within a backup. This number specifies the maximum number of connections between RMAN and a database. Each connection initiates an Oracle database server session on the target database. This server session performs the work of backing up backup sets.

When an Oracle RAC is included in the policy, setting the Number of parallel streams option sets the streams per node. For example, if the Oracle RAC has two nodes that are active and the Number of parallel streams is set to 2, NetBackup uses four streams. NetBackup uses two parallel streams per active node.

Specify Specify maximum limits to set custom limits for the archive redo logs.

User specified backup file name formats

Select Specify backup file name formats to set up formats for various backup file names for data files, archived redo logs, the control file, and Fast Recovery Area (FRA).

Ensure that the format that is specified for all RMAN backup piece names (except for auto-backups of the control file) uses the _%u and ends with _%t. NetBackup uses this timestamp as part of its search criteria for catalog images. Without this timestamp, performance might degrade as the NetBackup catalog grows. These recommendations help to ensure proper backup, restore, and crosscheck functionality.

Database backup share options

These options let you set a time when backup sets and backup copies (data and control file copies) are automatically deleted from the appliance share. However, the files are only deleted if they have been successfully backed up from the share. The two options are Delete protected backup sets from share after and Delete protected backup copies from share after. The deletion is based on the age of the file in the share. The original dump time or the update time (if an incremental merge is done on the file) determines the age of the file.

These options are only available when the Database backup shares option is selected in the Backup selections tab.

Use the dropdowns to set the minutes, hours, days, or weeks.