07-02-2015 07:52 PM
Hi All,
We are having an status 6 error of our ORACLE backup using RMAN script.
Below is the backup job detailed status.
07/02/2015 02:00:17 - Info nbjm (pid=14680122) starting backup job (jobid=67149) for client LBPDWP, policy ORA_LBPDWHP_LBPDWP, schedule Default-Application-Backup
07/02/2015 02:00:17 - Info nbjm (pid=14680122) requesting STANDARD_RESOURCE resources from RB for backup job (jobid=67149, request id:{08265244-201B-11E5-9145-764088040000})
07/02/2015 02:00:17 - requesting resource LBPDWP-hcart3-robot-tld-4
07/02/2015 02:00:17 - requesting resource NETBACKUPSVR.NBU_CLIENT.MAXJOBS.LBPDWP
07/02/2015 02:00:17 - requesting resource NETBACKUPSVR.NBU_POLICY.MAXJOBS.ORA_LBPDWHP_LBPDWP
07/02/2015 02:00:17 - Waiting for scan drive stop IBM.ULT3580-TD6.004, Media server: LBPDWP
07/02/2015 02:00:18 - granted resource NETBACKUPSVR.NBU_CLIENT.MAXJOBS.LBPDWP
07/02/2015 02:00:18 - granted resource NETBACKUPSVR.NBU_POLICY.MAXJOBS.ORA_LBPDWHP_LBPDWP
07/02/2015 02:00:18 - granted resource 0081L5
07/02/2015 02:00:18 - granted resource IBM.ULT3580-TD6.004
07/02/2015 02:00:18 - granted resource LBPDWP-hcart3-robot-tld-4
07/02/2015 02:00:18 - estimated 0 kbytes needed
07/02/2015 02:00:18 - Info nbjm (pid=14680122) started backup (backupid=LBPDWP_1435773618) job for client LBPDWP, policy ORA_LBPDWHP_LBPDWP, schedule Default-Application-Backup on storage unit LBPDWP-hcart3-robot-tld-4
07/02/2015 02:00:20 - Info bpbrm (pid=352290) LBPDWP is the host to backup data from
07/02/2015 02:00:20 - Info bpbrm (pid=352290) reading file list from client
07/02/2015 02:00:20 - started process bpbrm (pid=352290)
07/02/2015 02:00:20 - connecting
07/02/2015 02:00:21 - Info bpbrm (pid=352290) listening for client connection
07/02/2015 02:00:21 - Info bpbrm (pid=352290) INF - Client read timeout = 300
07/02/2015 02:00:21 - Info bpbrm (pid=352290) accepted connection from client
07/02/2015 02:00:21 - Info bphdb (pid=2420850) Backup started
07/02/2015 02:00:21 - Info bpbrm (pid=352290) bptm pid: 2494532
07/02/2015 02:00:21 - Info bptm (pid=2494532) start
07/02/2015 02:00:21 - Info bptm (pid=2494532) using 65536 data buffer size
07/02/2015 02:00:21 - Info bptm (pid=2494532) using 30 data buffers
07/02/2015 02:00:21 - connected; connect time: 0:00:00
07/02/2015 02:00:22 - Info bptm (pid=2494532) start backup
07/02/2015 02:00:22 - Info bptm (pid=2494532) Waiting for mount of media id 0081L5 (copy 1) on server LBPDWP.
07/02/2015 02:00:22 - mounting 0081L5
07/02/2015 02:00:27 - Error bptm (pid=2494532) error requesting media, TpErrno = Robot operation failed
07/02/2015 02:00:27 - Warning bptm (pid=2494532) media id 0081L5 load operation reported an error
07/02/2015 02:00:27 - current media 0081L5 complete, requesting next media Any
07/02/2015 02:00:31 - Waiting for scan drive stop IBM.ULT3580-TD6.000, Media server: LBPDWP
07/02/2015 02:00:32 - Info bptm (pid=2494532) Waiting for mount of media id 0126L5 (copy 1) on server LBPDWP.
07/02/2015 02:00:32 - granted resource 0126L5
07/02/2015 02:00:32 - granted resource IBM.ULT3580-TD6.000
07/02/2015 02:00:32 - granted resource LBPDWP-hcart3-robot-tld-4
07/02/2015 02:00:32 - end writing
07/02/2015 02:00:32 - mounting 0126L5
07/02/2015 02:01:11 - Info bptm (pid=2494532) media id 0126L5 mounted on drive index 7, drivepath /dev/rmt4.1, drivename IBM.ULT3580-TD6.000, copy 1
07/02/2015 02:01:11 - mounted 0126L5; mount time: 0:00:39
07/02/2015 02:01:11 - positioning 0126L5 to file 15
07/02/2015 02:02:45 - positioned 0126L5; position time: 0:01:34
07/02/2015 02:02:45 - begin writing
07/02/2015 02:02:51 - Info bphdb (pid=2420850) dbclient(pid=2420850) wrote first buffer(size=262144)
07/02/2015 02:03:03 - Info bphdb (pid=2420850) dbclient waited 465 times for empty buffer, delayed 465 times
07/02/2015 02:03:03 - Info bphdb (pid=2420850) done. status: 6
07/02/2015 02:03:05 - Error bptm (pid=2494532) media manager terminated by parent process
07/02/2015 02:03:16 - Info bphdb (pid=2420850) done. status: 6: the backup failed to back up the requested files
07/02/2015 02:03:16 - end writing; write time: 0:00:31
the backup failed to back up the requested files (6)=
07-02-2015 08:07 PM
Hi
Detailed status dont have more details about this problem. Can you provide bphdb, bpbrm...etc
07-02-2015 08:30 PM
Base on the detailed status
it is getting diffrent tape medias then exited with status 6.
07-03-2015 12:22 PM
I saw this messages above:
7/02/2015 02:00:27 - Error bptm (pid=2494532) error requesting media, TpErrno = Robot operation failed
07/02/2015 02:00:27 - Warning bptm (pid=2494532) media id 0081L5 load operation reported an error
07/02/2015 02:00:27 - current media 0081L5 complete, requesting next media Any
Did you check if have something wrong with your tape library that prevent operation of mounting or unmounting tapes. Please check windows event log, logs of your tape library.
07-23-2015 02:19 AM
No reply in more than 2 weeks?
Was this a once-off error or are backups for this client failing all the time?
For Status 6 first troubleshooting must be done on the Oracle client.
The 1st step is to check rman output file.
Next step is to check logs on the client: bphdb and dbclient.
If these folders do not exist, create them and chmod 777.
If you need assistance with reading logs, please copy them to .txt files (e.g. dbclient.txt) and upload as File attachments.