看看sh哪里出错了,

显示全部楼层 · 2007-10-20 08:38:44

#!/bin/sh
#
scritp:coldbak
#
create:thomasliu
#
date:20080304
#
desc

ffline full backup database

#
sqlplus start
$ORACLE_HOME/bin/sqlplus sys/test@w1 as sysdba
#
connect database
#
shutdown database
shutdown immediate;
#
quit sqlplus
exit
#
copy datafile
cp $ORACLE_DATA/*.dbf $ORACLE_BASE/backup
#
copy control file
cp $ORACLE_DATA/*.ctl $ORACLE_BASE/backup
#
copy log file
cp $ORACLE_DATA/*.log $ORACLE_BASE/backup
#
sqlplus start
$ORACLE_HOME/bin/sqlplus sys/test@w1 as sysdba
#
startup database
startup;

千问 · 2007-10-20 08:38:44

1、没有export
2、
$ORACLE_HOME/bin/sqlplus sys/test@w1 as sysdba <<EOF
shutdown immediate;
exit
EOF

千问 · 2007-10-20 08:38:44

调试几把，看哪报错了，再来修改