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

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. Received on Sun Feb 13 2000 - 20:20:55 CST