Re: student question: incremental backups (level 0 and level 1)

From: obakesan <pellicleundies_at_hotmail.com>
Date: Thu, 26 Jun 2008 11:16:02 GMT
Message-ID: <STK8k.68$zr1.28@read4.inet.fi>


Hi

ok ... things are gradually being revealed ...

In article <lkm664900qskls1v784bq0qug68odskm5i_at_4ax.com>, sybrandb_at_hccnet.nl wrote:
>On Thu, 26 Jun 2008 04:57:54 GMT, pellicleundies_at_hotmail.com
>(obakesan) wrote:
>
>>so perhaps a level 0 is as near as damit a full tablespace copy ...
>
>It is not.
>'Empty' blocks will not be copied. Empty blocks means blocks without a
>SCN. A block which has been used at least once has a SCN and will be
>copied.

so then, does this SCN get updated or invalidated at say a truncate table?

See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer Motorcyclist and dingbat blog: http://cjeastwd.blogspot.com/

please remove undies for reply Received on Thu Jun 26 2008 - 06:16:02 CDT

Original text of this message