From: "Howard J. Rogers" Newsgroups: comp.databases.oracle,comp.databases.oracle.server References: <3A0C0D51.99AD0683@class.de> Subject: Re: 8i standby question Lines: 39 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Original-NNTP-Posting-Host: 203.134.153.42 Message-ID: <3a0d21c6$1@news.iprimus.com.au> X-Original-Trace: 11 Nov 2000 21:39:02 +1100, 203.134.153.42 Date: Sat, 11 Nov 2000 21:38:05 +1100 NNTP-Posting-Host: 203.134.64.67 X-Trace: news0.optus.net.au 973939143 203.134.64.67 (Sat, 11 Nov 2000 21:39:03 EST) NNTP-Posting-Date: Sat, 11 Nov 2000 21:39:03 EST Organization: CWO Customer - reports relating to abuse should be sent to abuse@optus.net.au 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" wrote in message news:3A0C0D51.99AD0683@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 > >