Re: Standby Database on NT4 (automating recovery)

You need to execute the following command before you issue the "Recover Standby Database" command:

set autorecovery on

This will recover the standby database, and automatically apply the existing archive logs, once it does not find the next archive log, it will give an error and exit out of recovery mode. I've tested this a million times and it works, in a development and production environments..

test wrote:

> 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 - 12:15:51 CDT