What type of requirement or SLA do you have in regards to keeping the instances in sync?
-Joe --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > Stand-by (Oracle9i Data Guard) vs. Replication > > Folks, > > I have a mission critical system we are architectonic right now. > There is some argument of the merits of replication vs. using > Standby database going on. > > Current we have 4 sites that we will be replicating data back and > forth between. There are 3 kinds of data: > > 1. Network Critical data (must be available for entire network) > 2. Regional Critical data (only used for a given region. site = > region). > 3. Regional non-critical data (this is data that is easily > recovered from > other operational data stores). > > I can load you up with details, but for now this is the general > requirement. We want a given site to be able to work independently > of the other sites in the event of network failure (WAN). > > What I'm looking for is your experience with using replication > for HA solutions vs. stand-by databases. I've also considered using > standby databases as a possible solution to this problem, along > with > using transportable tablespaces to re-sync the databases once > everything > comes up. I'm concerned with replication in that there is allot to > break, > and I'm concerned about synchronization issues in general with > either > solution. > > Thoughts? > > RF > > > 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. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).