| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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.
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-----
From: Reza Oskouie [mailto:reza.oskouie_at_digital-dispatch.co.uk]
Sent: 22 November 2000 17:16
To: Multiple recipients of list ORACLE-L
Subject: RE: Anyone with Standby on 8.0.5, NT please give me hand.
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-----
From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
Sent: 22 November 2000 13:25
To: Multiple recipients of list ORACLE-L Subject: Re: Anyone with Standby on 8.0.5, NT please give me hand. Reza, What I did with 7.3.4 on Unix (but the concept should work for NT)was use
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
--
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-LReceived on Thu Nov 23 2000 - 02:56:30 CST
 |
 |