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: When can the size of RMAN Level 0 shrink?

Re: When can the size of RMAN Level 0 shrink?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 26 May 2006 12:21:31 +0200
Message-ID: <uild72t1ee3erg3r9ukaelif0qafk008vs@4ax.com>


On Fri, 26 May 2006 05:12:12 -0400, NetComrade <netcomradeNSPAM_at_bookexchange.net> wrote:

>My understanding is that RMAN lvl0 is _full_ backup of all datafiles
>whethere there is data in them or not. So is it safe to say that the
>only time an RMAN backup would shrink is when datafiles are dropped?
>This is a 9i db running on Windows
>.......
>We run Oracle 9iR2,10gR1/2 on RH4/RH3
>remove NSPAM to email

Evidently also when they are resized.
Rman will backup any block that has been 'touched' at least once. So it will backup empty blocks that have been occupied once. IIRC this is in the documentation.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri May 26 2006 - 05:21:31 CDT

Original text of this message

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