RE: Compressing Rman Disk Backups
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 29 Mar 2004 11:04:45 -0500
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@xxxxxxx]
Sent: Monday, March 29, 2004 10:57 AM
To: oracle-l@xxxxxxxxxxxxx
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.
----- Original Message -----
From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
