Re: Replication

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 26 May 1999 10:36:46 -0700
Message-ID: <374C312D.41EA0834@us.oracle.com>

Jenn

There are a number of approaches that can be taken to do what you want. Which of them to use is dependent on what you want to address:

Machine failover: On NT this can be addressed by Oracle FailSafe or Oracle Parallel Server. Both require NT clusters.
Site failover: You can use either replication or hot standby for this. Replication allows both databases to be up and running, hot standby is active-passive only. Replication is probably more complex to configure, but easier to failback. You need to decide which conflict resolution methodology you want to use if you're using both databases as updatable. If not both updatable, then one site will be query only.

That's a brief outline, let me know if you need more detail.

Pete

HTS Process Control wrote:

> Hi everyone!
>
> I have 2 WinNT 4.0 servers both with Oracle 7.3 on them.
>
> I would like machine A to work as a primary database server and machine
> B to act as a back up. I am thinking of using replication to do this.
> So that if machine A goes down I can use machine B to take client
> requests with little interruption to the clients.
>
> Is this the best approach? Is there an alternative method? What happens
> when the master (machine A) goes down? How does the replicate still
> collect data?
>
> Thanks,
>
> Jenn :)

Regards

Pete

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed May 26 1999 - 12:36:46 CDT