| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Compressing Rman Disk Backups
Tanel,
Thanks for the reply. I already am creating *.ctl, *.arc and *.dbf rman backup files, and I can (after the Rman run) do a compress *.ctl, *.arc and *.dbf. This works fine. It would be great to not have to do it in two steps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Tanel Põder [mailto:tanel.poder.003_at_mail.ee]
Sent: Monday, March 29, 2004 10:57 AM
To: oracle-l_at_freelists.org
Subject: Re: Compressing Rman Disk Backups
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.
> 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
> -----------------------------------------------------------------
>
-- 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 - 10:01:28 CST
 |
 |