I think he means while ARCH is still writing.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:cwTr9.56215$g9.160932_at_newsfeeds.bigpond.com...
> 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:53:43 CDT
