Re: Compressing Rman Disk Backups

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Mon, 29 Mar 2004 18:56:31 +0300
Message-ID: <03c101c415a6$67a88bb0$6df923d5@porgand>

You can also configure rman to create backup pieces not larger than let say 10GB.

You can use maxpiecesize in backup command to limit the backup piece sizes, Oracle will split them automatically. Then you manually compress these pieces (you can check with fuser whether rman still has the file open or not).

I haven't tried to a rman backup to a pipe, in theory you could set backup piece name to a constant pipe location, but I remember from somewhere that you can't do that (or do have problems with it).

Tanel.

Original Message ----- From: "Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us> To: <oracle-l_at_freelists.org> Sent: Monday, March 29, 2004 6:19 PM Subject: Compressing Rman Disk Backups

> All,
>
> I am attempting to perform Rman disk backups on a data warehouse. While
the
> disk backup runs fine, the size of the output files are, of course, huge.
> What I would like to do is to pipe the output of the Rman backup while it
is
> running to something like Gzip so that the file gets created compressed.
My
> other option is to break the backup into a tablespace by tablespace
> multi-Rman run process and gzip or compress the files in between each
step.
>
> Anybody found a way to do this?
>
> thanks
>
> PS - Oracle 9.2.0.3 on Sun Unix.
>
> Tom Mercadante
> Oracle Certified Professional
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Mar 29 2004 - 09:53:04 CST