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

From: <fitzjarrell_at_cox.net>
Date: Wed, 14 Nov 2007 07:36:52 -0800
Message-ID: <1195054612.536526.192610@k79g2000hse.googlegroups.com>

On Nov 14, 9:22 am, newhorizon <mehmete..._at_gmail.com> wrote:
> I am using RMAN backup.
>
> When I get the hot RMAN backup using the following commands.
>
> BACKUP DATABASE PLUS ARCHIVELOG;
> BACKUP CURRENT CONTROLFILE;
>
> I was expecting to see that the rman backup would be smaller since it
> is copying the used blocks for the database. Should I shrink the
> tables before the backup ?

You've neglected to consider that you're adding the archivelogs to the mix; a BACKUP DATABASE should likely be smaller than the actual database, but adding in the archivelogs expands that size considerably.

David Fitzjarrell Received on Wed Nov 14 2007 - 09:36:52 CST