cancel
Showing results for 
Search instead for 
Did you mean: 

SQL/ Oracle Application backup streams are failing with error code 6 while writing on VTL

Hi All,

Some of our SQL/ Oracle Application backup streams are failing with error code 6 while writing on VTL. However when changing it to use same DataDomain as DDBoost disk, its woring fine.

Master Server : 7.6.0.1
Master Server OS : Win 2K8 R2

Error:

4/29/2016 7:30:51 PM - Error bptm(pid=8268) error requesting media, TpErrno = File name already exists   
4/29/2016 7:30:51 PM - Warning bptm(pid=8268) media id D06674 load operation reported an error    
4/29/2016 7:30:51 PM - current media D06674 complete, requesting next resource Any

I have seen this error with physical tape drives when needs cleaning or with bad media with error code 84 , but since the library is virtual should not be any cleaning issue. Any suggestion please....


Detailed Log:
4/29/2016 7:30:22 PM - requesting resource usflbua0.NBU_POLICY.MAXJOBS.SQL_DBB4_ALL02
4/29/2016 7:30:22 PM - awaiting resource mediaserver2-hcart-robot-tld-2 - No drives are available
4/29/2016 7:30:32 PM - granted resource usflbua0.NBU_CLIENT.MAXJOBS.CLIENT1
4/29/2016 7:30:32 PM - granted resource usflbua0.NBU_POLICY.MAXJOBS.SQL_DBB4_ALL02
4/29/2016 7:30:32 PM - granted resource D06674
4/29/2016 7:30:32 PM - granted resource ULTRIUM-TD1.300059001D
4/29/2016 7:30:32 PM - granted resource mediaserver2-hcart-robot-tld-2
4/29/2016 7:30:33 PM - estimated 0 Kbytes needed
4/29/2016 7:30:33 PM - Info nbjm(pid=5224) started backup (backupid=CLIENT1_1461972633) job for client CLIENT1, policy SQL_DBB4_ALL02, schedule Default-Application-Backup on storage unit mediaserver2-hcart-robot-tld-2
4/29/2016 7:30:35 PM - started process bpbrm (9232)
4/29/2016 7:30:37 PM - Info bpbrm(pid=9232) CLIENT1 is the host to backup data from    
4/29/2016 7:30:37 PM - Info bpbrm(pid=9232) reading file list for client       
4/29/2016 7:30:37 PM - connecting
4/29/2016 7:30:39 PM - Info bpbrm(pid=9232) listening for client connection        
4/29/2016 7:30:46 PM - Info bpbrm(pid=9232) INF - Client read timeout = 3600     
4/29/2016 7:30:46 PM - Info bpbrm(pid=9232) accepted connection from client        
4/29/2016 7:30:46 PM - connected; connect time: 0:00:09
4/29/2016 7:30:47 PM - Info dbclient(pid=15876) Backup started          
4/29/2016 7:30:47 PM - Info bptm(pid=8268) start           
4/29/2016 7:30:47 PM - Info bptm(pid=8268) using 262144 data buffer size       
4/29/2016 7:30:49 PM - Info bptm(pid=8268) using 64 data buffers        
4/29/2016 7:30:50 PM - Info bptm(pid=8268) start backup          
4/29/2016 7:30:50 PM - Info bptm(pid=8268) backup child process is pid 9300.9592      
4/29/2016 7:30:50 PM - Info bptm(pid=8268) Waiting for mount of media id D06674 (copy 1) on server mediaserver2.
4/29/2016 7:30:50 PM - Info bptm(pid=9300) start           
4/29/2016 7:30:50 PM - mounting D06674
4/29/2016 7:30:51 PM - Error bptm(pid=8268) error requesting media, TpErrno = File name already exists   
4/29/2016 7:30:51 PM - Warning bptm(pid=8268) media id D06674 load operation reported an error    
4/29/2016 7:30:51 PM - current media D06674 complete, requesting next resource Any
4/29/2016 7:51:11 PM - Info bptm(pid=8268) Waiting for mount of media id D06674 (copy 1) on server mediaserver2.
4/29/2016 7:51:11 PM - granted resource D06674
4/29/2016 7:51:11 PM - granted resource ULTRIUM-TD1.3000590027
4/29/2016 7:51:11 PM - granted resource mediaserver2-hcart-robot-tld-2
4/29/2016 7:51:11 PM - mounting D06674
4/29/2016 7:51:18 PM - Info bptm(pid=8268) media id D06674 mounted on drive index 6, drivepath {3,0,10,14}, drivename ULTRIUM-TD1.3000590027, copy 1

4/29/2016 7:51:18 PM - mounted; mount time: 0:00:07
4/29/2016 7:51:21 PM - positioning D06674 to file 17
4/29/2016 7:51:21 PM - positioned D06674; position time: 0:00:00
4/29/2016 7:51:21 PM - begin writing
4/29/2016 8:06:23 PM - Info dbclient(pid=15876) done. status: 6         
4/29/2016 8:06:23 PM - Info dbclient(pid=15876) done. status: 6: the backup failed to back up the requested files
4/29/2016 8:06:23 PM - end writing; write time: 0:15:02
the backup failed to back up the requested files(6)

Thanks,
Tanmoy

1 Reply

Re: SQL/ Oracle Application backup streams are failing with error code 6 while writing on VTL

Stop NBU -  check in

netbackup/db/media/tpreq

Are there any files, if yes, delete them.

Check there are no outstanding reservation:

nbrbutil -dump (Look in MDS section at bottom of output).