RE: Implementing Continuous Managed Recovery on a Standby Databas

It's surprising you could do this since, as far as I know, if you start a background process in ksh then try to exit the shell, you get prompted that you have running jobs; if you type exit again, the jobs are killed.

Two things I do are:

Instead of running nohup directly, run
sh -c "/bin/nohup your_command &"

or

echo "command (including any redirects, if needed)" | at now

> -----Original Message-----
> From: Orr, Steve [mailto:sorr_at_rightnow.com]
> Sent: Friday, December 06, 2002 11:29 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Implementing Continuous Managed Recovery on a
> Standby Database
>
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: slee_at_dollar.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).