Re: RECOVER AUTOMATIC STANDBY DATABASE; Script question

My log application sql script looks like this

set echo on
connect /@<tnsnames entry> as sysdba
spool c:\scripts\logapply.log
alter database recover automatic standby database until cancel; alter database recover cancel;
spool off
exit

This is a manual standby but you get the idea

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"ITAPORT06" <mokat67_at_hotmail.com> wrote in message
news:ubbi301rq24fuc8jnt7e3qulnj7av19hdn_at_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;