Re: RMAN compression - is this reasonable?

From: Adam Musch <ahmusch_at_gmail.com>
Date: Thu, 18 Jul 2013 21:02:46 -0500
Message-Id: <59B10997-1901-4054-8019-E2DFB5FFD110_at_gmail.com>

Was this development database built by import/impdp? In other words, is there very little internal free space in the segments ?

Sent from my iPhone

On Jul 18, 2013, at 2:24 PM, "Schauss, Peter (ESS)" <peter.schauss_at_ngc.com> wrote:

> This is Oracle 11.2.0.3 running on Windows Server 2003.
> I am in the process of setting up RMAN backups. The relevant part of my backup script says:
>
> "backup as compressed backupset database plus archivelog;"
>
> EM says that the database is about 150 gb which seems to correspond roughly to the sum of the data file sizes. To get an idea of approximately how much of that space is used I ran:
>
> select sum(bytes)/1000000000 from dba_segments;
>
> and got about 63 gb. This is a development database so I would not expect a large amount of data in the archive logs.
>
> The sum of the backup file sizes is just under 10 gb.
>
> Based on this, it looks like I am getting a compression ratio of about 6 to 1. Is this typical for the default compression algorithm?
>
> Thanks,
> Peter Schauss
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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

Received on Fri Jul 19 2013 - 04:02:46 CEST