Laimutis Nedzinskas wrote:
[...]
Need some help or opinions regarding Oracle logical standby database.
Environment:
Logical standby, version 10, release 1, patch 4. Primary and standby are tight coupled (maximum availability mode).
[item 4 missing in original]
1) Deletion of consumed archive logs both on the standby and the primary site:[...]
2) Time from time standby breaks but this is more due to the schema patches.[...]
3) DB Guard leakes PGA memory on the primary. It leaked it for a fact(by OS reports), it was not V$-view bug. Had to disable it. Not really happy about that.
5) Primary is not happy about unexpected standby restarts.[...]
6) To sum up: something's a bit shaky in my environment at least. Should I give up with maximum availability mode and reduce the database to maximum performance mode? I am interested to hear from others.
I was hoping to see a more helpful reply than this one, but haven't yet.
-- Mark Bole http://www.bincomputing.com
-- //www.freelists.org/webpage/oracle-l