12-04-2012 04:46 AM
User initiated SQL backups are failing with 230 though the policy and schedule are in place. the client name is getting recognised as A=a, policy= NULL.
Please could someone let us know where do we look and which logs do we refer. There is nothing on the detailed job screen to refer.
:(
Our env details are as follows:
NB master svr: LINUX 5.1
Client: win svr 2008
Thanks,
Anish
Solved! Go to Solution.
01-08-2013 05:08 AM
12-04-2012 05:16 AM
How is user backup started? By kicking of script from client or just selecting db's and running the backup?
We need to determine if SQLHOST is defined when sending request to master server.
dbclient log on the client as well as bprd log on the master server will contain this info.
If you are not using a script that defines SQLHOST and POLICY, Master needs to resolve client's IP address to hostname, then looks for the resolved hostname in appropriate policy.
12-04-2012 05:27 AM
Hi Marriane,
The backup is fired by a script.
We are trying to gain accessto the client for the dbclient log. We would also check the bprd log in master.
To check the name resolution shoudl we use the command bpclntcmd please?
12-04-2012 05:31 AM
Start by checking the script.
Look for :
SQLHOST
POLICY
This must be the same as in the policy on the master server.
12-04-2012 06:59 AM
Hi Marianne,
Any ideas please about the standard name of the script.
Thanks,
Anish
12-04-2012 07:14 AM
12-04-2012 07:34 AM
I am more intrested to see the bch file which triggers the job..
FYI..
Policy Names are case sensitive,
12-04-2012 10:00 PM
Hi Nagalla, Marianne,
I will be giving an extensive search for the bch file. One information I would like to share here is that the failure is occurring while the backup is trying to copy the flat files to tape, the databse copy to E:/SQLBK2FS is ok.
Please let me know if that changes our observation please?
Thanks for all your help,
Anish
12-04-2012 10:45 PM
12-05-2012 12:07 AM
Hi Marianne,
yes please you are right. I just asked them to provide me the command / script they use to initiate the backup to tape and this is the response:
The below command is used to fire the backup to tape process:
[c:\progra~1\veritas\netbackup\bin\bpbackup -s DailySQL -L "E:\SQLBK2FSLOGS\TapeBackup_Server01_20121204_145810.txt" -w "E:\SQLBK2FS\Server01"]
I went to the help list of bpbackup and found the following:
bpbackup [-p policy] [-s schedule] [-k "keyword phrase"]
[-L progress_log [-en]] [-S master_server...]
[-t policy_type] [-w [hh:mm:ss]]
Does it need the "-p" POLICY switch adding please? is that mandatory?
Thanks,
Anish
12-05-2012 12:45 AM
-p <Policy> will certainly help, otherwise the first policy with 'DailySQL' schedule will be used.
Confirm that DailySQL is a User-Backup type schedule with open window when script will call bpbackup.
Next, confirm NBU 'Configured Client' name.
Use Client BAR GUI: File -> Properties -> Client Name.
Ensure the name in this field corresponds with the Client name in the policy.
12-05-2012 03:06 AM
Hi Marianne,
We just checked the host file of one of the client and found that the backup IP entered there and the one being used for backup are different.
We have rectified the same and asked DBA to reinitiate the job once more to check.
Rest settings as advised by you looks ok.
I will let you know the results.
Thanks,
Anish
12-05-2012 04:03 AM
Please ensure that bprd log folder exists on the master server. If not, create folder and restart NBU Request Service.
This will help to troubleshoot connection from client.
bprd log will show Connection received from client's IP address and how master is resolving IP to hostname.
12-05-2012 04:15 AM
Hi,
Unfortunately the host file setting change did not help. :(
Anything else we can check please?
Thanks,
Anish
12-05-2012 11:18 AM
Check bprd log on the master as per my previous post.
01-08-2013 05:08 AM