or, roll up your sleeves, create a test case, start
dumping some blocks and diff'ing them, dump some logs
and examine them.
mmm, block dumps.
#include caffeine.h
Pd
- "Mercadante, Thomas F"
<thomas.mercadante_at_labor.state.ny.us> wrote:
> yeah, what Jared said.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> From: Jared Still [mailto:jkstill_at_cybcon.com]
> Sent: Thursday, March 25, 2004 10:12 AM
> To: Oracle-L Freelists
> Subject: Re: About Hot backup.
>
>
> As always, both.
>
> Just more of it will be written in the redo log
> than normal if the tablespace is in backup mode.
>
> IIRC the first time a block is written to when a
> tbs is in backup mode, the entire block is written
> to the redo log, which is not normally done.
>
> This is so that recovery can take place in the case
> of a block split during backup of the datafile.
>
> A block split can occur when the blocksize of the
> datafile and the blocksize of the database are
> different, and oracle is updating a block at the
> same time one or more (but not all) of the OS blocks
>
> that make up the database block is being written to
> the backup medium.
>
> Following that initial full block write to redo,
> deltas of that block are written to the redo.
>
> There is no doubt a lot more underlying detail, but
> that is the gist of it.
>
> This is all moot if using RMAN though, as
> tablespaces
> are not put into backup mode in that case.
>
> HTH
>
> Jared
> On Thu, 2004-03-25 at 06:37, Senthil Kumar wrote:
> > Hi,
> >
> > I have a doubt.
> > When I'm taking the hot backup, where the new data
> will be written. In the
> > datafile or in the redologs?.
> >
> > TIA
> > Ram
> >
> >
>
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
> > To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
> >
>
>
>
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>
>
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Mar 25 2004 - 14:54:32 CST
