Ok It looks like the disconnect is for 9i >From metalink " This recover command must be ended from a different session with "recover managed standby database cancel". There is a timeout=n option to the recovery command which will cause recovery to end if a new archive log is not received in n minutes. For example, "recover managed standby database timeout=10" will start the recovery command, but if there is a 10 minute wait between the arrival of any two archive logs, the command will end.
You can execute the recover command in the background using the AT command with just a one time execution. For example if it's 8:00 AM use: at 8:05 "sqlplus @file.sql". If you need further assistance with this, please post a new thread in the Microsoft Server & Utilities forum. Oracle9i provides a 'disconnect' option when placing a database in managed recovery. This allows for managed recovery to run in the background. " Looks like I have to schedule a job to run every hour with a time out of "n" min.... Thanks Bob > All, > I have a question of how to auto start a standby > database. IOW, it seems the logs are only applies if I issue > the command Recover managed standby database; > > With thatcommand, the logs are applied, however, if I (or > someone else) exits the cmd window the process stops > > So, how can I set this up to be automated? > > I need to keep the database in this state.... (I must be missing the > obivious) > > Sqlplus /nolog > Connect sys/*** as sysdba > Startup mount; > Alter databse mount standby database; > > Recover managed standby database; > > I used this doc as a base for my initSID.ora files and dosnt > seem to mention the starting up on the db > http://www.oracle-> base.com/Articles/8i/StandbyDatabase.asp > > > Thanks! > bob > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bob Metelsky > 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.net -- Author: Bob Metelsky 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).
