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

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
--------------------------------------------------------------------
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).