I just started the databases up in the background. Patrol keeps track of the databases but we have never had a problem doing this. Had to write a custom dbstart script though. Works fine but is unsupported by Oracle.
--- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > 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). > ===== Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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).
