No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

The Backup Policy for the Oracle Database Server Displayed in Activity Monitor Is Inconsistent with the Actual Backup Policy

Publication Date:  2015-07-29 Views:  53 Downloads:  0
Issue Description
When backup policy oracle11g-02 is used to back up a file of the Oracle database server, Policy is displayed as oracle11g, which is inconsistent with the actual backup policy name.

The backup policy list is as follows:




On the Activity Monitor, check the backup task logs.

Handling Process
Method 1: Modify the backup script or template file. Add a policy name variable to each backup instruction.

Add SEND 'NB_ORA_POLICY=$NB_ORA_POLICY'; to the backup script.

RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_POLICY=$NB_ORA_POLICY';
...
BACKUP
...
}


Method 2: Modify the backup script or template file. Add a policy name to each backup instruction.

Add SEND 'NB_ORA_SERV=NBUServer,NB_ORA_CLIENT=NBUClient,NB_ORA_POLICY=policy-name'; to the backup script. Specify the backup policy name in NB_ORA_POLICY=policy-name.

RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=NBUServer,NB_ORA_CLIENT=NBUClient,NB_ORA_POLICY=policy-name';
BACKUP
...
}
Root Cause
When two or more backup policies for the Oracle database server (in this topic, backup policies oracle11g and oracle11g-02 are created for the Oracle database server) are created on the HDP3500E master server and no backup policy is specified in the backup script or template file, the NetBackup automatically selects an available backup policy. Therefore, the backup policy name displayed in the Activity Monitor is different from the actual backup policy name.

Suggestions
Create only one backup policy for the Oracle database server. The backup policy can contain multiple time tables. If multiple backup policies are required, specify the policy names in the backup script or template file.

END