Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Anyone with Standby on 8.0.5, NT please give me hand.
There is NT replication please check it out which replicates the files
across machines.This I was using this to replicate files across machines it
used to work fine or as u said use the perl script or a small java script
which will copy files across the machines.
and as for as applying the archive logs to the database create a batch
script which will apply the logfiles on to the database.
>From: "Rachel Carmichael" <carmichr_at_hotmail.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: Wed, 22 Nov 2000 05:25:27 -0800
>
>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
>
>--
>Please see the official ORACLE-L FAQ: 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).