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

From: Reza Oskouie <reza.oskouie_at_digital-dispatch.co.uk>
Date: Wed, 22 Nov 2000 12:09:13 -0000
Message-Id: <10688.122719@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0547D.0789A690
Content-Type: text/plain

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

------_=_NextPart_001_01C0547D.0789A690
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Anyone with Standby on 8.0.5, NT please give me hand. </TITLE>
</HEAD>
<BODY>
 

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.</FONT>

 Best Regards
 Reza
Received on Wed Nov 22 2000 - 06:09:13 CST