Search <book_title>...

Veritas NetBackup™ for Oracle Administrator's Guide

Last Published: 2018-04-13

Product(s): NetBackup (8.1.1)

NetBackup for Oracle with Snapshot Client environment variables

You can use environment variables to change the number of streams the proxy copy session uses or to specify an alternate backup schedule.

The following list shows the variables that you can to set that are specific to NetBackup for Oracle with Snapshot Client:

NB_ORA_PC_SCHED

The NetBackup for Oracle schedule NetBackup uses for a proxy copy file-based backup. (This schedule can be Full, Differential Incremental, or Cumulative Incremental backup type).

For scheduled backups, this variable is passed from the scheduler. When you create an RMAN template with the NetBackup for Oracle RMAN template generation wizard, this variable is automatically created in the template.

NB_ORA_PC_STREAMS

Specifies the number of backup streams that NetBackup starts simultaneously in each proxy copy session. When a backup starts, NetBackup groups all data files into a specified number of backup streams that are based on the file sizes. NetBackup tries to create streams of equal size.

The default value for NB_ORA_PC_STREAMS is 1.

Only a user can set this variable. When you create an RMAN template using the NetBackup for Oracle RMAN template generation wizard, this variable is automatically created in the template when you provide a value for the Number of parallel streams.

For NetBackup for Oracle with Snapshot Client, the order of precedence for environment variables is the same as for standard NetBackup for Oracle. Refer to the instructions for how to configure the NetBackup and the user variables.

NetBackup for Oracle installs sample scripts in the following location:

Windows:

install_path\NetBackup\dbext\oracle\samples\rman

UNIX:

/usr/openv/netbackup/ext/db_ext/oracle/samples/rman

The following are the scripts for NetBackup for Oracle with Snapshot Client that show how to configure the required variables:

Windows: hot_database_backup_proxy.cmd

UNIX: hot_database_backup_proxy.sh

This script sets the environment and calls RMAN with the appropriate command to perform a whole database proxy backup. When NetBackup runs a schedule, it sets the environment variables that NetBackup for Oracle with Snapshot Client uses. The script shows how to use the RMAN send command to pass the NetBackup for Oracle with Snapshot Client variables with a vendor-specific quoted string.

Windows: hot_tablespace_backup_proxy.cmd

UNIX: hot_tablespace_backup_proxy.sh

This script sets the environment and calls RMAN with the appropriate command to perform a tablespace proxy backup.

If you use scripts, use the send command to pass the environment variables to the agent. The following example uses the send command to specify the values for NB_ORA_PC_SCHED and NB_ORA_PC_STREAMS:

   run {
    allocate channel t1 type 'SBT_TAPE';
    send 'NB_ORA_PC_SCHED= sched, NB_ORA_PC_STREAMS= number';
    backup proxy
    (database format 'bk_%U_%t');
    }

For more information, see the sample scripts that are provided with the agent.

More Information

About configuring the run-time environment

Proxy backup examples