Re: Syncing archive logs?

Karl,

I have a White paper from Oracle that is called:

"Standby Database: Design, Implementation And Administration" by   Sajjad Masud and Jasmin Nakic

that explains in detailed steps what you have to do, but basically:

• make a backup copy of the primary DB
• restore it on your standby machine, has Oracle already intalled
• generate a standby controlfile on the primary machine alter database create standby controlfile as 'xxx.ctl'
• copy it to your standby machine
• startup standby db:

    startup nomount
    alter database mount standby database

• then set up a rcp process to copy your archived redo logs to the standby machine and periodically apply the redologs in svrmgrl (should be a cron batch job)

  connect internal
  recover standby database until cancel   auto
  cancel
  exit

Of course, there is a lot more to it. See if you can get the WP from your Oracle support. I only have it on paper, otherwise I would send it to you.

Wolfgang Kandek
MCI Systemhouse - wkandek_at_shl.com

In article <369A4ADE.B2AD895C_at_dragon.illusions.com>,   "Karl E. Taylor" <ktaylor_at_dragon.illusions.com> wrote:
> Hi there.
>
> Here's the project. I have to Oracle 8.0.3 instances running on 2 Sun
> 4500's separated by a dozen states.
>
> OLTP
> on 1.1.10.170
>
> Hot Swap of OLTP
> on 1.1.18.164
>
> The client does not want to run a parallel server environment through a
> slow frame relay connection. What I need to do is capture the finished
> archive log, copy it via rcp to the Hot Swap system, then apply that log
> to the Hot Swap instance. Capturing the archive log is not a problem,
> transferring and applying the log is not a problem, I think. The
> problem I have is, how do I sync the archive logs before any of the rest
> of this starts?
>
> I would like both systems to start over from 0 and through this update
> method, they will stay in sync -1 on the Hot Swap side.
>
> Any help is greatly appreciated.
>
> Thanks.
> --
> _________________________________________________________
> Rev. Karl E. Taylor ktaylor_at_dragon.illusions.com
>
> A.A #1143 ULC Minister
>
> Home School Educator for Computer Science
>
> Apostle of Dr. Lao
> _________________________________________________________
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 20 1999 - 19:36:01 CST