RE: Anyone with Standby on 8.0.5, NT please give me hand.

Tim,

Thanks -- I've been overwhelmed lately and had not gotten back to Reza....my apologies, apparently my boss and his boss expect me to work at work, what a concept!

Rachel

>From: Tim Onions <tim.onions_at_speechmachines.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Anyone with Standby on 8.0.5, NT please give me hand.
>Date: Thu, 23 Nov 2000 01:00:24 -0800
>
>Reza
>
>Don't know if Rachel got back to you but here is the command I use for
>8.1.6
>standby recovery (std edition so can't use those lovely managed standby new
>features). The first line of recover.bat uses a 3rd party product's
>scripting language to retrieve the log files (ie is not relevant to the
>discussions here). In theory you can put recover.bat in the AT scheduler
>but
>I could not get that to work reliably so use a little home-grown VB
>scheduling program. Give the postings about other NT schedulers I'll
>probably drop my VB prog and go look at some of the freeware ones.
>
>File 1 (recover.bat)
>
>c:\nsm\runscrip c:\nsm\atldn3Copy.scp
>set oracle_sid=mysid
>sqlplus @sb.sql
>exit
>
>File 2 (sb.bat)
>
>sys/changed_on_install as sysdba
>Spool sb.log
>startup nomount;
>alter database mount standby database;
>recover automatic standby database;
>cancel
>shutdown
>spool off
>exit
>
>
>
>
>
>-----Original Message-----
>Sent: 22 November 2000 17:16
>To: Multiple recipients of list ORACLE-L
>
>
>
>Dear Rachel
>Thanks ever so much, for your kind help.
>Wish you all the best and success in your life.
>You know how ackward in NT compared to Unix good old scripting power.
>Continue my quest to resolve the issue.
>If you could remember or had a minute please send me the right syntax for
>the " RECOVER..... AUTOMATIC..." command. I canot find the exact syntax in
>oracle manuals.
>
>Best Regards
>Reza
>
> -----Original Message-----
>Sent: 22 November 2000 13:25
>To: Multiple recipients of list ORACLE-L
>
> Reza,
>
> What I did with 7.3.4 on Unix (but the concept should work for NT)
>was use
>the recover standby database command with the "AUTOMATIC" option (this is
>documented, although the syntax is wrong I believe, in Velpuri's first
>Backup and Recovery Handbook)
>
> What this does is automatically apply all the archive logs that
>exist... you
>will get an error in the alert log when it finishes and can't find the next
>log.
>
> So what I did was create a series of jobs:
>
> 1 -- copy the archived logs from the primary (I created a flat file
>list of
>all logs I had copied and did a difference between the list and the logs in
>the archive directory to get the names of the new ones to copy)
>
> 2 -- on the standby machine, ran a job every 15 minutes or so that
>checked
>to see if it was running already and if it was not, did the RECOVER STANDBY
>command. If it was already running, then obviously I didn't need to start
>a
>
>new one.
>
> 3 -- assorted jobs on both machines to clean out old archived logs
>
> Hope this gives you an idea of how to implement on your machine -- I
>have no
>NT experience in production so no scripts to share.
>
> Rachel
>
>
> >From: Reza Oskouie <reza.oskouie_at_digital-dispatch.co.uk>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Anyone with Standby on 8.0.5, NT please give me hand.
> >Date: Wed, 22 Nov 2000 04:11:28 -0800
> >
> >
> >Hi guys
> >I'm setting up a standby database for a production system on 8.0.5 (NT
> >Platform). It is management decision not to go with 8.1.6/7, so I have to
> >come up with a solution to automate my standby synchronization with the
> >production database.
> >I have two problems, anyone could provide some help in either side will
>be
> >highly and sincerely appreciated.
> >
> >1- when you want to apply Archived Logs to standby the only command is
> >(when
> >the database is mounted in standby mode) "RECOVER DATABASE STANDBY UNTIL
> >[CANCEL|......]"
> >when you execute this it interacts with you and ask for a decision
> >[RET,file,CANCEL, AUTO]. I need this to go ahead without asking and apply
> >the available logs in its ARCHIVE_LOG_DEST. Since I want to invoke the
> >server manager periodically to do the catch up transparently, which this
> >stupid interaction does not let this to be transparent. IS THERE ANY
>OTHER
> >OPTION FOR THIS COMMAND WHICH I'M MISSING?
> >
> >2- How can I transfer the Archived Redos from primary automatically. I
>know
>
> >that I need a sort of a script in Perl or some other language to detect
>the
>
> >creation of new Archived Redos in primary and sends them over to
>standby's
> >ARCHIVE_LOG_DEST (pity that I do not have 8.1.6 since all is automated).
> >Has anyone know of any ready script for this purpose, it will save my
>job!
> >If you have any idea that even makes life easier, I still would like to
> >here
> >from you and could buy you a drink for appreciation.
> >
> >Please help me out.
> >Best Regards
> >Reza
>
>
>____________________________________________________________________________
>_________
>Get more from the Web. FREE MSN Explorer download :
>http://explorer.msn.com
><http://explorer.msn.com>
>
> --
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
><http://www.orafaq.com>
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (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: Tim Onions
> INET: tim.onions_at_speechmachines.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (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).
Received on Thu Nov 23 2000 - 20:08:07 CST