Re: Instance Recovery Question

Perhaps, you have not commited when your instance crashes. Won't it be ok that way ?

AJG a écrit dans le message <36661AD3.891C007F_at_noemail.noemail>...
>Hi,
>

>A change is made to a data block
>That change is recorded in a rollback block

>Change also recorded in log buffer

>DBWR writes data block to disk
>Instance crashes
>- Change in log buffer not written to disk yet
>- Rollback information not written to disk yet
>This is a problem
>
>Two Solutions:
>1) Oracle always writes out the rollback block before the changed data
>block.
>2) Oracle always waits to flush a change in log buffer to disk before
>writting the changed block (data or rollback)
>
>2 sounds unlikely to me, so I'm going with 1.
>
>I'm I correct?
>
>Thanks!
>
>Alan.
>
>
>--
>Alan Gano
>http://home.att.net/~alangano/index.html
>
>
>
Received on Thu Dec 03 1998 - 01:58:48 CST