How to configure Standby database in oracle for read/write I have configured a physical standby database in Oracle 11gR2, and the standby database it's working fine. All the changes in the principal database are replicating to the standby database, the standby database is in read only mode. I want to configure the standby database for replicating the changes done in the standby database to the principal database, I mean i don't only need to open in read/write mode but also to apply the changes done in the physical standby to the principal. Any ideas of how to configure it? I have searched in the internet but I only find to open in a read/write test environment.
For this you need a logical standby database, instead of a physical one. This is a little more complex. Not all data types are supported and when data is updated on both sides on the same time, there could be some problems ahead.