bpend in windows netbackup 6.5 is not executing a script inside

Linda Duarte's picture

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"

Dimitris Peppas's picture

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.

BR,
DP
Linda Duarte's picture

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

J.Hinchcliffe's picture

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.

CRZ's picture

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?

 

J.Hinchcliffe's picture

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.

wrobbins's picture

@Linda

how about calling hot_end.bat at the end of your RMAN script?

 

Yasuhisa Itoh's picture

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
-----

Linda Duarte's picture

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.

Yasuhisa Itoh's picture

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
-----

wrobbins's picture

you may have a bigger problem

"the requested operation was partially successful"
Have you checked whether your backups can be successfully restored?