全库导出时报错误

liangkaizhen@

众位大侠,请教一个问题:
就是在solaris系统上,oracle 8.1.6做全库导出,导出教本如下:
#!/bin/csh
set ORACLE_BASE=/data3/oracle
set ORACLE_HOME=$ORACLE_BASE/product/8.1.6
setenv NLS_LANG american_america.us7ascii
setenv LD_LIBRARY_PATH $ORACLE_HOME/libORACLE_HOME/network/libORACLE_HOME/plsql/libORACLE_HOME/rdbms/lib
setenv PATH $ORACLE_HOME/bin:/bin:/usr/sbin:/usr/local/bin:/usr/bin:/usr/ccs/binpt/bin
cd /oradata3/tasks/expbill
set rq=` date +"%Y%m%d"`
set rq1=01
set rq2=02
set rq3=03
#set rq1=` date +"%Y%m%d"`
#set rq2=` date +"%Y%m%d"`
#exp obs61/obs61@obs61 owner=obs61  file=./fulldata/expfull$rq$rq1.dat log=./log/expfull$rq$rq2.log buffer=3200000
exp system/manager@obs61 full=y file=./fulldata/expfull$rq$rq1.dat,./fulldata/expfull$rq$rq2.dat,./fulldata/expfull$rq$rq3.dat files
ize=2GB log=./log/expfull$rq.log

cd /oradata3/tasks/expbill/fulldata
find ./ exp*.* -mtime +2 -exec rm {} \;
# 压缩导出文件
cd /oradata3/tasks/expbill/fulldata
compress exp*.dat

执行导出时,系统提示如下错误About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions段错误 (（主存储器）信息转储):

这是什么原因哪?

liangkaizhen@

众位大侠有谁曾经碰到过这样的问题吗?挺急的.期待高人指点?

zhen917

这种错误我没有遇到过。不过我师傅给过我一个脚本。你可以看看。
# Created By Kurt Z on 20050806
# You can edit ONLY this line for real application:
# these envionment variable can be modified by user. for example, if you hope the backup dump files to place into the path:
# /oradisk1/backupdb, then shoud write this line like this "export exppath=/oradisk1/backupdb"
export exppath=/data/backup



# !! NO EDIT BELOW !! NO EDIT BELOW !! NO EDIT BELOW !! NO EDIT BELOW !! NO EDIT BELOW !! NO EDIT BELOW !! NO EDIT BELOW !! NO EDIT BELOW !!

export ORACLE_SID=hz2004
export exptime=`date +%Y%m%d`
export ORACLE_HOME=/oracle/app/oracle/product/920
export PATH=$PATH:/oracle/app/oracle/product/920/binHOME/bin


if [ "`date +"%u"`" = "6" ]; then
   echo "Today is Saturday, no bakcup the database!";
else
   if [ "`date +"%u"`" = "7" ]; then
      echo "Today is Sunday, no bakcup the database!";
   else
      su - oracle "-c /oracle/app/oracle/product/920/bin/exp sys/oracle@hz2004 file=$exppath/data1_$exptime.dmp,$exppath/data2_$exptime.dmp,$exppath/data3_$exptime.dmp,$exppath/data4_$exptime.dmp,$exppath/data5_$exptime.dmp,$exppath/data6_$exptime.dmp,$exppath/data7_$exptime.dmp,$exppath/data8_$exptime.dmp,$exppath/data9_$exptime.dmp,$exppath/data10_$exptime.dmp,$exppath/data11_$exptime.dmp,$exppath/data12_$exptime.dmp,$exppath/data13_$exptime.dmp,$exppath/data14_$exptime.dmp,$exppath/data15_$exptime.dmp,$exppath/data16_$exptime.dmp,$exppath/data17_$exptime.dmp,$exppath/data18_$exptime.dmp,$exppath/data19_$exptime.dmp,$exppath/data20_$exptime.dmp filesize=1500M log=$exppath/exp_$exptime.log GRANTS=y FULL=y INDEXES=y TRIGGERS=y FEEDBACK=1000";
   fi
fi   
# !! NO EDIT ABOVE !! NO EDIT ABOVE !! NO EDIT ABOVE !! NO EDIT ABOVE !! NO EDIT ABOVE !! NO EDIT ABOVE !! NO EDIT ABOVE !! NO EDIT ABOVE !!

弱智

我考，汗。。。。。

这种脚本也能拿出来？

liangkaizhen@

我试了一下,错误还是一样,不过还是要谢谢你.

macrodba

好象环境变量有利问题

rogershi

原帖由 "弱智" 发表：
我考，汗。。。。。

这种脚本也能拿出来？

至少也应该tar一下作个磁盘拷贝或者ftp到远程的机器上吧
只能看出这点不足, 老大能否给个范例, 或者还有哪些疏忽的地方, 谢谢!