Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: V$SYSTEM_WAIT_CLASS

Re: V$SYSTEM_WAIT_CLASS

From: dean <deanbrown3d_at_yahoo.com>
Date: Tue, 14 Aug 2007 07:58:16 -0700
Message-ID: <1187103496.147929.153590@l70g2000hse.googlegroups.com>


On Aug 14, 1:30 am, sybra..._at_hccnet.nl wrote:
> On Mon, 13 Aug 2007 21:16:17 -0700, dean <deanbrow..._at_yahoo.com>
> wrote:
>
> >I've read to the contrary several times. Consider what would happen if
> >Oracle thought it saved a change to disk, and then there was a power
> >failure before the cache was written to disk? It would then be in a
> >corrupt state.
>
> Consider there is redolog, which is always written *before* the data
> files are written.
> Consider these redologs are multiplexed and on mirrored drives.
> So how likely is the fairy tale you describe above.
> Consider you are in dire need to revise your policy of not reading any
> manual.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

So there is no confirmation of the redo log being written either? Received on Tue Aug 14 2007 - 09:58:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US