Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When can the size of RMAN Level 0 shrink?
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 DBAReceived on Fri May 26 2006 - 05:21:31 CDT