Re: Questions about Standby Database

On Thu, 17 Oct 2002 20:40:26 +0100, "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote:

>"Jeffrey Keung" <jkeung_at_hknet.com> wrote in message
>news:3DAEC7D1.9406817E_at_hknet.com...
>> Sorry, I have forgotten to state the Version. I am using Oracle
>8.1.7standard
>> version.
>> And i had setup the standby database but using manual recovery mode only.
>> (Seems standard version didn't support managed standby database)
>
>Absolutely right it doesn't. manual standby is the best you can do.
>
>If you felt like sharing your scripts with the group I'd love to steal them
><g>.
>
>having said all that my personal take on the issue is that *if* a standby db
>is what your business really requires (as opposed to a periodically
>rebuilt/cloned one) then the business needs to pay for EE and managed
>standby. What happens if the DBA is taken out by the same disaster that
>kills the server?

Even if the bussiness requires a kind of standby database the cost difference between standard and enterprise edition is considerable, and a working automitic standby solution can relative simply be created as described.
And with proper preparation (written descriptions of what to do, and live demonstrations on how to activate the standby) it is possible to switch over (oh horror !!!) without the DBA. One problem I have experienced is the automatic copying of archive logs. On Windows NT it is actually possible to copying a file while the LGWR is still writing - resulting of course in an unusable file. My solution is to force a logswitch and wait a couple of minutes before copying. Furthermore I repeat the copying for the last few files of the former copy process.

Not 100 % bulltproof, I admit, but even in a worst case the data loss will be minimal and I and my department can live with it.

Hans Erik Busk Received on Fri Oct 18 2002 - 07:36:24 CDT