Re: compressed backup - is this a reasonable size

From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Wed, 22 Apr 2009 10:27:25 -0500
Message-ID: <b32e774d0904220827i13898fe8jc168ca344c7db37a_at_mail.gmail.com>

Oops, I meant 700 GB. The compression was good, but not THAT good. :)

--
Jason Heinrich


On Wed, Apr 22, 2009 at 9:37 AM, Jason Heinrich <jheinrichdba_at_gmail.com>wrote:



> 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_at_gcrta.org>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

>>

>

>


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 22 2009 - 10:27:25 CDT