Koen,
Maybe you shuold specify where the script (bkdbppim.scr) resides. In the RMAN
command you only specify the name of the script not the path. Perhaps it is
better to precede the command with a pushd %ora_script_dir% and follow the RMAN
with a popd like this
pushd %ora_script_dir%
%ora_exe% target system/manager@ppim rcvcat rman_db1/rman_db1@orcl cmdfile
bkdbppim.scr msglog bkdbppim.log
popd
Greetings,
M Engels
Koen Willems <[EMAIL PROTECTED]> on 21/11/2002 16:01:42
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Michel Engels/BE/Devoteam)
Subject: Re: scheduler fails on tdp command scripts (still drives me nuts )
Del,
You are right echo comes with output c:\test.txt
So how whats wrong with my script ?
I still get a return code 3
orcschedppim.cmd
rem ==================================================
rem orcsched.cmd
rem ==================================================
rem ==================================================
rem set rman executable
rem ==================================================
set ora_exe=d:\oracle\ora81\bin\rman
rem ==================================================
rem set script and log directory
rem ==================================================
rem set ora_script_dir=d:\oracle\scripts\
set ora_script_dir=c:\progra~1\tivoli\tsm\agentoba\
rem ==================================================
rem run the backup script
rem ==================================================
%ora_exe% target system/manager@ppim rcvcat rman_db1/rman_db1@orcl cmdfile
bkdbppim.scr msglog bkdbppim.log
bkdbppim.scr
run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\Progra~1\Tivoli\TSM\AgentOBA\tdpoppim.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\Progra~1\Tivoli\TSM\AgentOBA\tdpoppim.opt)';
backup
filesperset 5
format 'df_%t_%s_%p'
(database);
release channel t1;
release channel t2;
}
Best Regards,
Koen Willems
>From: Del Hoobler <[EMAIL PROTECTED]>
>Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: scheduler fails on tdp command scripts (still drives me nuts
>)
>Date: Thu, 21 Nov 2002 09:01:38 -0500
>
>Koen,
>
>How do you *know* the script isn't running?
>From the schedule log... it appears that it is.
>And something within the script is failing
>and reflecting the RC=3.
>Add some
> echo Doing xxxxx >> C:\TEMP\SCRIPT.OUT
>statements to your script to find out for sure
>if it is running and where it might be failing.
>(Change "xxxx" to be what the script is doing at
>the time.)
>
>Thanks,
>
>Del
>
>----------------------------------------------------
>
>Del Hoobler
>IBM Corporation
>[EMAIL PROTECTED]
>
>- Never cut what can be untied.
>- Commit yourself to constant improvement.
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
