Database Backup and Recovery (MOSC)

MOSC Banner

recover database using backup controlfile until cancel; in the script is not working, but if it is r

edited Mar 7, 2013 4:49AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
Here are some sql steps in the xxx.ksh script, this script is always failed at recover database using backup controlfile until cancel;

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center