Re: clone database by copying datafiles

Hello Hrishy,

  One big reason (of many): hot backup handles fractured blocks.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"hrishy" <hrishys_at_yahoo.co.uk> wrote in message news:4ef2a838.0402122246.55ea3e6_at_posting.google.com...
> Hi
>
> Placing tablespace's in backup mode would cause the headers of the
> datafile to be frozen.Enabling us to copy the underlying
> datafiles.While the writes to the datafile continues during the first
> change to a block during this period the entire block is recorded into
> the online redolog.Since the online redolog would anyway go into the
> archived log after my backup i was just wundering..can we clone a
> databse something like this..
>
> copy all the datafiles of the database without putting the tablespace
> in backup mode.And then switch the online logfiles archive them and
> copy them over too.Now use the usual procedure to clone the
> database..will this work ?
> if not can somebody explain me why..
>
> regards
> Hrishy
Received on Fri Feb 13 2004 - 01:36:37 CST