Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: muliple instances on one database?
"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 Wed Aug 22 2001 - 08:01:20 CDT