RE: compressed backup - is this a reasonable size

From: <Joel.Patterson_at_crowley.com>
Date: Thu, 23 Apr 2009 09:18:02 -0400
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA02A95496_at_JAXMSG01.crowley.com>


Be sure to keep your redundancy policy to at least one day... if you are deleting your input. It takes at least one archive log to restore the database, so you want them copied of to tape or someplace before they disappear.

No?

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Riku Räsänen Sent: Wednesday, April 22, 2009 10:11 AM To: JBECKSTROM_at_gcrta.org
Cc: oracle-l-freelists; oracle-db-l
Subject: Re: compressed backup - is this a reasonable size

It depends greatly.

I'd say on the average the compression is from 1:5 to 1:10, though I have seen compression of over 1:20.

Depends on the number of empty blocks (which RMAN does not read), how much repetition there is in the data and so on.

I'd say that from 17G to 3G is reasonable.

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

-- 
Riku Räsänen
Kantamestarit Oy
www.kantamestarit.fi


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


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 23 2009 - 08:18:02 CDT

Original text of this message