Hello everybody, this is my environment:
Primary Database: RAC nodes, Oracle 22.214.171.124, SLES 10
Standby Database: Single Instance, 126.96.36.199, SLES 10
Protection Mode: Max. Performance
Standby database is open with real time apply, ‘cause, it is used by read only applications. At least, twice a week, standby database is desynchronized with its primary database. In that situation, standby remains open sometimes but other times, it changes from open to mounted state, what its troubles ‘cause applications can’t read data from it.
Finally, I don’t know, why standby after having GAP or being desynchronized with primary, sometimes remains OPEN and other times changes from OPEN to MOUNTED.
Thanks a lot, any help will be appreciated.