I just started the databases up in the background.
Patrol keeps track of the databases but we have never
had a problem doing this. Had to write a custom
dbstart script though. Works fine but is unsupported
by Oracle.
- "Orr, Steve" <sorr_at_rightnow.com> wrote:
> Problem: How to keep a standby database in
> continuous managed recovery
> without having to maintain an open terminal session.
> (Version 8.1.7.2)
>
> When you execute the following...
>
>
> SQL> RECOVER MANAGED STANDBY DATABASE;
>
>
> ...SQL*Plus does not return a prompt and the
> database is in continuous
> recovery BUT... as soon as you exit the session,
> recovery discontiues and
> the logs are nolonger automagically applied. "No
> problem," I said, "I'll
> just wrap it in a shell script and launch it in the
> background." Doesn't
> work and it appears SQL*Plus is a misbehaving
> process. (Linux)
>
> So then I tried nohup:
>
>
> $ nohup sqlplus "/ as sysdba" @managed_recov.sql &
> [1] 23412
> $ nohup: appending output to 'nohup.out'
> [1]+ Exit 127 nohup sqlplus "/ as sysdba"
> @managed_recov.sql
>
>
> The managed_recov.sql script contains this one line:
>
> RECOVER MANAGED STANDBY DATABASE;
> This works but it does not persist as a background
> process- it terminates
> when I hit enter or leave the terminal session. I
> think it terminates
> because SQL*Plus is misbehaving. What do you think?
>
> So with a little help from a *nix geek I did this...
>
>
> sqlplus "/ as sysdba" @managed_recov.sql </dev/null
> &>standby.log &
>
>
> ...presto chango, it works- standard I/O is OK and
> running in the
> background. The standby DB is in continuous recovery
> and I can shutdown my
> PC and go home and managed recovery just keeps on
> running. Cool.
>
> Is there a better way to do this? I submitted a TAR
> but OWS hasn't been any
> help. Doesn't it seem lame that Oracle gives the
> "RECOVER MANAGED STANDBY
> DATABASE" command but is unable to provide a means
> to implement it without
> requiring the terminal session to remain open?
>
>
> Whining in Bozeman, Montana
> Steve Orr
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Orr, Steve
> INET: sorr_at_rightnow.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).
>
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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 Fri Dec 06 2002 - 16:49:24 CST