Oracle 8i does not allow the disconnect option.
I have successfully put the startup commands into a
shell script that gets run in the background from
dbstart. This is not approved or recommended by
Oracle but it does work.
For 9i, of course, you have the disconnect option.
- Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
> 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).
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter Barnett
INET: regdba_at_yahoo.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 Mon Aug 04 2003 - 10:14:29 CDT
