Re: Standby Instance questions and HA

What you are describing sounds like Oracle FailSafe. It is free from Oracle, does not require Oracle Enterprise version (Standard/workgroup can be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS) which is included in NT4.0 EE or W2K Advanced Server.

As for Sun Solaris, I know nothing so will be of no help to you there.

                                                                                       
                                                          
                    "James McCann"                                                     
                                                          
                    <james_at_openet-te        To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>                                  
                    lecom.com>              cc:                                        
                                                          
                    Sent by:                Subject:     Standby Instance questions 
and HA                                                       
                    root_at_fatcity.com                                                   
                                                          
                                                                                       
                                                          
                                                                                       
                                                          
                    01/17/2002 06:40                                                   
                                                          
                    AM                                                                 
                                                          
                    Please respond                                                     
                                                          
                    to ORACLE-L                                                        
                                                          
                                                                                       
                                                          
                                                                                       
                                                          

Hi,
  I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby Instances.

Note, this is not a standby database.

>From the book it seams to work in the following way...

There is only one database.
The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second
machine using the datafiles on the shared disk.

The problem is that I can't find anything in the Oracle docs about this, or on Meta Link.

I also want to know if this method of HA requires a clustered environment (I
think it does, but just want to be sure)?

Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost?

We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible.

We don't want the expense of Parallel Server (Anyone know how expensive it is these days?).

The disk pack is RAID, and we may also have a standby database off site.

Has anyone any recommendations?

Thanks,

Jim

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James McCann
  INET: james_at_openet-telecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Allen R. Lucas
  INET: alucas_at_chicagobridge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).