Home » Server Options » Replication » Replication options
Replication options [message #527690] Wed, 19 October 2011 14:38 Go to next message
borisbadri
Messages: 2
Registered: April 2007
Location: India
Junior Member
Hi,

I would like to know the Replication method which is fast and the best approach,we need two schemas to be moved/replicated to a new reporting database.It appears that data is to be flown in one way,do we proceed with Materialized view replication or please clarify about Oracle Streams and Advanced replication. what are the factors to decide the replication method.Please let me know if any further information is required

Thanks,
Badri S
Re: Replication options [message #527691 is a reply to message #527690] Wed, 19 October 2011 15:11 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I would say that the first point to consider is money. Materialized View replication is included in Standard Edition Licences, Advanced Replication and most of Streams needs Enterprise Edition Licences. Golden Gate would be separately licensed.
Apart from that, you need to document the requirement: how close to real-time does the replication need to be? Should the master site continue to operate if the replication fails?
Re: Replication options [message #527895 is a reply to message #527691] Thu, 20 October 2011 13:01 Go to previous messageGo to next message
borisbadri
Messages: 2
Registered: April 2007
Location: India
Junior Member
Thanks John for your reply,We are in the initial stage of planning and am not sure how close the real time data needs to be available,if real time data needs to be available immediately,do we not proceed with MV replication?Master site will continue to work even if there is replication issue..

Is there a performance oriented difference in choosing between Streams and Advanced Replication and also if replication database is going to be used for reporting,is MV replication the best option?
Re: Replication options [message #530176 is a reply to message #527895] Sat, 05 November 2011 21:20 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

not only related to performance; you have new features too in streams.

Previous Topic: Materialized Views Help
Next Topic: GG Bounded Recovery
Goto Forum:
  


Current Time: Thu Mar 28 18:39:29 CDT 2024