RE: 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 17:16:22 -0000
Message-Id: <10688.122741@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_01C054A7.EFB69D00
Content-Type: text/plain;

charset="iso-8859-1"

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
>
> 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).

------_=_NextPart_001_01C054A7.EFB69D00
Content-Type: text/html;

charset="iso-8859-1"
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>RE: Anyone with Standby on 8.0.5, NT please give me = hand.</TITLE>
</HEAD>
<BODY>

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.

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Best Regards</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Reza</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">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 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.

<P><FONT SIZE=3D2 FACE=3D"Arial">Rachel</FONT>
</P>
<BR>

>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

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Hi guys</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;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.

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Please help me out.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Best Regards</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Reza</FONT>
</P>

<FONT SIZE=3D2 =

FACE=3D"Arial">_________________________________________________________=
____________________________</FONT>

Get more from the Web.  FREE MSN = Explorer download : <A HREF=3D"http://explorer.msn.com" = TARGET=3D"_blank">http://explorer.msn.com</A>

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L FAQ: =
<A HREF=3D"http://www.orafaq.com" =

TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Rachel Carmichael</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

carmichr_at_hotmail.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 Wed Nov 22 2000 - 11:16:22 CST