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@xxxxxxxxxxxxxxxxx> wrote: > yeah, what Jared said. > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > From: Jared Still [mailto:jkstill@xxxxxxxxxx] > 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@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at > //www.freelists.org/archives/oracle-l/ > > FAQ is at > //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at > //www.freelists.org/archives/oracle-l/ > FAQ is at > //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at > //www.freelists.org/archives/oracle-l/ > FAQ is at > //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------