通过管道导出数据文件
[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博客 ” ,链接:http://blog.itpub.net/7862652/viewspace-709968/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7862652/viewspace-709968/