Re: Replication DB

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Tue, 20 Apr 1999 14:26:46 -0700
Message-ID: <371CF116.FAB51179@us.oracle.com>

This is not really the sort of question that can be answered through a newsgroup. After all, the training for setting up replication takes 5 days. However, in a nutshell replication is used for one of a couple of reasons:

Site failover - the master database fails, but the replicated database remains available on another machine
Data offloading - the performance of remote queries is not acceptable due to bandwidth problems, so move the data locally
Data subsetting - users at branch offices only need a subset of the data that users at headquarters need
Mobile computing - sales people need to take information with them on laptops that aren't connected to the database.

That should give you some ideas for questions 1 and 3. Question 2 is answered in 5 days at the training, so I can't really summarize it here. Besides the setup requirements are determined by the business requirements, and you haven't mentioned those.

HTH. Pete

Ghazi Ben Youssef wrote:

> Hi everybody,
>
> 1- I would like to know more about replication advantages.
> 2- What is the strategie that can be followed, to perform replication.
> 3- can you give me some examples of replication.
>
> thanks in advance

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Apr 20 1999 - 16:26:46 CDT