Correct method of auto starting standby db

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Thu, 31 Jul 2003 06:54:27 -0800
Message-ID: <F001.005C7FBD.20030731065427@fatcity.com>

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). Received on Thu Jul 31 2003 - 09:54:27 CDT