OraFAQ Forum: Replication » Stream replication

Home » Server Options » Replication » Stream replication (oracle 11.1, linux)

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

Stream replication [message #676408]

Sun, 09 June 2019 02:11

Manishkumar
Messages: 36
Registered: May 2019

Member

Hi,

I am facing following issues:-

a) I configure oracle stream replication with 4 databases as multimaster way.I created it with both ddl and dml as true. Everything is replicating But after deletion of content in table when i am trying to run dump with content=data_only it is not replicating. Link used for configuring replication is https://docs.oracle.com/cd/B19306_01/server.102/b14228/repmultdemo.htm

b) After adding a new db to above 4 databases. Changes are not replicating to new db.

Thanks,
Manish

Report message to a moderator

Re: Stream replication [message #676411 is a reply to message #676408]

Sun, 09 June 2019 04:11

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

Senior Member

I am not being deliberately unhelpful, but:

a) I do not understand thisQuote:

Everything is replicating But after deletion of content in table when i am trying to run dump with content=data_only it is not replicating.

and I do not expect that anyone else does. Can you show what you are trying to do?

b) Similarly, you have to show what you did and what is not working.

A general point: are you aware that Streams has been deprecated since July 2013, when 12cR1 was released? That is five years ago. I would hope that everyone who is using it has already worked out how to stop using it.

Report message to a moderator

Re: Stream replication [message #676413 is a reply to message #676411]

Sun, 09 June 2019 04:39

Manishkumar
Messages: 36
Registered: May 2019

Member

For a) say i have table abc in schema hr now if i do delete from hr.abc then it delete the content and it replicates to other three db also it is ok acceptable. Now i have a dump say abc.dmp with data now i run impdp hr/<passwd> directory=<dir_path> tables=abc dumpfile=abc.dmp content=data_only table_exists_action=replace; this command will enter data only in current db but content won't replicating in other db and i am not getting any apply error.
b) I added a new db and create its apply and propagation in other db and also created other db capture, apply and propagation in new db now if i do any modification in any old db it is not reflecting in this new db whereas older four db reflecting the changes.

For depreciation Can you just guide what to use? I am using oracle 11.1.0.6.0

Report message to a moderator

Re: Stream replication [message #676415 is a reply to message #676413]

Sun, 09 June 2019 05:08

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

Senior Member

Uncle Oracle says "replace Streams with GoldenGate". Alternatives might be various types of Standby Database, or a Sharded database, or a stretched cluster. Use Global Data Services to direct traffic to where it needs to go.

My own approach is to ask "do you need replication at all?" Often it is used unnecessarily. The old reasons for replication and distributing data (performance, fault tolerance, scalability) all have better solutions now. Why do you think you need to do it? Is it just beause you are running on software released in August 2007?

Report message to a moderator

Re: Stream replication [message #676416 is a reply to message #676415]

Sun, 09 June 2019 05:16

Manishkumar
Messages: 36
Registered: May 2019

Member

We have application running who reads data from DBServers. In case any application fails other one will take over responsibility. so, I need it to provide redundancy so that database will be in sync.

Report message to a moderator

Re: Stream replication [message #676417 is a reply to message #676416]

Sun, 09 June 2019 05:18

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

Senior Member

Perfect usage case for Data Guard.

Report message to a moderator

Re: Stream replication [message #676418 is a reply to message #676415]

Sun, 09 June 2019 05:20

Manishkumar
Messages: 36
Registered: May 2019

Member

what are better solutions? My main concern is also bandwidth of 64 kbps which may increase a lot of logs and reduce system performance.And i think golden gate requires high bandwidth and it is not supported with 11.1

Report message to a moderator

Re: Stream replication [message #676419 is a reply to message #676417]

Sun, 09 June 2019 05:21

Manishkumar
Messages: 36
Registered: May 2019

Member

I didn't understand data guard.

Report message to a moderator

Re: Stream replication [message #676420 is a reply to message #676419]

Sun, 09 June 2019 05:22

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

Senior Member

But it seems that you do not understand Streams either Smile

Smile

Really, use the right tool for the job.

Report message to a moderator

Re: Stream replication [message #676422 is a reply to message #676420]

Sun, 09 June 2019 05:30

Manishkumar
Messages: 36
Registered: May 2019

Member

can you guide any tool for rhel 5. I am using sqlplus and the link which i shared earlier for configuring the streams. What is use of data guard. Now what is the purpose of using replication?

Report message to a moderator

Re: Stream replication [message #676423 is a reply to message #676419]

Sun, 09 June 2019 05:31

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Manishkumar wrote on Sun, 09 June 2019 12:21

I didn't understand data guard.

Standby database is a synonym.

Report message to a moderator

Re: Stream replication [message #676424 is a reply to message #676422]

Sun, 09 June 2019 05:34

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

Senior Member

Manishkumar wrote on Sun, 09 June 2019 11:30

can you guide any tool for rhel 5. I am using sqlplus and the link which i shared earlier for configuring the streams. What is use of data guard. Now what is the purpose of using replication?

I have suggested (I could be wrong) that there is no purpose for using replication in this case, and the use of Data Guard should be clear after one glance at the docs.
I am sorry, but if this does not make sense then I do not think that I can help. Perhaps someone else can assist.

Report message to a moderator

Re: Stream replication [message #676425 is a reply to message #676417]

Sun, 09 June 2019 05:35

Manishkumar
Messages: 36
Registered: May 2019

Member

I don't want dataguard. All are running parallely but one is handling client if that main goes down client request forward to other

Report message to a moderator

Re: Stream replication [message #676426 is a reply to message #676424]

Sun, 09 June 2019 05:43

Manishkumar
Messages: 36
Registered: May 2019

Member

I am using multiple servers these are 5 to 6 servers. And i have to make database sync all time. Now tell me the way.

Report message to a moderator

Re: Stream replication [message #676427 is a reply to message #676426]

Sun, 09 June 2019 05:51

Manishkumar
Messages: 36
Registered: May 2019

Member

On discussion we forgot actual issue

I am facing following issues:-

a) I configure oracle stream replication with 4 databases as multimaster way.I created it with both ddl and dml as true. Everything is replicating But after deletion of content in table when i am trying to run dump with content=data_only it is not replicating. Link used for configuring replication is https://docs.oracle.com/cd/B19306_01/server.102/b14228/repmultdemo.htm

b) After adding a new db to above 4 databases. Changes are not replicating to new db.

Report message to a moderator

Previous Topic:	Replication to use
Next Topic:	Adding new DB in oracle stream replication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 16 04:38:13 CDT 2025