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: why r more archives generated during hot backup

Re: why r more archives generated during hot backup

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 23 Sep 2002 19:26:24 +0100
Message-ID: <3D8F5CD0.3E69@yahoo.com>


Richard Foote wrote:
>
> Hi Cane001,
>
> To protect the database from "fractured blocks".
>
> As you're performing an OS copy at the same time Oracle is writing to the
> data files, the possibility exists that a portion of an Oracle block is
> copied, followed by the DBWR overwriting the particular block , followed by
> the remaining portion of the Oracle block being copied. This means the
> copied Oracle block has a split personality in that one portion of the block
> is from one point in time and another portion of the block is from a
> different point of time.
>
> In other words, a fractured block.
>
> Restoring such a block would prove to be unrecoverable with the usual
> generation of redo as there is no way to reconstruct the block in a
> consistent manner.
>
> Therefore, while a data file is in hot backup mode, Oracle prevents issues
> with fractured blocks by coping the before/after image of the entire block
> such that an entire consistent block can be used during the recovery
> process.
>
> This is one of the reasons why it's vital to place the tablespace in backup
> mode before attempting a hot backup.
>
> This excessive redo generation is also the reason why it's recommended where
> possible to place one tablespace at a time in backup mode and why hot
> backups should be performed during a quiet period.
>
> Note that RMAN doesn't concern itself with this issue as fractured blocks
> are not possible with RMAN. That's because RMAN performs a checksum test on
> each block as it performs the copy. If it fails this test, RMAN simply
> recopies the block. If it passes the test this time, it was obviously a
> fractured block which the immediate recopy has automatically remedied. If it
> fails for a second time, then it's a corrupted block which RMAN duly
> documents.
>
> Cheers
>
> Richard
> "Cane001" <nkapadia41_at_yahoo.com> wrote in message
> news:acf7ab77.0209200004.72143f7f_at_posting.google.com...
> > I would like to know why r more archives generated during hot backups

I haven't physically sat down and verified, but I think its (only) the *first* change to the block since it is loaded into the cache. Thus you might get (all in hot bkp mode)

etc
etc

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Mon Sep 23 2002 - 13:26:24 CDT

Original text of this message

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