cancel
Showing results for 
Search instead for 
Did you mean: 

NBU for Oracle - job policy in activity monitor

laughingman1
Level 3

Hi,

I'm Oracle DBA which trying to configure backup's with NBU. I'm using NBU 7.6.0.3 for Oracle database RMAN backup with scripts. I've created several policies for different databases. I've got separate policies and separate scripts for full backup, cummulative and archivelogs. In all policies there is scheduler that I created and there is also scheduler created by default caled "Default-Application-Backup". If I understand correctly it this scheduler is mandatory to start manual backup's.
For simplicity lets say I've got 3 policies

1. Policy Name - ORCL_OPSREP_FULL

2. Policy Name - ORCL_EMREP_FULL

3. Policy Name - ORCL_EMREP_ARC

My problem is the following. When I starting backup with policy eg. "ORCL_EMREP_ARC" I see in "Activity Monitor" that backup process starts whit "Job Policy" "ORCL_EMREP_ARC" but all sub processes for that backup shows up with "Job Policy" of different policy - "ORCL_OPSREP_FULL" (first one that I created). I've chcek RMAN logs and it seems that all files for started policy are backed up correctly.  But why job policy in activity monitor is showing wrong name and how to fix this?

Please find attachment with simple screen from Activity Monitor.

NBU.PNG

 

Regards

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Unfortunately something that has been a pain for many years...

You need to specify the policy in the script with NB_ORA_POLICY parameter.

See:

DOCUMENTATION: Failing to specify the Oracle policy can result in Veritas NetBackup (tm) using the incorrect policy.
http://www.symantec.com/docs/TECH31742 

View solution in original post

5 REPLIES 5

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Unfortunately something that has been a pain for many years...

You need to specify the policy in the script with NB_ORA_POLICY parameter.

See:

DOCUMENTATION: Failing to specify the Oracle policy can result in Veritas NetBackup (tm) using the incorrect policy.
http://www.symantec.com/docs/TECH31742 

Nicolai
Moderator
Moderator
Partner    VIP   

Consider trying out Netbackup Oracle Intelligent Policies. No more fiddling around with scrips and VERY VERY easy to configure.

Regarding the policy and schedule name - I recommend setting the follwing options in the RMAN send

NB_ORA_CLIENT

NB_ORA_POLICY

NB_ORA_SCHED

There is a list of them Netbackup admin guide for Oracle page 90. If none is defined Netbackup does guessing and that does not always work as you already have discovered.

http://www.symantec.com/docs/DOC6481

Hope this help !!

Best Regards

Nicolai

 

Mouse
Moderator
Moderator
Partner    VIP    Accredited Certified

The reason why it does not work is because NBU returns first "Default-Application-Backup" schedule it finds in the catalog and it works fine if you have just one policy with Oracle type for this client.

Unfortunately if you use more than one Oracle policy per client then you need to hard code the policy name to the script: SEND 'NB_ORA_POLICY=<Oracle_policy_name>’; before each backup statement, like:

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_POLICY=<Oracle_policy_name>’;
BACKUP

Also Oracle Intelligent Policy is also an option here but it does not provide the same level of functionality as RMAN scripts.

laughingman1
Level 3

This is it! Thanks a lot.
Sadly I can't use OIP because there is no way to manually run backup directly from client, and OIP is not recommended to backup Oracle RAC databases.

https://www-secure.symantec.com/connect/forums/oracle-intelligent-policy-logs

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Also in my post of yesterday and TN that I have linked:

DOCUMENTATION: Failing to specify the Oracle policy can result in Veritas NetBackup (tm) using the incorrect policy.
http://www.symantec.com/docs/TECH31742 

extract: 

Issue

DOCUMENTATION: Failing to specify the Oracle policy can result in Veritas NetBackup (tm) using the incorrect policy.

If the master server has multiple Oracle policies, and the Oracle script or template does not specify which policy to use, the Oracle backup uses the first valid Oracle policy of which the Oracle server is a member, in alphabetical order.  

To correct this problem, specify the policy using the "NB_ORA_POLICY" parameter.  The "NB_ORA_POLICY" parameter tells the backup script which policy to use for the backup. The NB_ORA_POLICY environment variable is passed to the script by NetBackup.  There are three ways of doing this based on the NetBackup sample scripts.