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

Article:TECH31742  |  Created: 2007-01-14  |  Updated: 2007-01-14  |  Article URL http://www.symantec.com/docs/TECH31742
Article Type
Technical Solution

Product(s)

Environment

Languages

Problem



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

Solution



Manual:
NetBackup 4.5 for Oracle System Administrator's Guide Windows NT/2000, Page: 52
Veritas NetBackup 5.0 for Oracle System Administrator's Guide for Windows, Page: 69
Veritas NetBackup 5.1 for Oracle System Administrator's Guide for Windows, Page: 69
Veritas NetBackup 6.0 for Oracle System Administrator's Guide for Windows, Page: 46

NetBackup 4.5 for Oracle System Administrator's Guide Windows UNIX, Page: 92
Veritas NetBackup 5.0 for Oracle System Administrator's Guide for UNIX, Page: 106
Veritas NetBackup 5.1 for Oracle System Administrator's Guide for UNIX, Page: 107
Veritas NetBackup 6.0 for Oracle System Administrator's Guide for UNIX and Linux, Page: 87

Modification Type: Addition.

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

For example, assume the Oracle server is named "ORACLE_01" and it is a member of two Oracle policies, "A_WRONG_POLICY" and "THE_RIGHT_POLICY".  If the backup script/template associated with the policy "THE_RIGHT_POLICY" doesn't specify the policy to use, NetBackup uses the first available policy of which the server is a member, namely "A_WRONG_POLICY".

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.

Option 1:
Setting the proper policy parameter in the RMAN command with the PARMS keyword.
$RMAN target $TARGET_CONNECT_STR rcvcat RMAN_prod/rman@eman msglog $RMAN_LOG_FILE append << EOF
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_POLICY=$NB_ORA_POLICY)';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_POLICY=$NB_ORA_POLICY)';

Option 2:
Setting the proper policy parameter in the RMAN command with the SEND keyword.
$RMAN target $TARGET_CONNECT_STR rcvcat RMAN_prod/rman@eman msglog $RMAN_LOG_FILE append << EOF
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' ;
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' ;
send 'NB_ORA_POLICY=$NB_ORA_POLICY' ;

Option 3:
The policy name can also be hard coded into the scripts with the NB_ORA_POLICY variable.

For example:
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_POLICY=<correct_policy_name>)';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_POLICY=<correct_policy_name>)';

Following these steps ensures the correct Oracle policy is used at run time.



Related Articles



Legacy ID



267589


Article URL http://www.symantec.com/docs/TECH31742


Terms of use for this information are found in Legal Notices

Please Sign In

Login using SymAccount.

Knowledge Base Search

Knowledge Base Search

Rate this Article

Help us improve your support experience.

MySymantec

MySymantec

Contacting Support

Contacting Support