bpend in windows netbackup 6.5 is not executing a script inside
The bpend is not executing the hot_end.bat script, do you know if the "start" command can be executed inside this script? or how to do it?
set newDate=%date:~4,2%-%date:~7,2%-%date:~10%
set arg=TEST
start C:\oracle\Dba\scripts\TEST\hot_backup_scripts\hot_end.bat
type "c:\oracle\Dba\logs\TEST\hot_backup_logs\%arg%.%newDate%.log" >> "c:\oracle\Dba\logs\historial\historial_test_hotbackup.log"
do you want the hot_end.bat
do you want the hot_end.bat to run and then continue? If so, use call instead of start.
DP
Hi and thank you for the
Hi Dimitris Peppas, and thank you for the support.
I changed the script to your suggeestion, but it still does'nt work.
cd C:\oracle\Dba\scripts\TEST\hot_backup_scripts\
call hot_end.cmd
does it even get called?
if you have a bpend_notify script youwill get a bpend called file and a return code inside the file.
check and see if the bpend called file is even getting created.
( I know some jobs do NOT use them at all - like a hot catalog backup will not use a bpend file.)
I don't have to know how to spell....I work on Unix.
bpend_notify isn't called during Oracle jobs
bpend_notify only runs at the end of a bpbkar - no bpbkar runs during database agent jobs, so no bpend_notify gets executed.
Perhaps we're misunderstanding your question?
you might be able to work around that
CRZ, does the parent_end get called at the end of an Oracle job?
Linda, I had to work around the same issue. I wanted a bpend when my Hot Catalogs finished, but it does not get called.
So I had to use the Parent_end_notify script and put in logic with if statements that if it was the Hot_Catalog policy and the daily schedule then do my stuff.
I don't have to know how to spell....I work on Unix.
@Linda
how about calling hot_end.bat at the end of your RMAN script?
bpend_notify executed?
For the begining, have you ever checked wheter bpend_notify itself was executed?
If not, check it by inserting some logging lines before the start(or call) line, like below.
-----
echo "%DATE% %TIME% " >> C:\bpend_notify.log
start C:\oracle\Dba\scripts\TEST\hot_backup_scripts\hot_end.bat
-----
Here are the feedback for all
Here are the feedback for all of you and hope you can get other ideas. net stop and net start <service name> functions but no call or start to batch files or command file names.
J.Hinchcliffe thank you - The bpend I think is called because the backup is done - see the log:
14:34:17 INF - Server status = 1
14:34:18 INF - Backup by oracle on client primadb using policy Windows-Servers-dbs, sched PMDBTEST:the requested operation was partially successful
And also the retuning "path" in the command prompt: C:\Program Files\Veritas\NetBackup\bin>
CRZ: thank you for your Update: The starting of the backup starts when after all tablespaces are in hot backup mode and called by C:\oracle\Dba\scripts\TEST\hot_backup_scripts\COLD_BACKUP.bat
COLD_BACKUP.bat has this inside:
set newDate=%date:~4,2%-%date:~7,2%-%date:~10%
set arg=TEST
C:
cd C:\Program Files\Veritas\NetBackup\bin
start bpbackup -p Windows-Servers-dbs -s %arg% -L c:\oracle\Dba\logs\TEST\hot_backup_logs\%arg%.%newDate%.log -f c:\oracle\Dba\lists\%arg%list.txt
wrobbins - thak you but no Rman plug in used, this is a simple hotbackup - put all tablespace in hot backup mode - transfer this to Veritas then it is supposed to vall the hot_end_backup which is not doing.
Yasuhisa Itoh - Thank you - I did what you instructed but no success.
In other databases I can do net stop <service name> or net start service name but no start to a bathc file or command file name or call bathc file or call command file name.
bpstart_notify works on my client
I wrote bpstart_notify.bat as below, that works fine on my 6.5.4 client. bpstart_notify is called with same priviledge with NetBackup Client Service(SYSTEM, by default).
-----
@echo off
echo %DATE% %TIME% %CMDCMDLINE% >> C:\TEST\TEST.log
whoami >> C:\TEST\TEST.log
-----
To avoid spending time for troubleshooting, how about to rewrite your COLD_BACKUP.bat as follows:
hot_backup.bat will be called after sompletion of user backup.
-----
set newDate=%date:~4,2%-%date:~7,2%-%date:~10%
set arg=TEST
C:
cd C:\Program Files\Veritas\NetBackup\bin
bpbackup -w -p Windows-Servers-dbs -s %arg% -L c:\oracle\Dba\logs\TEST\hot_backup_logs\%arg%.%newDate%.log -f c:\oracle\Dba\lists\%arg%list.txt
C:\oracle\Dba\scripts\TEST\hot_backup_scripts\hot_end.bat
-----
you may have a bigger problem
"the requested operation was partially successful"
Have you checked whether your backups can be successfully restored?
Would you like to reply?
Login or Register to post your comment.