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