Re: Split Blocks on Instance Crash

Hi,

Because in case of instance crash, you can always read the previous image of block from disk and all subsequent changes to this block can be read from online logfiles, in media failure case you might not be able to do so.

Tanel.

• Original Message ----- From: "Charlotte Hammond" To: Sent: Thursday, December 22, 2005 9:31 AM Subject: Re: Split Blocks on Instance Crash

>
> Thanks David - but why is this different from the
> backup situation? You would have the (archived) redo
> available then too, but you must still use BEGIN/END
> BACKUP to avoid split blocks.
>
> Charlotte
>
>
>
> --- David Sharples wrote:
>
>> because the information is available from redo /
>> undo and can easily be
>> replayed in case of a failure
>>
>> On 12/22/05, Charlotte Hammond
>> wrote:
>> >
>> > Hi All,
>> >
>> > Why does instance crash recovery not encounter the
>> > split blocks that you might get doing a backup
>> without
>> > BEGIN/END BACKUP?
>> >
>>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l