upgrade to 9...
SQL> recover ... disconnect
hth
connor
- "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).
>
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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 Sat Dec 07 2002 - 08:13:39 CST