I *really* hope this isnt one of those dumb question (due to the limited responses) Or maybe Ive stumped our contestents today.... <vb grin> ;->
Here is what I have based on Tanels suggestion --C:\oracle\ora817R3\bin\svrmgrl.exe command='@C:\oracle\admin\LOC\ADHOC\startstandby. [startstandby.sql] Sqlplus /nolog; Connect sys/[EMAIL PROTECTED] as sysdba; Startup nomount pfile=C:\oracle\admin\LOC\PFILE\initLOC.ora; Alter database mount standby database; Recover managed standby database disconnect; @ -> Recover managed standby database disconnect; ORA-00274: illegal recovery option DISCONNECT http://www.ss64.com/ora/recover.html I will try to poke around on metalink Thanks! bob > Hi! > > Try: > > recover managed standby database disconnect; > > This should spawn a separate process for recovering. > > Tanel. > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, July 31, 2003 5:54 PM > > > > 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: Tanel Poder > 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).
