Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Compressing Rman Disk Backups

RE: Compressing Rman Disk Backups

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Tue, 30 Mar 2004 07:37:05 -0500
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FEDAD5A7A@exchsen0a1ma>


Lex,

that interface is available in 9i also. but it *only* supports sending rman commands and rman output of those commands. I was looking for piping the backup set to gzip to compress it.

thanks for the reply!!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl] Sent: Tuesday, March 30, 2004 2:29 AM
To: oracle-l_at_freelists.org
Subject: RE: Compressing Rman Disk Backups

from the 10g documentation:

RMAN Pipe Interface



The RMAN pipe interface is an alternative method for issuing commands to RMAN and receiving the output from those commands. With this interface, RMAN obtains commands and sends output by using the DBMS_PIPE PL/SQL package. RMAN does not read or write any data using the operating system shell. By using this interface, it is possible to write a portable programmatic interface to RMAN.

The pipe interface is invoked by using the PIPE command-line parameter. RMAN uses two private pipes: one for receiving commands and the other for sending output. The names of the pipes are derived from the value of the PIPE parameter. For example, you can invoke RMAN with the following command:

% rman PIPE abc TARGET SYS/oracle_at_trgt

RMAN opens the two pipes in the target database: ORA$RMAN_ABC_IN, which RMAN uses to receive user commands, and ORA$RMAN_ABC_OUT, which RMAN uses to send all output back to RMAN.

All messages on both the input and output pipes are of type VARCHAR2.

Note that RMAN does not permit the pipe interface to be used with public pipes, because they are a potential security problem. With a public pipe, any user who knows the name of the pipe can send commands to RMAN and intercept its output.

See Also:
"Executing RMAN Commands Through a Pipe" to learn how to execute RMAN commands through a pipe

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jeremiah Wilton Sent: maandag 29 maart 2004 18:07
To: oracle-l_at_freelists.org
Subject: RE: Compressing Rman Disk Backups

On Mon, 29 Mar 2004, Norris, Gregory T [ITS] wrote:

> Unfortunately RMAN will "helpfully" remove the named pipe before
> creating it's file, so this doesn't work.

At one point a couple years ago I met the lead developer for RMAN, and mentioned this. He agreed that it should check for the existence of a named pipe rather than clobbering it, and expressed the intention to fix this defect in a future version. Has anyone checked to see if this still happens in 10g?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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 Tue Mar 30 2004 - 06:33:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US