RE: DataGuard

-----Original Message-----
From: Boris Dali [mailto:boris_dali_at_yahoo.ca] Laimutis,
> Primary db's network cable unplugged.
> FSFO happens(?) - it should, this is the whole idea of it.
No, I believe it doesn't if your target standby is unsynchronized.

OK, I got it.

Case 1. If primary is running in Maximum Protection mode then with cable unplugged it will shutdown and even if opened and made available again it will not commit any more transactions.

Case 2. if primary is running in Maximum Availability mode: it will not shutdown with cable unplugged.
It must go into Maximum Performance mode. As far as I know Oracle pings standby about every 120-180 secs (it probably depends on tcp/ip timeouts?)
Which gives about the same time for "split brain" situation when Primary is made available again, doesn't it?

Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer

--
http://www.freelists.org/webpage/oracle-l