OraFAQ Forum: Replication » Basic Replication Setup

Home » Server Options » Replication » Basic Replication Setup - HOW?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Basic Replication Setup - HOW? [message #75571]

Wed, 10 November 2004 19:21

IA
Messages: 91
Registered: March 2004

Member

Hi Everyone,

�

I have located lots of documentation regarding Replication.

�

I want to implement a basic replication setup between two Oracle 9i databases.

�

My concern is that the documentation is so rich that its making the procedure very difficult.

�

Does anyone know where I can find a simple step by step guide that illustrates an example of how to do this thing?

�

I would much appreciate your input and feedback as this will form the starting point of my learning of this topic.

�

Thanks ... IA

Report message to a moderator

Re: Basic Replication Setup - HOW? [message #75572 is a reply to message #75571]

Wed, 10 November 2004 20:13

Deon
Messages: 6
Registered: September 2004

Junior Member

Buy the "Oracle Replication - Snapshot, Multi-Master & Materialized Views Script" book by John Garmany and Robert Freeman. It helped me a lot but im still having some difficulties setting up some of the replication requirements

If you give me a email address I can maybe email you a script I created to setup to master replication sites

Deon

Report message to a moderator

Re: Basic Replication Setup - HOW? [message #75573 is a reply to message #75572]

Thu, 11 November 2004 12:36

IA
Messages: 91
Registered: March 2004

Member

Hi Deon,

Thanks in advance.

My email is iaoracle123@yahoo.com.au

Cheers!

Report message to a moderator

Re: Basic Replication Setup - HOW? [message #75600 is a reply to message #75571]

Sun, 02 January 2005 22:27

archa
Messages: 4
Registered: January 2005

Junior Member

hi,
i have done this before using oracle 9i enterprise console manager.U just need to follow the steps provided in help for replication.
U can go to distributed -> replication->advanced replication->multimaster or materialized view and look for help provided in oracle for the same.

Report message to a moderator

Re: Basic Replication Setup - HOW? [message #112999 is a reply to message #75571]

Wed, 30 March 2005 07:56

tarun123v
Messages: 9
Registered: March 2005
Location: Hyderabad(India)

Junior Member

Hi dude i have posted the help for implementing the basic replication strategy in just check out the below fourum
http://www.orafaq.com/forum/t/27701/68461/
i have uploaded a file(doc) in this fourum just download that documentation espacially the implementation part of it

This Basic Replication strategy i have implemented by using Net8 easy Config and some sql commands ok dude

Report message to a moderator

Re: Basic Replication Setup - HOW? [message #179336 is a reply to message #112999]

Tue, 27 June 2006 00:27

vasavi_gupta
Messages: 1
Registered: June 2006
Location: Bangalore

Junior Member

Hi,
I have doubt related to Basic replication using Materialized views.

Suppose there is a database db1 , if we would want to replicate this database for some of the tables into another database db2.

To achieve this we create a materialized view in database db2 and materialized log in database db1.

Then for any of the DML statements in db1 will get logged into log file created in db1.
later on refreshing this log will do all the latest modifications in db2.

The question will this action affect the performance of the database db1 on refreshinglog .

I tried searching in net but not didnot get the required information.
Please can anyone tell me the whether the performance will be decreased if such an action is performed.

Thanks in advance.

Report message to a moderator

Re: Basic Replication Setup - HOW? [message #185920 is a reply to message #75571]

Fri, 04 August 2006 04:41

angelsliu
Messages: 23
Registered: July 2006

Junior Member

goto http://www.orafaq.com/forum/t/27701/68461/

Report message to a moderator

Previous Topic:	oracle won't allow fast refresh materialized view with union
Next Topic:	Hanging Job - How to solve

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 02 15:35:06 CDT 2025