Oracle-L: RE: RMAN - Compressing using named piped

From: laura pena <lizzpenaorclgrp_at_yahoo.com>
Date: Tue, 30 Sep 2003 07:54:29 -0800
Message-ID: <F001.005D1852.20030930075429@fatcity.com>

I can use mknod and create a named pipe a head of time. I do this when I use the exp or imp utilites (just wondering if I can do same with RMAN):

export EXP_DIR="/oracle/export"
export PIPE_DIR="/oracle/export"
export PIPE_FILE="$PIPE_DIR/imp_pipe"
mydump="DBAFULL_090403.DMP.gz"
i=1
for db in voicelog authcode_cp authcode_user crd_user crd_cp vlsuper do

   echo $i
   rm -f ${PIPE_FILE}.$i
   mknod ${PIPE_FILE}.$i p
   echo `date`
   echo "Running gzip"
   nohup cat $EXP_DIR/$mydump | /usr/bin/gunzip -c > ${PIPE_FILE}.$i &    echo `date`
   echo "Running imp"

        imp system/$1 FROMUSER=$db TOUSER=$db file=${PIPE_FILE}.$i log=$db.imp.log buffer=1024000 rows=y indexes=n constraints=n feedback=1000 RESUMABLE=Y grants=n commit=y ignore=y     echo `date`
    echo "Done with imp for $i"
    i=`expr $i + 1`
done
echo "Import for Users complete"

"Orr, Steve" <sorr_at_rightnow.com> wrote:
Can you figure out what to name the pipe in advance? Is there a way to reliably determine what file name RMAN will create?

-----Original Message-----

Sent: Tuesday, September 30, 2003 8:45 AM To: Multiple recipients of list ORACLE-L

I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space.

Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? If someone has done this before, can you let me know how ?

My rman backups are 71g compresed they are 12g.

Thanks ahead of time.
-Lizz

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
--

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

Author: laura pena
INET: lizzpenaorclgrp_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Sep 30 2003 - 10:54:29 CDT