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

A copy of this was sent to declanw_at_my-deja.com (if that email address didn't require changing) On Mon, 14 Feb 2000 15:31:40 GMT, you wrote:

>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

while that comment that we do only snapshot replication would have been true in 1993, it stopped being true in about 1994 with the introduction of Oracle 7.1.6.

Even so -- why would that limit how often you can replicate? Snapshots always propaged changes only (or full if that is what you wanted) and only at the object level -- the entire database wasn't shipped across the network or anything -- only changes to the tables you are interested in.

But, even with basic snapshots, available with 7.0 and up, only changes need be replicated. In fact, with snapshots -- if i modify the same row 10 times in the refresh interval (between refreshes) -- only the LAST and not all of the intermediate changes get propagated.

With advanced replication -- only whats changed gets propagated.

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

same here. (or even less then a minute if you really wanted to).

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

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Feb 14 2000 - 10:26:59 CST