Forum Discussion

liuyl's avatar
liuyl
Level 6
5 years ago

The misreporting status 237 with some backup job done result

Both the master server and the media server/client(one same system) are 8.1.1.

At that time, all the EDWODS-arch backup job were failed with status 237,  but in fact the true problem was just due to the abnormal DB
archive processes themselves.  At last, we have to restart the DB itself because there was no any problem found in the NBU layer except for
the only status 237 itself. Then ,after the DB was restarted up, the backup job was just done successfully without any change including its schedule.

So the question is why the misreporting status 237 with the failed backup job would happen ?

root@jcbak:/root#
root@jcbak:/root#
root@jcbak:/root# bpdbjobs -U|head |grep -i edw

1858286 Backup Done 237 EDWODS-arch EDWODS
1858285 Backup Done 237 EDWODS-arch EDWODS
1858284 Backup Done 237 EDWODS-arch EDWODS
1858283 Backup Done 237 EDWODS-arch EDWODS
1858282 Backup Done 6 EDWODS-arch ORA-archivelog EDWODS EDWODS 12845214 No
root@jcbak:/root#
root@jcbak:/root#


1)  vxlogview -o 117:

01/08/2020 15:49:42.339 V-116-191 [ExtReqTask::run_specificPolicy] Could not find appropriate schedule in policy EDWODS-arch, 237
01/08/2020 15:49:42.339 V-116-191 [ExtReqTask::run_specificPolicy] Could not find appropriate schedule in policy EDWODS-arch, 237
01/08/2020 15:49:42.339 [BPCRConnFactory::requestBPCRConnection] inserting connection request (back) BPCRConnectionRequest(pool=6,
connectionName=EDWODS::BPCD::oracle,requester=0x7ffe54045a80)(BPCRConnFactory.cpp:1032


2)  dbclient.log:

15:49:45.894 [31850648] <16> CreateNewImage: ERR - serverResponse() failed
15:49:45.894 [31850648] <16> VxBSACreateObject: ERR - Could not create new image with file /al_174264_1_1029167380.
15:49:45.894 [31850648] <16> xbsa_CreateObject: ERR - VxBSACreateObject: Failed with error: Server Status: the specified schedule does not exist in an active policy in the configuration database
15:49:47.851 [21495998] <16> serverResponse: ERR - server exited with status 237: the specified schedule does not exist in an active policy in the configuration database
15:49:47.851 [21495998] <16> CreateNewImage: ERR - serverResponse() failed


3)  rman.log:

channel ch01 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ch02 channel at 01/08/2020 16:40:14
ORA-19506: failed to create sequential file, name="al_174275_1_1029170406", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: the specified schedule does not exist in an active policy in the configuration database

  • Check that both a policy and schedule is specified in Rman. If only a schedule is specified  Netbackup will try to "guess" the right policy, but may fail in doing so. Also the schedule need to have a opening windows (usually 24*7) when backup are initiated from the Oracle side.

    If not already doing so, please have a look at Netbackup Intelligent Policies for Oracle. OIP removed at lot of the hassle of script based approch.

    • liuyl's avatar
      liuyl
      Level 6

      So this misreporting with status 237 did really strange and inexplicable,  versus everything is good in the NBU layer (including the corresponding schedule open window). 
      Notes: we do not use the OIP function, and also we think that this problem phenomenon should nothing to do with the OIP.

  • Looking at the jobid's it looks like the backup failed with status code 6 before 237.. (jobid 1858282 )

    So I guess the following jobs were due a manual restart of the backup?