RE: muliple instances on one database?

Christophe,

thanks for your reply, especially the use of the Veritas Cluster Server is interesting since we are already using vxfs on the Sun boxes. I just wonder how to deal with that second instance on teh second box. Do I use a copy of the init.ora from the original box and how do I create the second instance? The loss of connections is, according to the management, not really a big issue so they are quite fond of this solution since they won't have to spend extra money for the OPS license. Unfortunatly, I've never worked with this.

tia,
Bert Jan Meinders
Oracle DBA

>===== Original Message From Hieraklion <hieraklion_at_spray.fr> =====
>"Bonjour" from Paris
>
>Three solutions :
>
>A / Use Oracle Parallel Server (OPS). You can have several instances
>(one
>instance per host generally) using the same database at the same moment
>Advantage :
>If a host comes down, the opened connections are not lost, all the
>transactions
>migratre on the other instance. The database is not stopped nor the
>client
>connections.
>
>Disavantages :
>A particular license to use OPS (expensive ?)
>Hard to administrative ?
>
>B/ Use a mecanism like Veritas Cluster Server (VCS). Several instances
>can use
>the same database but not at the same moment. Only one instance is
>running and
>is active at a given time. If the host on which the instance runs comes
>down,
>the cluster software migrates all the necessary resources (disk group,
>volumes,
>NFS mounts, Virtual IP, listeners and instance) and starts the second
>instance.
>
>Avantages:
>Can be done with the standard license of oracle.
>Buy a cluster software but you can use it for several cluster groups.
>Disavantages : Opened connections are lost during the failover and no
>committed
>transactions are rollbacked.
>
>C/ Replication database but you need like Stand by database new disks
>for the
>second database.
>
>"Au revoir" from Paris
>Christophe Brault
>DBA
>
>Sig Dock a écrit :
>
>> Hi all,
>>
>> On the site where I'm working right now we have a Sun Fire 280 server with
a
>> Symmetrix EMC disk cabinet. I have configured my (Oracle 8.1.6.) database
so
>> it will put all the datafiles (including system, redolog and controlfiles)
>> on
>> the Symmetrix.
>> To create a failover-mechanism I want a second instance on another Sun Fire
>> 280, connected to the disk cabinet, to use this. Is this possible and how
do
>> I
>> create this 'standby' instance? I don't want to use the Oracle
>> standby-database because that will need al ot more diskspace and it needs
>> more
>> time to recover.
>>
>> rdbms is Oracle 8.1.6.0.0
>> OS is Solaris 2.8
>>
>> Regards,
>> Bert Jan Meinders
>> Oracle DBA
>
>Sig Dock a écrit :
>
>> Hi all,
>>
>> On the site where I'm working right now we have a Sun Fire 280 server with
a
>> Symmetrix EMC disk cabinet. I have configured my (Oracle 8.1.6.) database
so
>> it will put all the datafiles (including system, redolog and controlfiles)
>> on
>> the Symmetrix.
>> To create a failover-mechanism I want a second instance on another Sun Fire
>> 280, connected to the disk cabinet, to use this. Is this possible and how
do
>> I
>> create this 'standby' instance? I don't want to use the Oracle
>> standby-database because that will need al ot more diskspace and it needs
>> more
>> time to recover.
>>
>> rdbms is Oracle 8.1.6.0.0
>> OS is Solaris 2.8
>>
>> Regards,
>> Bert Jan Meinders
>> Oracle DBA
Received on Thu Aug 23 2001 - 02:31:18 CDT