Re: Questions about Standby Database

Comment embedded.

"Hans Erik Busk" <tbf_at_cn.stam.dk> wrote in message news:fcvvqu4iv70v9l3q9t1m8vd20lg1scohb3_at_4ax.com...
> 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.

Gee, that sends a shiver up my spine, bbbrrrrrrrrrrr ;)

> 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.

Don't quite follow this. How is LGWR writing to an *archived* redo log. It only writes to the online logs which you shouldn't be touching ?

It's getting late here in sunny Canberra so I could have missed something really obvious but I thought I might just ask.

Cheers

Richard

>
> 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 - 08:07:14 CDT