Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Replication

Re: Oracle Replication

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 13 Feb 2006 19:58:20 +0100
Message-ID: <dsqk58$pvd$1@news2.zwoll1.ov.home.nl>


Jim Kennedy wrote:

> "Locusta" <locusta74ster_at_gmail.com> wrote in message
> news:1139818412.746278.127430_at_g47g2000cwa.googlegroups.com...

>> Hello,
>>
>> We are using Oracle database for our entreprise application. Although I
>> was in favour for purchasing 2 servers and replication of the database
>> though SQL.NET, the guys from infrastructure thought they were smarter
>> and configured the system as a cluster, inclusive an expensive disk
>> array.
>>
>> Having the cluster, I only have one set of services, one database
>> instance and so on. In the case Oracle crashes (yes, last week a mouron
>> from infrastructure tested the backup in the middle of the day so one
>> of the data files needed to be rebuild from redo logs) I cannot switch
>> to another server (e.g. change the IP address from backup server to
>> production) to continue production.
>>
>> My question now is can I install 2 oracle instances let's say on disk
>> U:\Data and F:\Data, duplicate my services and do replication on one
>> server installed as cluster? Is there any good reference material that
>> describes a scenario like this?
>>
>> Looking forward to your reply,
>> Dirk
>>
> RAC is the way to go.  Replication adds a whole other layer of complication
> and many many more problems. (eg update one place and delays to the other.)
> THe configuration is a lot more complex.  If you are concerned with uptime
> you could look at dataguard.
> Jim
> 
> 

From what I read, the OP wants 2 instances, and 2 databases, not 1 database with 2 instances.

Break up the cluster, install Oracle 10gRelease 2 twice, and read up on Oracle Streams.
Dataguard is still an option.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Mon Feb 13 2006 - 12:58:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US