RE: Correct method of auto starting standby db

Ok It looks like the disconnect is for 9i

>From metalink

"
This recover command must be ended from a different session with "recover managed standby database cancel". There is a timeout=n option to the recovery command which will cause recovery to end if a new archive log is not received in n minutes. For example, "recover managed standby database timeout=10" will start the recovery command, but if there is a 10 minute wait between the arrival of any two archive logs, the command will end.

You can execute the recover command in the background using the AT command with just a one time execution. For example if it's 8:00 AM use: at 8:05 "sqlplus @file.sql". If you need further assistance with this, please post a new thread in the Microsoft Server & Utilities forum.

Oracle9i provides a 'disconnect' option when placing a database in managed recovery. This allows for managed recovery to run in the background.
"

Looks like I have to schedule a job to run every hour with a time out of "n" min....

Thanks
Bob

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