Re: compressed backup - is this a reasonable size

  • From: Jason Heinrich <jheinrichdba@xxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx
  • Date: Wed, 22 Apr 2009 09:37:31 -0500

Yes, RMAN backup compression is typically quite good.  I've had a 2.4 TB
database backed up into <700 MB.  The downside is that restoring the
compressed backup set can take a lot more time, which is particularly
irritating if you only need to restore a single datafile.

Of course, you should test the restore to prove that it was successful.

--
Jason Heinrich


On Wed, Apr 22, 2009 at 8:36 AM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>wrote:

>  Just ran the following command.  This is our first RMAN backup.  It
> backed up a 17G database into about 3G of files.  Is this reasonable?????
>
> backup as compressed backupset database plus archivelog delete input;
>
> Backup states it finished normally.
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>

Other related posts: