Parent job of SAP Backup failing with status code 6

[Jecintha]

Hello,

We have our master server running on Windows 2008 and the version of Netbackup is 7.5.0.5  For a particular client server, a linux machine (Linux 2.6.32-220.el6.x86_64) with the Netbackup version of 7.5, the parent job of SAP DB backup is failing with status code 6.  All the child jobs are getting completed successfully.  The details status log for the parent job is as under:

8/21/2013 10:20:13 PM - Info nbjm(pid=1400) starting backup job (jobid=67801) for client PGERPDEV, policy TCS_HYD_PGCIL_19.147, schedule Daily 
8/21/2013 10:20:13 PM - Info nbjm(pid=1400) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=67801, request id:{139581B4-E278-4173-A0DE-241541E1CCA2}) 
8/21/2013 10:20:13 PM - requesting resource Any
8/21/2013 10:20:13 PM - requesting resource hydesm001.NBU_CLIENT.MAXJOBS.PGERPDEV
8/21/2013 10:20:13 PM - requesting resource hydesm001.NBU_POLICY.MAXJOBS.TCS_HYD_PGCIL_19.147
8/21/2013 10:20:13 PM - granted resource hydesm001.NBU_CLIENT.MAXJOBS.PGERPDEV
8/21/2013 10:20:13 PM - granted resource hydesm001.NBU_POLICY.MAXJOBS.TCS_HYD_PGCIL_19.147
8/21/2013 10:20:13 PM - granted resource hydesm001-hcart
8/21/2013 10:20:13 PM - estimated 0 Kbytes needed
8/21/2013 10:20:13 PM - Info nbjm(pid=1400) started backup (backupid=PGERPDEV_1377103813) job for client PGERPDEV, policy TCS_HYD_PGCIL_19.147, schedule Daily on storage unit hydesm001-hcart
8/21/2013 10:20:13 PM - started process bpbrm (4436)
8/21/2013 10:20:14 PM - Info bpbrm(pid=4436) PGERPDEV is the host to backup data from    
8/21/2013 10:20:14 PM - Info bpbrm(pid=4436) reading file list from client       
8/21/2013 10:20:14 PM - connecting
8/21/2013 10:20:16 PM - Info bpbrm(pid=4436) starting bphdb on client        
8/21/2013 10:20:16 PM - connected; connect time: 00:00:02
8/21/2013 10:20:18 PM - Info bphdb(pid=12991) Backup started          
8/21/2013 10:20:18 PM - Info bphdb(pid=12991) Processing /usr/openv/netbackup/ext/db_ext/sap_online_backup          
8/21/2013 10:20:18 PM - Info bphdb(pid=12991) Waiting for the child status       
8/22/2013 12:55:10 AM - Error bpbrm(pid=4436) from client PGERPDEV: ERR - Script exited with status = 1 <the requested operation was partially successful>
8/22/2013 12:55:10 AM - Error bpbrm(pid=4436) from client PGERPDEV: ERR - bphdb exit status = 6: the backup failed to back up the requested files
8/22/2013 12:55:27 AM - Info bphdb(pid=12991) done. status: 6: the backup failed to back up the requested files
8/22/2013 12:55:27 AM - end writing
the backup failed to back up the requested files(6)

Request help in troubleshooting and resolving the issue.

Regards,

Jecintha

[Nicolai]

Some command in /usr/openv/netbackup/ext/db_ext/sap_online_backup exit with a status coder >1.

Inspect on the client the ouput from brtools - usally in /oracle/<SID>/brbackup/ 

the /usr/openv/netbackup/logs/bphdb debug log

the  /usr/openv/netbackup/logs/backint debug log

the /usr/openv/netbackup/logs/dbclient

[Jecintha]

Hello Nicolai,

Thanks for the response. 

I could not find the path for brbackup.  I could not find any issues with the logs in bphdb and backint log files.  There were no log files under dbclient.

[amol_amodkar]

Hi, 1 ) Please send bphdb logs 2) Check permission on script /usr/openv/netbackup/ext/db_ext/sap_online_backup

[Jecintha]

Hello Amol,

 I've attached the bphdb logs.

With regards to sap_online_backup, the permission is:
-r-xr-xr-x 1 root root 3749 Aug 20 11:27 sap_online_backup

[Thiago_Pereira · Accepted solution]

You have a lot of errors in backup operation, and this error is not from Netbackup, it is from brtools, this is the caus of status 6 in SAP backup on Netbackup, if you have any error in brtools backup, your job in Netbackup will terminate with status 6, so try to contact your SAP team and investigate this problem, because this can be permission problems. Here we dont use root account to run SAP backup, is another account with privileges in SAP DB.

check if you have this folders in /usr/openv/netbackup/logs/

bpbackup
user_ops
brbackup
nbliveup
bpbkar
backint
bphdb

modify the permission of this folders to 777 and run the backup again.

/usr/openv/netbackup/logs/chmod 777 *

[Jecintha]

Hello Thiago,

Thanks for the suggestions. Except for brbackup, we had all the other folders.  I had created a brbackup folder and then modified the permission to 777 *.  I have not initiated the backup as the business hours has already started and hence waiting the monitor the next scheduled backup.

Regards,

Jecintha

[Jecintha]

Hello Thiago,

Thanks for the excellent post.  We had co-ordinated with the SAP Team to work from their end on the issues that we faced in the brtools.  We could see that the last night's backup was completed successfully.

Thanks again for your help.

Regards,

Jecintha

[Thiago_Pereira]

Good could have helped.

Thanks.

[114]

Could you please explain how how the issue sorted out. I am also facing the same issue.