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