RF, Looks like you are looking for something like quest software's shareplex. A cool tool, although, on the expensive side. It has the ability to replicate with least intrusion and perf impact. ( Or thats what they say...:) ) And no....I am not working for quest software...!
Cheers, RS --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > 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 > > --- "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). > -- > 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: Sakthi , Raj 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).