- 论坛徽章:
- 0
|
环境:AIX5.3 KSH
bak.sql:
conn / as sysdba;
shutdown immediate;
!ymd=`date +"%y%m%d"`
!cp -p /pdmdata/ocu_8.0/oradata/wind8/* /pdmdata/$ymd;
!cp -p /oracle/ora92/dbs/orapwwind8 /pdmdata/$ymd;
!cp -p /oracle/ora92/dbs/spfilewind8.ora /pdmdata/$ymd;
!cp -p /oracle/admin/wind8/pfile/init.ora.3162006183535 /pdmdata/$ymd;
conn / as sysdba;
startup;
exit
she:
#!/usr/bin/ksh
ymd=`date +"%y%m%d"`
echo "make new backup diectory"
su - oracle -c "mkdir /pdmdata/$ymd"
if [[ $? != 0 ]]
then
echo "error!Please check first."
exit 1
fi
su - oracle -c "sqlplus /nolog @/tmpftp/bak.sql"
我执行at -f /tmpftp/she now目录能正确创建,但数据库文件没有预期的拷入/pdmdata/$ymd目录,而是全拷入到/pdmdata目录.这是怎么回事? |
|