Oracle BD backup; EXIT STATUS = 6: the backup failed to back up the requested files

[Faiza]

Hello,

I do backup of Oracle DB and everything was ok but since last week Netbackup shows same error below, I already troubleshot but not resolved yet, please help me on this issue:

10/14/2016 09:28:10 - Info nbjm (pid=6140) starting backup job (jobid=63535) for client AHRDB.gbrs.dz, policy Hassi-PRD-AHRDB-Oracle-01, schedule MonthlyFull
10/14/2016 09:28:10 - Info nbjm (pid=6140) requesting STANDARD_RESOURCE resources from RB for backup job (jobid=63535, request id:{19A092DE-92E5-4BA7-B790-9C990BEF1687})
10/14/2016 09:28:10 - requesting resource hsrv-e2b1p-bkp1-hcart2-robot-tld-0
10/14/2016 09:28:10 - requesting resource hsrv-e2b1p-bkp1.NBU_CLIENT.MAXJOBS.AHRDB.gbrs.dz
10/14/2016 09:28:10 - granted resource hsrv-e2b1p-bkp1.NBU_CLIENT.MAXJOBS.AHRDB.gbrs.dz
10/14/2016 09:28:10 - granted resource ACU488
10/14/2016 09:28:10 - granted resource HP.ULTRIUM5-SCSI.001
10/14/2016 09:28:10 - granted resource hsrv-e2b1p-bkp1-hcart2-robot-tld-0
10/14/2016 09:28:12 - estimated 1415616 kbytes needed
10/14/2016 09:28:12 - Info nbjm (pid=6140) started backup (backupid=AHRDB.gbrs.dz_1476433690) job for client AHRDB.gbrs.dz, policy Hassi-PRD-AHRDB-Oracle-01, schedule MonthlyFull on storage unit hsrv-e2b1p-bkp1-hcart2-robot-tld-0
10/14/2016 09:28:13 - Info bpbrm (pid=11612) starting bptm
10/14/2016 09:28:13 - Info bpbrm (pid=11612) Started media manager using bpcd successfully
10/14/2016 09:28:13 - started process bpbrm (pid=11612)
10/14/2016 09:28:15 - Info bpbrm (pid=11612) AHRDB.gbrs.dz is the host to backup data from
10/14/2016 09:28:15 - Info bpbrm (pid=11612) telling media manager to start backup on client
10/14/2016 09:28:15 - Info bptm (pid=12008) using 262144 data buffer size
10/14/2016 09:28:15 - Info bptm (pid=12008) using 1024 data buffers
10/14/2016 09:28:17 - Info bptm (pid=12008) start backup
10/14/2016 09:28:17 - Info bptm (pid=12008) Waiting for mount of media id ACU488 (copy 1) on server hsrv-e2b1p-bkp1.
10/14/2016 09:28:20 - mounting ACU488
10/14/2016 09:28:23 - Info bpbrm (pid=9476) sending bpsched msg: CONNECTING TO CLIENT FOR AHRDB.gbrs.dz_1476433690
10/14/2016 09:28:23 - Info bpbrm (pid=9476) listening for client connection
10/14/2016 09:28:23 - connecting
10/14/2016 09:28:29 - Info bptm (pid=11864) setting receive network buffer to 1049600 bytes
10/14/2016 09:28:31 - Info bpbrm (pid=9476) INF - Client read timeout = 300
10/14/2016 09:28:32 - Info bpbrm (pid=9476) accepted connection from client
10/14/2016 09:28:32 - connected; connect time: 0:00:00
10/14/2016 09:29:18 - Info bptm (pid=12008) media id ACU488 mounted on drive index 1, drivepath {3,0,2,0}, drivename HP.ULTRIUM5-SCSI.001, copy 1
10/14/2016 09:29:18 - mounted ACU488; mount time: 0:00:58
10/14/2016 09:29:26 - positioning ACU488 to file 3
10/14/2016 09:31:05 - positioned ACU488; position time: 0:01:39
10/14/2016 09:31:05 - begin writing
10/14/2016 09:43:33 - Error bpbrm (pid=9476) client AHRDB.gbrs.dz EXIT STATUS = 6: the backup failed to back up the requested files (line 16123)
10/14/2016 09:43:33 - Info dbclient (pid=0) done. status: 6

10/14/2016 09:43:34 - Info bpbrm (pid=11612) child done, status 6

10/14/2016 09:43:34 - Info bpbrm (pid=11612) sending message to media manager: STOP BACKUP AHRDB.gbrs.dz_1476433690
10/14/2016 09:43:46 - Info bpbrm (pid=11612) media manager for backup id AHRDB.gbrs.dz_1476433690 exited with status 150: termination requested by administrator
10/14/2016 09:43:46 - end writing; write time: 0:12:41
the backup failed to back up the requested files (6)

[Michael_G_Ander]

https://vox.veritas.com/t5/NetBackup/General-database-backup-error-troubleshooting/m-p/675381

Contains information about troubleshooting database backups

Have you talked with your DBA ? Always a good idea when doing database stuff

[Marianne]

So, what have you done to troubleshoot up to now?

Can you share Oracle output file?

And dbclient log? 
If dbclient folder does not exist, create it under ...netbackup/logs.
If Unix/Linux, add 777 permission on the folder.

Retry the backup after creating the log folder.
Once backup has failed, copy dbclient log to dbclient.txt and upload here.
Share Oracle output as well. (Copy to oracle-out.txt and upload.)

[Faiza]

Thank you

 It seems that the DBA install last week paths for the DB, I will work with him to troubleshoot on the issue as you explain, hope to fix

[Faiza]

We have tried to do export of the DB, to check if is there a problem with Oracle backup process, and the export was successful, I checked the name loockup between the client and NBU and permission to access to DB folders for NetbackupUser it's ok.. 

[Faiza]

Hello Marianne,

   I just check the logs files, they folders are empty...what may I do ?

Thanks

[Will_Restore]

Status 6 is generic "database backup failed". 

For Oracle, start with the RMAN .out file (DBA should know where that is).

[Faiza]

Thank you

The DBA has changed the DB mode from no Archive log to Archive log, does it have effect on Netbackup process ?

[Marianne]

This means that rman failed before it got to NBU.
Or else dbclient does not have 777 permission.

There should at least be an rman .out file in the same folder as the script. This is the first place to look as the problem is clearly with script or rman.

[Marianne]

Oracle db's must be in Archive log mode in order for rman backups to work.