recover database using backup controlfile until cancel; in the script is not working, but if it is r
sqlplus -s "/ as sysdba" <<_EOF
whenever sqlerror exit
startup mount ;
alter database backup controlfile to '/home/oracle/controlbak.ctl';
shutdown abort;
startup mount pfile=/orabase/app/oracle/product/db11g/dbs/initcrsp.ora;
recover database using backup controlfile until cancel;
AUTO
alter database open resetlogs;
exit;
Here is the error in the alert log
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
started logmerger process
Wed Mar 06 05:25:34 2013
Parallel Media Recovery started with 12 slaves