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

is this what you want ?

connect internal/<password>;
set autorecovery on;
recover standby database;
exit;

> -----Oorspronkelijk bericht-----
> Van: Tim Onions [SMTP:tim.onions_at_speechmachines.com]
> Verzonden: 23-nov-00 10:00
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: RE: Anyone with Standby on 8.0.5, NT please give me hand.
>
> 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
Received on Thu Nov 23 2000 - 03:28:05 CST