Re: Implementing Continuous Managed Recovery on a Standby Database

On Friday 06 December 2002 18:29, Orr, Steve wrote: [...]
> 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
> --------------------------------------------------------------
[...]
>
> So with a little help from a *nix geek I did this...
> --------------------------------------------------------------
> sqlplus "/ as sysdba" @managed_recov.sql </dev/null &>standby.log &
> --------------------------------------------------------------
[...]
> 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?
>

Hi,

try it wiht screen, a nice tool, that gives you something like another terminal. An example:
$screen
sqlplus "/ as sysdba"
$sql>RECOVER MANAGED STANDBY DATABASE;

So, now you say CTRL-a and CTRL-d and you are back in your first session. now you can work on without any worry.
If you want to come back, you say:
$screen -r

as the same user, you start the screen. Thats it.

Hope it helps

by
Joerg
>
> Whining in Bozeman, Montana
> Steve Orr

-- 
-----------------------------------------------------------------
Software Engineering
Vattmannstraße 7, 33100 Paderborn
Phone: (+49) 52 51 / 30 1 6333
Fax: (+49) 52 51 / 30 16 399
eMail: jost_at_unitrade.com
http://www.unitrade.com
------------------------------------------------------------------

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