| 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
|
|
|
|
| Re: Stream replication [message #676411 is a reply to message #676408] |
Sun, 09 June 2019 04:11  |
John Watson
Messages: 8964
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 #676415 is a reply to message #676413] |
Sun, 09 June 2019 05:08 |
John Watson
Messages: 8964
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 #676424 is a reply to message #676422] |
Sun, 09 June 2019 05:34 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Manishkumar wrote on Sun, 09 June 2019 11:30can 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 #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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
