Lisa,
I have successfully captured the output of the following pre/post commands
when shutting down and restarting an Oracle database prior to running a
scheduled backup.
I am running a Windows NT Version 4.0 backup Server and TSM version 4.1.1.0
In the clients DSM.OPT file the following commands have been entered:
preschedulecmd "c:\oracle\admin\bat\shutdownoracle.cmd"
postschedulecmd "c:\oracle\admin\bat\startuporacle.cmd"
the following are the command files that redirects the shutdown and startup
to a text file:
shutdownoracle.cmd
set ORACLE_SID=XYDEV
set ORACLE_HOME=c:\oracle\ora81
c:\oracle\ora81\bin\svrmgrl.exe @c:\oracle\admin\sql\shutdown.sql > c:
\oracle\admin\bat\pre_cmd_results.txt
net stop oracleserviceBVDEV /y
startuporacle.cmd
set ORACLE_SID=XYDEV
set ORACLE_HOME=c:\oracle\ora81
net start oracleserviceBVDEV /y
c:\oracle\ora81\bin\svrmgrl.exe @c:\oracle\admin\sql\startup.sql > c:
\oracle\admin\bat\post_cmd_results.txt
Hope this helps!!
Regards
Russell Walsh
Professional Server Specialist, IBM GSA, Australia
Phone: +61 3 9627.0158 Desk
+61 3 9627.0340 Fax
0411.263.409 Mobile
Internet: [EMAIL PROTECTED]
Lisa Cabanas <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 06/03/2001
07:48:08
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: capture output from prescheduled command
I am trying to figure out how to capture the output of an ncompact.exe -B
command (a Domino server command that reassigns new DBIIDs to the compacted
databases) that is run as a prescheduled command in a special dsm_sel.opt.
The
scheduler picks up the schedule, and the selective TDP backup occurs, (and
says
it is using the c:\progra~1\tivoli\tsm\domino\dsm_sel.opt) but I can not
tell
whether the compact was successful.
I have tried putting the statement in the dsm_sel.opt file
preschedcommand d:\domino\ncompact.exe -B 10 >>
c:\progra~1\tivoli\tsm\domino\compact.log
with all sorts of variations of where the quotes are-- no out put.
I have also tried putting these commands into another command file that is
called by the prescheduled command, and no go on it, either.
Has anyone done this?
thanks!!
lisa
