RECOVER AUTOMATIC STANDBY DATABASE; Script question

From: ITAPORT06 <mokat67_at_hotmail.com>
Date: Mon, 23 Feb 2004 00:05:41 +0100
Message-ID: <ubbi301rq24fuc8jnt7e3qulnj7av19hdn@4ax.com>

WIN NT Oracle 8i

I want to create a script BAT file (Win environment) in which the standby database starts-up

Before setting the standby database into " Managed " mode, I must in my case first execute rst the " Recovery automatic standby database "

This because manually shipped loggings have to be applied first by the automatic command

My problem is that I want to excute this in a scipt unattend BUT: " Recovery automatic standby database " command is always waiting for an " CANCEL " reply after the last succesfull applied log file.

Who can tell me how I can give the " CANCEL" unattended in a scipt so that I can schedule the script?

Thanks

startup NOMOUNT pfile=C:\Oracle\ORA81\admin\pfile\init.ORA

ALTER DATABASE MOUNT STANDBY DATABASE; RECOVER AUTOMATIC STANDBY DATABASE; (Here I need the cancel)

RECOVER MANAGED STANDBY DATABASE; Received on Sun Feb 22 2004 - 17:05:41 CST