10-11-2017 12:40 AM
Hi Team,
My SQL Backup getting failed with error code : the backup failed to back up the requested files (6), some child backup getting success but some getting failed with above error.
Master Server Name:- pbad-netbackup.pbad.sbg.com.sa
Netbackup Version: 7.6.1.1
Operating System:- Windows 2008 R2 64 Bit
Client Name : pbad-spointsql.pbad.sbg.com.sa
Client Version: 7.6.1.1
Client Opertating System:Windows 2008 R2 64 Bit (Virtual Server)
Job Details:
10/11/2017 10:30:57 AM - Info nbjm(pid=7160) starting backup job (jobid=1267710) for client pbad-spointsql.pbad.sbg.com.sa, policy New-pbad-spointsql_DB_Full_Backup, schedule Default-Application-Backup
10/11/2017 10:30:57 AM - Info nbjm(pid=7160) requesting STANDARD_RESOURCE resources from RB for backup job (jobid=1267710, request id:{BDBB429F-0E1F-4ACF-94AD-0FBAB915FF28})
10/11/2017 10:30:57 AM - requesting resource Netbackup_MSDP_DiskPool_STU
10/11/2017 10:30:57 AM - requesting resource pbad-netbackup.pbad.sbg.com.sa.NBU_CLIENT.MAXJOBS.pbad-spointsql.pbad.sbg.com.sa
10/11/2017 10:30:57 AM - requesting resource pbad-netbackup.pbad.sbg.com.sa.NBU_POLICY.MAXJOBS.New-pbad-spointsql_DB_Full_Backup
10/11/2017 10:30:57 AM - granted resource pbad-netbackup.pbad.sbg.com.sa.NBU_CLIENT.MAXJOBS.pbad-spointsql.pbad.sbg.com.sa
10/11/2017 10:30:57 AM - granted resource pbad-netbackup.pbad.sbg.com.sa.NBU_POLICY.MAXJOBS.New-pbad-spointsql_DB_Full_Backup
10/11/2017 10:30:57 AM - granted resource MediaID=@aaaaS;DiskVolume=PureDiskVolume;DiskPool=Netbackup_MSDP_DiskPool;Path=PureDiskVolume;StorageServer=pbad-netbackup.pbad.sbg.com.sa;MediaServer=pbad-netbackup.pbad.sbg.com.sa
10/11/2017 10:30:57 AM - granted resource Netbackup_MSDP_DiskPool_STU
10/11/2017 10:30:57 AM - estimated 0 Kbytes needed
10/11/2017 10:30:57 AM - Info nbjm(pid=7160) started backup (backupid=pbad-spointsql.pbad.sbg.com.sa_1507707057) job for client pbad-spointsql.pbad.sbg.com.sa, policy New-pbad-spointsql_DB_Full_Backup, schedule Default-Application-Backup on storage unit Netbackup_MSDP_DiskPool_STU
10/11/2017 10:30:57 AM - started process bpbrm (4976)
10/11/2017 10:30:59 AM - Info bpbrm(pid=4976) pbad-spointsql.pbad.sbg.com.sa is the host to backup data from
10/11/2017 10:30:59 AM - Info bpbrm(pid=4976) reading file list for client
10/11/2017 10:30:59 AM - connecting
10/11/2017 10:31:01 AM - Info bpbrm(pid=4976) listening for client connection
10/11/2017 10:31:08 AM - Info bpbrm(pid=4976) INF - Client read timeout = 1800
10/11/2017 10:31:08 AM - Info bpbrm(pid=4976) accepted connection from client
10/11/2017 10:31:08 AM - Info dbclient(pid=7316) Backup started
10/11/2017 10:31:08 AM - Info bptm(pid=11976) start
10/11/2017 10:31:08 AM - Info bptm(pid=11976) using 524288 data buffer size
10/11/2017 10:31:08 AM - connected; connect time: 0:00:09
10/11/2017 10:31:11 AM - Info bptm(pid=11976) setting receive network buffer to 2098176 bytes
10/11/2017 10:31:11 AM - Info bptm(pid=11976) using 128 data buffers
10/11/2017 10:31:11 AM - Info bptm(pid=11976) start backup
10/11/2017 10:31:13 AM - Info bptm(pid=11976) backup child process is pid 9112.2296
10/11/2017 10:31:13 AM - Info bptm(pid=9112) start
10/11/2017 10:31:13 AM - begin writing
10/11/2017 10:31:14 AM - Info dbclient(pid=7316) dbclient(pid=7316) wrote first buffer(size=65536)
10/11/2017 10:31:16 AM - Info dbclient(pid=7316) done. status: 6
10/11/2017 10:31:20 AM - Info pbad-netbackup.pbad.sbg.com.sa(pid=11976) StorageServer=PureDisk:pbad-netbackup.pbad.sbg.com.sa; Report=PDDO Stats for (pbad-netbackup.pbad.sbg.com.sa): scanned: 3 KB, CR sent: 0 KB, CR sent over FC: 0 KB, dedup: 100.0%, cache disabled
10/11/2017 10:31:20 AM - Info dbclient(pid=7316) done. status: 6: the backup failed to back up the requested files
10/11/2017 10:31:20 AM - end writing; write time: 0:00:07
the backup failed to back up the requested files (6)
please provide the solution for the above issue.
10-11-2017 01:29 AM
Is there a reason for still running 7.6.x.x - And not upgrade?
10-11-2017 02:21 AM - edited 10-11-2017 02:22 AM
@Evenas we are not upgrade becoz of our license expired.
10-11-2017 05:26 AM
Hi @mrauf,
Please send us dbclient / bphdb logs from directory below.
<install path>/Program Files/Veritas/NetBackup/logs
Thiago
10-11-2017 05:50 AM
Please provide backup selection list details - along with the script body itself...
If this is NBU initiated backup... if not script you are using to backup it...
connectivity with bpcltncmd was tested?
10-11-2017 11:09 PM
you also need to have a check from the sql side. most of the time the problem comes from client side.
11-02-2017 07:57 AM
Hey Can you get the below information
--get the job details from SQL console as 6 is generic error message and it won't give us any clear idea
--as it is hitting the master server it won't be having the communication we have to look at bphdb,dbclient
--Also another thing is is file list was successfully generated ? get the bch file that is used for the backup as well