Home » Server Options » Replication » Stream Replication b/t 11g and 10 (merged) (11g r2, windows)
Stream Replication b/t 11g and 10 (merged) [message #656884] Fri, 21 October 2016 06:14 Go to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Hi Experts,

My source db is 11g r2 and target db is 10g r2.
I want to perform simple one-way table level replication.
Is this possible?

Thanks in advance.

Regards,
Qazi
Re: Stream Replication b/t 11g and 10 [message #656890 is a reply to message #656884] Fri, 21 October 2016 08:03 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
Sure, no problem. That is actually the way to do a (near) zero downtime upgrade.
Re: Stream Replication b/t 11g and 10 [message #656892 is a reply to message #656890] Fri, 21 October 2016 08:15 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Thanks John Watson for kind respone.

Kindly you can provide any step by step doc.


Regards,
Qazi
Re: Stream Replication b/t 11g and 10 [message #656893 is a reply to message #656892] Fri, 21 October 2016 08:17 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
It's all in the docs,
https://docs.oracle.com/cd/E11882_01/server.112/e17069/toc.htm
have a go, it can be quite simple.
Re: Stream Replication b/t 11g and 10 [message #656895 is a reply to message #656884] Fri, 21 October 2016 09:46 Go to previous messageGo to next message
Michel Cadot
Messages: 65203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why Streams and not a materialized view?

Re: Stream Replication b/t 11g and 10 [message #656897 is a reply to message #656895] Fri, 21 October 2016 10:48 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
Materialized View replication is certainly easier. And included in Standard Edition.
Re: Stream Replication b/t 11g and 10 [message #656922 is a reply to message #656897] Mon, 24 October 2016 04:36 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Thanks John Watson and Michel.

Regards,
Qazi
Where to find one-way stream replication issue [message #657006 is a reply to message #656884] Wed, 26 October 2016 02:03 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Hi Experts,

I performed simple one-way replication by following this document:

https://docs.oracle.com/cd/B28359_01/server.111/b28322/repsimpdemo.htm

Every thing work fine according to document. But changes are not going to target database.

Kindly help me to find where to locate the issue.

Thanks in advance.

Regards,
Qazi
Re: Where to find one-way stream replication issue [message #657007 is a reply to message #657006] Wed, 26 October 2016 02:07 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
What did you do?

One more point: you are following 11.1 doc. In your previous post (with which I shall merge this topic) you said you were using 11.2 and 10.2. You really should use whichever doc is appropriate for the version.

[Updated on: Wed, 26 October 2016 02:09]

Report message to a moderator

Re: Where to find one-way stream replication issue [message #657008 is a reply to message #657006] Wed, 26 October 2016 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 65203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Michel Cadot wrote on Fri, 21 October 2016 16:46

Why Streams and not a materialized view?
Re: Where to find one-way stream replication issue [message #657009 is a reply to message #657007] Wed, 26 October 2016 02:14 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Hi John,

Now my both databases are local and have release 11.2.0.1.0.

Thanks & Regards,
Qazi
Re: Where to find one-way stream replication issue [message #657010 is a reply to message #657009] Wed, 26 October 2016 02:18 Go to previous message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
Oh, right. the 11.2 docs,
https://docs.oracle.com/cd/E11882_01/nav/portal_booklist.htm

What did you do? If it is still just one table, a materialized vie would be easiest. If more complex, look at using dbms_streams_adm.maintain_tables
Previous Topic: golden gate replication to partitioned table
Next Topic: OGG unique identifier in target tables for CDC
Goto Forum:
  


Current Time: Thu Nov 23 10:51:22 CST 2017

Total time taken to generate the page: 0.01468 seconds