Re: Replicate using 3rd party s/w or db level?

SeiSee,

it sounds like you need replication to be as frequent as possible. One limitation with this scenario is that Oracle only does snapshot replication. With a large database, this definitely limits how often you can replicate, especially over 256K. I can recommend a third-party product called the PeerDirect Replication Engine that does only net- change replication. In other words, only what's changed is replicated. It uses control tables to track these changes, and these can be updated using triggers. Also, replication can be scheduled and automated to run as frequently as every minute.

If you want more information, check out the web site: http://www.peerdirect.com/

Declan

In article <887oq5$lup$1_at_nnrp1.deja.com>,   seisee_at_my-deja.com wrote:
>
>
> U r right that I didn't make my question clear enuf.
> We actually need a standby database which is on anytime, it is as
> update as the master database.. I mean, with as little as possible
> different in data.
> So we only need one active database and another non-active but up-to-
> "time" duplicate database.
>
> And I'm confused whether I should use replication to have another set
> of the same database, or use any 3rd party software to achieve this.
>
> We are having 256k network, and if I use replication, it will be very
> frequent as the application is an online application.
>
> >
> > SeiSee
> >
> > You mention two different techniques here - replication and standby
> > database. Replication has both databases available for use, standby
> > database only has one available for normal use. Which one to use
> depends
> > on your business needs which you haven't outlined sufficiently for
us
> to
> > recommend one over the other. As for the level of network
> consumption,
> > this will vary from site to site and even application to application
> > within one site. What network speed do you have? How frequently do
> you
> > need to replicate? What data volumes will you be replicating etc.
> etc.
> > You really need to test this with your application to see if the
> > performance meets your needs.
> >
> > HTH.
> >
> > Pete
> >
> > seisee_at_my-deja.com wrote:
> >
> > > Hi all,
> > >
> > > I need to implement something like replication so that whenever
the
> > > database is failed/down, we have another standby database to take
> over
> > > the task.
> > >
> > > I found out that there's a few way to achieve this:
> > > 1) by using database replication.
> > > 2) by using 3rd party software like veritas.
> > >
> > > I need to consider both and choose a better solution... but I
don't
> > > know which way will be a better way.
> > >
> > > Anybody have any idea? Which way will be better?
> > > Will the database replication takes up a lot of network
consumption?
> > > ...
> > >
> > > Any help/suggestion will be useful.
> > > Thanks.
> > >
> > > worry,
> > > SeiSee
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> > --------------5AD4F41E967A9DB666F7986E
> > 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
> >
> > --------------5AD4F41E967A9DB666F7986E--
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 14 2000 - 09:31:40 CST