[各位大侠帮忙]编写脚本,在sqlplus中实现一个功能,需要交互,如何自动实现,详见正文
编写脚本如下:
sqlplus / as sysdba << EOF
shutdown immediate;
startup;
recover database using backup controlfile until cancel; ----此处需要输入CANCEL,请各位大侠帮忙
disc;
quit;
EOF" >> $LOGFILE 2>&1
试了下面方法不行:
sqlplus / as sysdba << EOF
shutdown immediate;
startup;
recover database using backup controlfile until cancel << EOF
CANCEL
EOF
disc;
quit;
EOF" >> $LOGFILE 2>&1
请各位帮忙,多谢!!!!