Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Stand-by (Oracle9i Data Guard) vs. Replication

RE: Stand-by (Oracle9i Data Guard) vs. Replication

From: <Brian_P_MacLean_at_eFunds.Com>
Date: Mon, 25 Mar 2002 10:58:42 -0800
Message-ID: <F001.00432579.20020325105842@fatcity.com>

(from the mouth of a replication non-quru)

I think you answered your own question. If no network and they want to be up, then synchronous replication is not an option. You're only option is asynchronous replication.

One answer that I'm sure EMC would luv to sell you is networked raw disks in conjunction with Oracle Parallel Server (OPS/RAC). If cost is not a problem, then EMC has the solution. It's not their company slogan/mission statement, but it should be. In this scenario you may lose a node but you can trade the problems of asynchronous replication conflict detection and resolution (and maintaining multiple databases), for the OPS locks and false ping problems. If given a choice, I'd take the OPS problems.

Brian P. MacLean
Oracle DBA, OCP8i

                                                                                                              
                    "Freeman,                                                                                 
                    Robert "             To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>  
                    <Robert_Freema       cc:                                                                  
                    n_at_csx.com>           Subject:     RE: Stand-by (Oracle9i Data Guard) vs. Replication      
                    Sent by:                                                                                  
                    root_at_fatcity.c                                                                            
                    om                                                                                        
                                                                                                              
                                                                                                              
                    03/25/02 10:48                                                                            
                    AM                                                                                        
                    Please respond                                                                            
                    to ORACLE-L                                                                               
                                                                                                              
                                                                                                              




Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however.

These requirements smack of trouble to me.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

-----Original Message-----
Sent: Monday, March 25, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L

What type of requirement or SLA do you have in regards to keeping the instances in sync?

-Joe


Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Raube
  INET: jraube_at_yahoo.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: Freeman, Robert
  INET: Robert_Freeman_at_csx.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: 
  INET: Brian_P_MacLean_at_eFunds.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).
Received on Mon Mar 25 2002 - 12:58:42 CST

Original text of this message

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