Forum Discussion

Arturo_Lopez's avatar
Arturo_Lopez
Level 5
9 years ago
Solved

Scripts RMAN Oracle Variables

Hello,

We have a curious problem with Oracle Netbackup Policies with RMAN script or template. In the client we have defined the next policies:

NB_ORA_POLICY="Policy_Full"
NB_ORA_POLICY_ARCH="Policy_Arch"
NB_ORA_SERV="Master Server RMAN"
NB_ORA_CLIENT="Client"

The version of the master is 7.7.2 with oracle 12.1.0.2. The problem is that when launch de archiver backup in the parent job id appears the policy NB_ORA_POLICY_ARCH but in the all childs jobs appears NB_ORA_POLICY. I don't know because this it's happen because in other systems we have the same configuration and we haven't this problem. (With the same version)

Regards.

 

7.7
Backup and Recovery
Linux
NetBackup
  • Marianne's avatar
    Marianne
    9 years ago

    The unique NB_ORA_POLICY variable for each script/policy combination needs to be hardcoded in each of the scripts.

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

     

4 Replies

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    Did you mean that you have 2 policies defined on NBU master server?

    You should have 2 scripts on the Oracle client:

    - one for Full backup where 
    NB_ORA_POLICY="Policy_Full"
    is hard-coded in the script.

    -another script for Archive logs where
    NB_ORA_POLICY="Policy_Arch"
    is hard-coded in the script.

  • Arturo_Lopez's avatar
    Arturo_Lopez
    Level 5
    9 years ago

    Yes, we have two policies in netbackup (Archiver and Backup Full) both policies have her script that call a oracle .profile with this enviroment variables.

    In all oracle policies have this configuration but now we have a doubt that is the correct configuration.

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    The unique NB_ORA_POLICY variable for each script/policy combination needs to be hardcoded in each of the scripts.

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

     

  • Arturo_Lopez's avatar
    Arturo_Lopez
    Level 5
    9 years ago

    Thank you so much Marianne. I don't know why we were using this variable "NB_ORA_POLICY_ARCH".

    I changed with oracle support all RMAN scripts that are using.

    Regards.