문서 ID: |
공지:1015589.6 |
제목: |
Script For Exporting With COMPRESS under UNIX |
유형: |
PROBLEM |
상태: |
PUBLISHED |
|
컨텐트 유형: |
TEXT/PLAIN |
생성 날짜: |
07-FEB-1996 |
마지막 갱신 날짜: |
09-MAY-2003 |
|
Problem Description:
====================
The following Unix shell script will pipe an Oracle export file through the
Unix compress utility to obtain a compressed export dump file.
#
# EXPORT WITH COMPRESS SCRIPT
# ---------------------------
#
# BEFORE RUNNING THIS SCRIPT, USE the mknod command to create a named pipe
# called /dev/PIPE.dmp (mknod is Unix command, PIPE.dmp is an arbitrary name).
# Then set environment variables for ORACLE_HOME, ORACLE_SID, and DUMPDIR, as
# well as PATH if needed.
# If you save the script as, say, exp_comp.sh, type
# % exp_comp.sh &
# at the Unix prompt to run it.
# WARNING: You must have unique names for each pipe if you have
# multiple concurrent executions of this script.
trap '' 1 # nohup
# Set these to appropriate values
ORACLE_HOME=
ORACLE_SID=
DUMPDIR=
# Customize PATH if needed
PATH=/bin:/usr/bin:${ORACLE_HOME}/bin:/usr/local/bin:/usr/lbin
export ORACLE_HOME ORACLE_SID PATH
LOGFILE=$DUMPDIR/exp${ORACLE_SID}.log
exec >$LOGFILE 2>&1
echo "Exporting $ORACLE_SID database. start `date`"
# Customize this as needed
exp system/manager GRANTS=Y FULL=Y INDEXES=Y COMPRESS=Y FILE=/dev/PIPE.dmp &
compress $DUMPDIR/exp$ORACLE_SID.dmp.Z &
. |
Technote
