Home » Server Options » Replication » Stream replication (oracle 11.1, linux)
Stream replication [message #676408] Sun, 09 June 2019 02:11 Go to next message
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
Re: Stream replication [message #676411 is a reply to message #676408] Sun, 09 June 2019 04:11 Go to previous messageGo to next message
John Watson
Messages: 8075
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.

Re: Stream replication [message #676413 is a reply to message #676411] Sun, 09 June 2019 04:39 Go to previous messageGo to next message
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
Re: Stream replication [message #676415 is a reply to message #676413] Sun, 09 June 2019 05:08 Go to previous messageGo to next message
John Watson
Messages: 8075
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?
Re: Stream replication [message #676416 is a reply to message #676415] Sun, 09 June 2019 05:16 Go to previous messageGo to next message
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.
Re: Stream replication [message #676417 is a reply to message #676416] Sun, 09 June 2019 05:18 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
Perfect usage case for Data Guard.
Re: Stream replication [message #676418 is a reply to message #676415] Sun, 09 June 2019 05:20 Go to previous messageGo to next message
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
Re: Stream replication [message #676419 is a reply to message #676417] Sun, 09 June 2019 05:21 Go to previous messageGo to next message
Manishkumar
Messages: 36
Registered: May 2019
Member
I didn't understand data guard.
Re: Stream replication [message #676420 is a reply to message #676419] Sun, 09 June 2019 05:22 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
But it seems that you do not understand Streams either Smile

Really, use the right tool for the job.
Re: Stream replication [message #676422 is a reply to message #676420] Sun, 09 June 2019 05:30 Go to previous messageGo to next message
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?
Re: Stream replication [message #676423 is a reply to message #676419] Sun, 09 June 2019 05:31 Go to previous messageGo to next message
Michel Cadot
Messages: 66715
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Manishkumar wrote on Sun, 09 June 2019 12:21
I didn't understand data guard.
Standby database is a synonym.

Re: Stream replication [message #676424 is a reply to message #676422] Sun, 09 June 2019 05:34 Go to previous messageGo to next message
John Watson
Messages: 8075
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.

Re: Stream replication [message #676425 is a reply to message #676417] Sun, 09 June 2019 05:35 Go to previous messageGo to next message
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
Re: Stream replication [message #676426 is a reply to message #676424] Sun, 09 June 2019 05:43 Go to previous messageGo to next message
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.
Re: Stream replication [message #676427 is a reply to message #676426] Sun, 09 June 2019 05:51 Go to previous message
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.
Previous Topic: Replication to use
Next Topic: Adding new DB in oracle stream replication
Goto Forum:
  


Current Time: Sun Dec 08 17:48:18 CST 2019