How To Perform A EXP And Compress On The Fly

Actually I’m upgrading a database (Release 9.2.5.0) to 12c, It is a small database because of this I prefer perform a (traditional) exp and imp that upgrade to a 10g and after that upgrade to 12c.

The problem I have found is when generate the dmp file, the file system have 20 gigas of free space and the dmp file size is greater. There are some solutions, in my case I selected compress the dmp file while it is generated using a unix pipe. Here I show the script;

 
orange-3@> cat dumper.sh
#!/bin/ksh

export ORACLE_SID=FINAN
export ORACLE_HOME=/oracle/server/925

DIRECTORY=/dummy; export DIRECTORY
FILENAME=${DIRECTORY}/fichero_grande.dmp.gz; export FILENAME
LOG=${DIRECTORY}/fichero_grande.log; export LOG
PIPE=${DIRECTORY}/export_pipe.dmp; export PIPE

test -p ${PIPE} || mknod ${PIPE} p
chmod +rw ${PIPE}

cat $PIPE | /usr/bin/gzip > ${FILENAME} &
${ORACLE_HOME}/bin/exp log=${LOG} buffer=104857600 file=${PIPE} owner=FINANCIAL << EOF
financial/xxxxxxxxxx
EOF

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s