there is a new white paper (Feb 2002) from Oracle HA Center for
Expertise that speaks to making databases maximumly highly available.
It suggests a combination of RAC and standby (dataguard) with 9i.
My thoughts on your requirements are:
first -- I agree with Kirti, you need VERY specific language and should
have downtime etc quantified in measurable units. ASAP is not
measurable, for some systems that might mean two minutes and for others
it might mean days. Get NUMBERS
second -- can you run these in separate databases with dblinks? I'd
isolate the data based on how available and to whom it has to be
available. so I'd consider the Oracle solution for the data that must
be available to everyone, then separate servers and databases for the
others.
third -- understand that it doesn't matter how available your servers
and databases are if the networks are also not redundant.
Finally -- has anyone at all considered and allowed for downtime for
maintenance/upgrades?
Just a few thoughts off the top of my head.
Rachel
- "Freeman, Robert " <Robert_Freeman_at_csx.com> wrote:
> Unfortunately, there are synchronization issues with the use of the
> stand-by
> since one requirement is that EACH of the 4 sites must be able to run
> autonomously... in other words, if I take all 4 sites out of stand-by
> mode,
> they make changes at all 4 sites and then we have to resynch (after
> the
> network is back for example) how the heck do I do that.
>
> I thought about using separate schemas for local data, and
> transportable
> tablespaces, but there is some data that is shared by the entire
> network,
> and that is a problem.
>
> 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.
>
>
>
> -----Original Message-----
> Sent: Monday, March 25, 2002 1:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> One way to recover Standby machine is to share a drive from the
> remote
> machine, and copy (ftp) the log files to the shared drive every time
> a new
> log
> file was created.
>
> Yigal
>
> "Freeman, Robert " <Robert_Freeman_at_csx.com> 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 " <Robert_Freeman_at_csx.com> 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: 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).
> >
> >
> > __________________________________________________
> > 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: Yigal Ran
> INET: ydran_at_usa.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
>
=== message truncated ===
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: Rachel Carmichael
INET: wisernet100_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).
Received on Mon Mar 25 2002 - 15:18:23 CST
