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: Jim Kennedy <jim>
Date: Mon, 13 Feb 2006 07:20:51 -0800
Message-ID: <sM-dnQJc7bvLPm3eRVn-gw@comcast.com>

"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 Received on Mon Feb 13 2006 - 09:20:51 CST

Original text of this message

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