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

Backup of an Oracle Database Fails and Error Message "Unable to get information on policy" Is Displayed

Publication Date:  2015-07-29 Views:  67 Downloads:  0
Issue Description
After a backup template file for the Oracle database server is created on the NetBackup client, error message is displayed after the backup template file is executed manually.


Handling Process
Specify a backup policy for the backup template file.
Root Cause
Possible Causes:

The error message cannot identify problem causes. You must collect more logs to analyze the problem causes.

Fault Diagnosis:

1.  On the NetBackup Administration Console of the HDP3500E master server, choose NetBackup Management > Host Properties > Clients. Set the log level of the Oracle database server to 5.




2.  Create the bpdbsbora directory under /usr/openv/netbackup/logs on the Oracle database server.

3.  Manually implement the backup policy of the Oracle database server on the HDP3500E master server.

4.  Check the bphdb process log on the Oracle database server. The log is as follows:

11:04:00.257 [8760] <2> logconnections: BPRD CONNECT FROM 129.31.28.33.11838 TO 129.31.28.250.1556 fd = 5
11:04:00.257 [8760] <2> vnet_check_vxss_client_magic_with_info: ../../libvlibs/vnet_vxss_helper.c.843: 140158823569152: Assuming no VxSS for DB Agents: 0 0x00000000
11:04:00.257 [8760] <4> VxBSAGetPolicyInfo: INF - request string: <oracle11g oracle11g-03 NONE>
11:04:00.265 [8760] <8> VxBSAGetPolicyInfo: WRN - GET_POLICY_INFO request returned: 230 <the specified policy does not exist in the configuration database>
11:04:00.266 [8760] <16> sbint_GetPolicyInfo(): Unable to get information on policy, oracle11g-03.


    The log shows that backup policy oracle11g-03 does not exist on the HDP3500E master server. As a result, the backup fails.

5.  On the HDP3500E master server, run the following command to check whether backup policy oracle11g-03 exists.

hdp3500e:/usr/openv/netbackup/bin/admincmd # ./bppllist oracle11g-03 -U
the specified policy does not exist in the configuration database (230)


     The output information shows that backup policy oracle11g-03 does not exist.

END