通过管道导出数据文件

[oracle@experiment backup]$mknod /oracle/backup/exppipe p

[oracle@experiment backup]$ exp scott/tiger wner=scott file=/oracle/backup/exppipe & gzipexp.dmp.gz

导出分三种模式，表，用户，数据库三种

导完之后删除管道

rm –rf /oracle/backup/exppipe

通过管道导入数据

[oracle@experiment backup]$mknod /oracle/backup/exppipe p

[oracle@experiment backup] imp scott/tiger file=/oracle/backup/exppipe fromuser=scott touser=scott &gunzip /oracle/backup/exppipe

导完后删除管道

rm –rf /oracle/backup/exppipe

使用管道导出数据脚本,导入脚本修改exp处即可

#UNIX下 ORACLE数据库通过 PIPE管道进行备份

LOGFILE=/oracle/backup/log/bakup_ora.log

export LOGFILE

DUMPDIR=/oracle/backup/archlog_node1

export DUMPDIR

exec >$LOGFILE 2>&1

echo

echo 'Begin at '`date`

echo

#clear old result file

cd $DUMPDIR

if [ -f exp.dmp.Z ]

then

echo "clear old result file"

rm -rf exp.dmp.Z

fi

#make pipe

mkfifo exp.pipe

chmod a+rw exp.pipe

#gain the dmp.Z file

#compress < exp.pipe > exp.dmp.Z &

gzip < exp.pipe > exp.dmp.Z &

exp system/oracle file=$DUMPDIR/exp.pipe wner=scott buffer=20000000

#su - oracle -c "exp system/oracle file=$DUMPDIR/exp.pipe wner=scott buffer=20000000"

echo

echo 'exp end at'`date`

echo

#rm pipe

rm exp.pipe

ITPub博客

exp imp管道技术的使用