Implementing Continuous Managed Recovery on a Standby Database

From: Orr, Steve <sorr_at_rightnow.com>
Date: Fri, 06 Dec 2002 09:29:08 -0800
Message-ID: <F001.005149A8.20021206092908@fatcity.com>

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).

Received on Fri Dec 06 2002 - 11:29:08 CST