RE: Correct method of auto starting standby db

I *really* hope this isnt one of those dumb question (due to the limited responses)
Or maybe Ive stumped our contestents today.... <vb grin> ;->

Here is what I have based on Tanels suggestion

--C:\oracle\ora817R3\bin\svrmgrl.exe
command='@C:\oracle\admin\LOC\ADHOC\startstandby.

[startstandby.sql]
Sqlplus /nolog;
Connect sys/***@LOC as sysdba;
Startup nomount pfile=C:\oracle\admin\LOC\PFILE\initLOC.ora; Alter database mount standby database;
Recover managed standby database disconnect;  

@ -> Recover managed standby database disconnect; ORA-00274: illegal recovery option DISCONNECT

http://www.ss64.com/ora/recover.html

I will try to poke around on metalink

Thanks!
bob  

> Hi!
>
> Try:
>
> recover managed standby database disconnect;
>
> This should spawn a separate process for recovering.
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, July 31, 2003 5:54 PM
>
>
> > All,
> > I have a question of how to auto start a standby database. IOW, it
> > seems the logs are only applies if I issue the command
> Recover managed
> > standby database;
> >
> > With thatcommand, the logs are applied, however, if I (or someone
> > else) exits the cmd window the process stops
> >
> > So, how can I set this up to be automated?
> >
> > I need to keep the database in this state.... (I must be missing the
> > obivious)
> >
> > Sqlplus /nolog
> > Connect sys/*** as sysdba
> > Startup mount;
> > Alter databse mount standby database;
> >
> > Recover managed standby database;
> >
> > I used this doc as a base for my initSID.ora files and
> dosnt seem to
> > mention the starting up on the db
> > http://www.oracle-base.com/Articles/8i/StandbyDatabase.asp
> >
> > Thanks!
> > bob
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Bob Metelsky
> > INET: bmetelsky_at_cps92.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from). You may
> also send
> > the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tanel Poder
> INET: tanel.poder.003_at_mail.ee
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).