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

Home -> Community -> Usenet -> c.d.o.server -> Re: Asynch. Replication for failover site

Re: Asynch. Replication for failover site

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 22 Oct 1999 11:50:13 -0700
Message-ID: <3810B1E5.70B37829@us.oracle.com>


Bipin

There are two approaches that can be used to address this:

  1. Size the redo log small enough to be filled in five minutes, then have lots of them.
  2. Geo-mirror the redo log disk - expensive approach though.

HTH. Pete

dalalbm_at_my-deja.com wrote:

> Pete,
>
> Thanks for your reply.
>
> As I understand, in standby database approach, u could recover till the
> last archived redo log and you actually lose onlline redo log. What if
> redo log is archived/written once every two hours ? With asynch.
> replication, i could make this period probably 5 minutes !
>
> -Bipin.
>
> In article <380E4AE8.C038D101_at_us.oracle.com>,
> Pete Sharman <psharman_at_us.oracle.com> wrote:
> > This is a multi-part message in MIME format.
> > --------------1BF85BFD40B1229F2C46E8E7
> > Content-Type: text/plain; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > Bipin
> >
> > Asynchronous replication is not really designed to failover an entire
> > database. Standby databases are designed for this. Is there a reason
> you
> > can't use that approach?
> >
> > Pete
> >
> > dalalbm_at_my-deja.com wrote:
> >
> > > We are planning to use asynchronous(5 mins.) replication for a
> failover
> > > site to minimize data loss at the time of failure.
> > >
> > > Our problem is how to streamline sites once the primary site is up
> > > again. We want users to continue using failed over site for new
> > > transactions.
> > >
> > > Can anybody have done this before ?
> > >
> > > Thanks in anticipation.
> > >
> > > -Bipin.
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> > --------------1BF85BFD40B1229F2C46E8E7
> > Content-Type: text/x-vcard; charset=us-ascii;
> > name="psharman.vcf"
> > Content-Transfer-Encoding: 7bit
> > Content-Description: Card for Pete Sharman
> > Content-Disposition: attachment;
> > filename="psharman.vcf"
> >
> > begin:vcard
> > n:Sharman;Pete
> > tel;cell:+1.650.868.9969
> > tel;fax:+1.650.633.1506
> > tel;work:+1.650.607.0109
> > x-mozilla-html:FALSE
> > org:Advanced Technology Solutions;Oracle Corporation
> > adr:;;500 Oracle Parkway M/S OPL-A4019;Redwood Shores;CA;94403;USA
> > version:2.1
> > email;internet:psharman_at_us.oracle.com
> > title:Managing Principal Consultant
> > note;quoted-printable:**** The statements and opinions expressed here
> are my **** <br>=0D=0A **** own and do not necessarily represent those
> of **** <br>=0D=0A **** Oracle Corporation. **** <br>=0D=0A
> <br>=0D=0A "Controlling application developers is like herding cats."
> <br>=0D=0A Kevin Loney, ORACLE DBA Handbook <br>=0D=0A "Oh no it's
> not! It's much harder than that!" <br>=0D=0A Bruce Pihlamae, long term
> ORACLE DBA <br>
> > x-mozilla-cpt:;9088
> > fn:Pete Sharman
> > end:vcard
> >
> > --------------1BF85BFD40B1229F2C46E8E7--
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.


Received on Fri Oct 22 1999 - 13:50:13 CDT

Original text of this message

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