OraFAQ Forum: Replication » Stream Replication b/t 11g and 10 (merged)

Home » Server Options » Replication » Stream Replication b/t 11g and 10 (merged) (11g r2, windows)

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

Stream Replication b/t 11g and 10 (merged) [message #656884]

Fri, 21 October 2016 06:14

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

Report message to a moderator

Re: Stream Replication b/t 11g and 10 [message #656890 is a reply to message #656884]

Fri, 21 October 2016 08:03

John Watson
Messages: 8794
Registered: January 2010
Location: Global Village

Senior Member

Sure, no problem. That is actually the way to do a (near) zero downtime upgrade.

Report message to a moderator

Re: Stream Replication b/t 11g and 10 [message #656892 is a reply to message #656890]

Fri, 21 October 2016 08:15

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

Report message to a moderator

Re: Stream Replication b/t 11g and 10 [message #656893 is a reply to message #656892]

Fri, 21 October 2016 08:17

John Watson
Messages: 8794
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.

Report message to a moderator

Re: Stream Replication b/t 11g and 10 [message #656895 is a reply to message #656884]

Fri, 21 October 2016 09:46

Michel Cadot
Messages: 68343
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why Streams and not a materialized view?

Report message to a moderator

Re: Stream Replication b/t 11g and 10 [message #656897 is a reply to message #656895]

Fri, 21 October 2016 10:48

John Watson
Messages: 8794
Registered: January 2010
Location: Global Village

Senior Member

Materialized View replication is certainly easier. And included in Standard Edition.

Report message to a moderator

Re: Stream Replication b/t 11g and 10 [message #656922 is a reply to message #656897]

Mon, 24 October 2016 04:36

qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan

Member

Thanks John Watson and Michel.

Regards,
Qazi

Report message to a moderator

Where to find one-way stream replication issue [message #657006 is a reply to message #656884]

Wed, 26 October 2016 02:03

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

Report message to a moderator

Re: Where to find one-way stream replication issue [message #657007 is a reply to message #657006]

Wed, 26 October 2016 02:07

John Watson
Messages: 8794
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

Michel Cadot
Messages: 68343
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?

Report message to a moderator

Re: Where to find one-way stream replication issue [message #657009 is a reply to message #657007]

Wed, 26 October 2016 02:14

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

Report message to a moderator

Re: Where to find one-way stream replication issue [message #657010 is a reply to message #657009]

Wed, 26 October 2016 02:18

John Watson
Messages: 8794
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

Report message to a moderator

Previous Topic:	OGG unique identifier in target tables for CDC
Next Topic:	Oracle Golden Gate extract date format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 02 09:54:07 CST 2023