Re: ASM and 4-way replication?

On 2006-11-08, hpuxrac <johnbhurley_at_sbcglobal.net> wrote:
>
> MarcelD wrote:
>> I need to build a high availabilty database solution.
>> The plan is to build a two node failover cluster, the two nodes beeing
>> in different buildings. There will be two disk-cabinets also, one in
>> each building.
>> The requirement is as follows: if the node or the storage in one
>> building completely fail,
>> we need to be able to be up again within 10 minutes, and without data
>> loss.
>> I'm checking the possibility to run such a setup without a SAN, just
>> using Oracle ClusterWare
>> and ASM.
>> OS is RedHat Linux, disks are fibre disks attached via switches to two
>> hba's on each node.
>> I know I can set the data-filegroup up with normal redundancy, which
>> would fulfill the requirements.
>> But then, if one storage location fails, I'm running on only one copy
>> of the data. Therefore I would like to have two copies of each datafile
>> in each building.
>> Can this be done whithout using a SAN?
>> Thanks for any input on this.
>
> Oracle dataguard could be setup to do this.
>

        Well... Dataguard is going to be a necessary element in this of course. Although I doubt this is what he's asking for within the individual sites. DG will just be used for site-to-site replication and failover.

        As an added bonus, this means that you need to buy the enterprise license of Oracle. (cha-ching)

        If DataGuard could be setup to do seamless failover, he might even be able to setup his two sites with it and avoid RAC. However, that's not the case. So, RAC is probably the only option. The DG switches in general (intra-site or inter-site) will be painful and unpleasant.

        That will be something to consider when building this thing out. Being in the position where you're doing frequent failovers is a royal PITA. Having a remote site only magnifies the pain. The better the clusters are put together, the happier everyone will be in the end.

        Does Oracle have a decent TNS name server solution yet?

-- 

	The social cost of suing/prosecuting individuals           ||| 
for non-commercial copyright infringement far outweighs           / | \
the social value of copyright to begin with.



 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com