RE: Compressing Rman Disk Backups

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 30 Mar 2004 07:37:05 -0500

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@xxxxxxxxxxxxxx]
Sent: Tuesday, March 30, 2004 2:29 AM
To: oracle-l@xxxxxxxxxxxxx
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@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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jeremiah Wilton
Sent: maandag 29 maart 2004 18:07
To: oracle-l@xxxxxxxxxxxxx
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@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: