cancel
Showing results for 
Search instead for 
Did you mean: 

Start Schedule Name on Oracle Client

Old_Remove
Level 4
Hello !

On an SAP Automatic backup the name of the start schedule will be send to the client as the value "SAP_SNC_SCHED" in the environment of the user with them the NBU client is running. Is there a variable on a oracle client with the same funtion? I start an Automatic Schedule in a policy with type Oracle. This schedule is named Full_Daily_Ora. The Application Schedule name for backcoming job is App_Daily_Ora. Will on the client a variable created with the value "Full_Daily_Ora"? Thanks !
1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

So your policy type is Oracle, not SAP?

The Policy and Schedule name can be hard-coded in the script.

Extract from manual:

Shell scripts
Use the send command or the parms operand to specify NetBackup for Oracle environment variables for use during a backup or restore.
Example 1. This example uses the send command to specify the policy and server to use for a database backup. As this example shows, specify the variables in the string in the RMAN script after all channels have been allocated and
before the backup command.
run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NB_ORA_POLICY=your_policy, NB_ORA_SCHED=your_schedule, NB_ORA_SERV=your_server’;
backup
(database format 'bk_%U_%t');



Another alternative is to set it in bp.conf or via Env variables:

NetBackup can select a policy or schedule in error if there are several Oracle policies in its database. Try setting the SERVER and POLICY values in the bp.conf file on the client or by setting environment variables.
For example, the following C Shell setenv commands specify the Oracle policy, schedule, and server for NetBackup to use:
setenv NB_ORA_POLICY policyname
setenv NB_ORA_SCHED application_backup_schedule_name
setenv NB_ORA_SERV NetBackup_server

bp.conf:
bp.conf file on the client or by setting the following bporaexp
parameters:
NB_ORA_POLICY=policyname
NB_ORA_SCHED=schedule
NB_ORA_SERV=NetBackup_server
NB_ORA_CLIENT=NetBackup_client

You did not mention your O/S or NBU version. See NBU 6.5 for Oracle on Unix manual:
ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/290216.pdf






View solution in original post

3 REPLIES 3

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

So your policy type is Oracle, not SAP?

The Policy and Schedule name can be hard-coded in the script.

Extract from manual:

Shell scripts
Use the send command or the parms operand to specify NetBackup for Oracle environment variables for use during a backup or restore.
Example 1. This example uses the send command to specify the policy and server to use for a database backup. As this example shows, specify the variables in the string in the RMAN script after all channels have been allocated and
before the backup command.
run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NB_ORA_POLICY=your_policy, NB_ORA_SCHED=your_schedule, NB_ORA_SERV=your_server’;
backup
(database format 'bk_%U_%t');



Another alternative is to set it in bp.conf or via Env variables:

NetBackup can select a policy or schedule in error if there are several Oracle policies in its database. Try setting the SERVER and POLICY values in the bp.conf file on the client or by setting environment variables.
For example, the following C Shell setenv commands specify the Oracle policy, schedule, and server for NetBackup to use:
setenv NB_ORA_POLICY policyname
setenv NB_ORA_SCHED application_backup_schedule_name
setenv NB_ORA_SERV NetBackup_server

bp.conf:
bp.conf file on the client or by setting the following bporaexp
parameters:
NB_ORA_POLICY=policyname
NB_ORA_SCHED=schedule
NB_ORA_SERV=NetBackup_server
NB_ORA_CLIENT=NetBackup_client

You did not mention your O/S or NBU version. See NBU 6.5 for Oracle on Unix manual:
ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/290216.pdf






Christoph_Linde
Level 5
Employee
bphdb creates the ENV Var $NB_ORA_PC_SCHED which contains the schedule name from automatic schedule.


Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Experience has shown that if Policy/Sched is not specified and Client exists in more than one Oracle policy, the 1st schedule that is found in policy config will be chosen for the backup.

Johannes has experienced this and the manual also confirms this behaviour:

NetBackup can select a policy or schedule in error if there are several Oracle policies in its database. Try setting the SERVER and POLICY values in the bp.conf file on the client or by setting environment variables.