Re: Correct method of auto starting standby db

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).