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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
