Re: rman backup should be smaller than the database ????

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 14 Nov 2007 22:20:21 +0100
Message-ID: <473B6695.8020701@gmail.com>

fitzjarrell_at_cox.net schrieb:
> On Nov 14, 10:33 am, newhorizon <mehmete..._at_gmail.com> wrote:

>> I am glad   put the command for the rman backup.
>>
>> I really appreciate the comments on adding the achivelog  in the
>> backupset.
>>
>> What are your thoughts about shrinking the tables before the backup ?

>
> I can't see that such an act would benefit you in terms of the backup
> size. A shrink will only take away unused space (that above the HWM),
> not free space located below the high water mark, so you might save a
> few blocks of space per table, but it likely won't be appreciable.
>
> I can't recommend it, but others may have differing opinions.
>
>
> David Fitzjarrell
>

I agree with your recommendation, however, if you refer to shrink in sense of "ALTER TABLE ... SHRINK ...", then it does free space below HWM .

Best regards

Maxim Received on Wed Nov 14 2007 - 15:20:21 CST