Re: 8i standby question

No, it doesn't take over automatically. The standby has no idea what is happening over in production.

Would you ever really want it to takeover automatically? Working out whether the last of the current redo in production can be successfully extracted and piped into the standby would take some time; understanding how much data has been lost (assuming you can't get that last bit of current redo out of a stuffed production system) is also something that takes a bit of skill and manual playing around. So my gut feeling is that automatic takeover by the standby would be the very last thing you'd ever want to happen.

If you want true failover and redundancy, then look into parallel server or failover... and make sure you keep the cheque book handy.

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


"Andreas Boehm" <andreas.boehm_at_class.de> wrote in message
news:3A0C0D51.99AD0683_at_class.de...


> Hi,

>

> Does within an 8i-standby configuration the standby database takeover


> automatically in case the production-site fails? If not, how could this

> be

> automized?

>

> regards,

> Andreas

>

>