Standby Database on NT4 (automating recovery)

Hello!

    I'm in need of a solution to a simple(???) problem.  I'm implementing a "Standby database" system (Oracle7.3.3 on NT4/Intel), and I need a way to automate the recovery process of the standby database.

I can get the log files over to the standby machine and fire off the recovery ok, but when the Standby Database finishes recovering all available logfiles, it says it cant find the next file (True, 'cos it's not there!), then prompts you for what to do next (CANCEL, AUTO, Accept the given default file name, enter another filename).

The backup& recovery handbook (Mcgrawhill's one) is very good- but the examples are UNIX based:
svrmgrl <<EOF
connect internal/oracle
recover standby database
cancel
EOF This is great if you've got a unix server, but no good for "DOS" based servers. I just need a way to issue the "cnacel" command!!

Someone out there's made this work!!!! (surely??)

Any help greatly appreciated.

Please mail possable solutions to wparsons_at_welcom.co.uk

From Will Received on Wed Jul 29 1998 - 03:00:50 CDT