04-16-2015 06:56 AM
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.
Regards
Solved! Go to Solution.
04-16-2015 07:12 AM
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
04-16-2015 07:12 AM
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
04-16-2015 10:07 AM
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
04-16-2015 11:09 PM
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.
04-16-2015 11:38 PM
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
04-17-2015 12:48 AM
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.