NTidiot question - Scheduling RMAN jobs

[stmontgo]

Hi there,
I have three db's to backup with rman (Oracle 92) to disk.

I have a script for each db that works on it's own. Problem is, when I try and call all 3 only the first one runs.

Here's what I am attempting


rman TARGET sys/pass@orlhr2 CATALOG rman/cat@pass @c:\oracle\scripts\rman\full_orlhr_db_bkp.rcv log=c:\oracle\scripts\rman\logs\full_orlhr_db_bkp.log

run
{
backup database include current controlfile
format 'F:\oracle\backups\%d_%U';
backup format 'F:\oracle\backups\%d_log_t%t_s%s_p%p'
(archivelog all delete input);
}


Now I have two other backups that are identical to the above.

I tried to create a bat file like so

C:\oracle\scripts\rman\full_orlhr_db_bkp.bat
C:\oracle\scripts\rman\full_prdprta_db_bkp.bat
C:\oracle\scripts\rman\full_prdprtb_db_bkp.bat

However only the first one get's executed

any ideas?

tks

steve

[TomazZ]

This is expected behaviour of NT.

You have to CALL subscripts from a script if you want them to return control to the main script.

Like:
CALL C:\oracle\scripts\rman\full_orlhr_db_bkp.bat
CALL C:\oracle\scripts\rman\full_prdprta_db_bkp.bat
CALL C:\oracle\scripts\rman\full_prdprtb_db_bkp.bat

[stmontgo]

you rock, tks for the fast response . case closed!

steve

[marist89]

Another reason why I love unix.

[stmontgo]

me to, believe me, this is not my platform of choice

[stecal]

You know, the word reboot has only come up once in my W2K Professional class. I think Windows people are in denial.

[slimdave]

... and just to escalate the intensity of the debate, let me add that "Windows Professional" is an oxymoron.

[TomazZ]

Somehow I've got the feeling I have to explain myself...
All my databases are on Solaris...


But... you have to know your enemy, right?