Re: Large log files

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 15 Mar 2001 16:35:15 -0000
Message-ID: <98qr05$50f$1@soap.pipex.net>

Comments below
"Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message news:98qahg$em3$1_at_news247.cnt.ru...
>
> "Howard J. Rogers" <howardjr_at_www.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
> news:3ab086e0_at_news.iprimus.com.au...
> >
> > "Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message
> > news:98pt9i$dra$1_at_news247.cnt.ru...
> > > Hello!
> > >
> > > 1. I think large log files very bad idea because if database fails you
may
> > > lost large amount of data.
> >

> > Untrue. The size of the logs is irrelevant -provided they are mirrored,
> > such that loss of the current redo log is insured against. No data will
> > ever be lost in Oracle, provided all redo is available. Mirroring helps
> > prevent the loss of redo.
> >
>
> What If disks crash happens???
>

Then you take the affected disk out replace it and resilver. meanwhile Oracle is quite happy as the redo is mirrored. (this assumes hardware mirroring)

alternatively you drop the trashed redo log and recreate it so your mirror is once again ok. (Um I think. Thats what disk controllers are for - to do the mirroring for me). Received on Thu Mar 15 2001 - 10:35:15 CST