Re: Split Blocks on Instance Crash

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 22 Dec 2005 09:48:42 -0600

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" <charlottejanehammond@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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 <davidsharples@xxxxxxxxx> 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
<charlottejanehammond@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l



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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2005