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 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. |
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. |
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.