Database Backup and Recovery (MOSC)

MOSC Banner

Database Down After running an Rman script

edited Jun 24, 2009 4:19AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
 Hi
My Oracle 10g database instance shutdown automatically and fails to startup again after I ran the following rman script:

  ORACLE_SID=INSISDB;export ORACLE_SID
  ORACLE_HOME=/oracle/product/10.2.0;export ORACLE_HOME
  DATE1=`date +%d%b%y%H%M`;export DATE1
  BKPBASE=/oracle/flash_recovery_area;export BKPBASE
  BKPDIR=$BKPBASE/OffBkp_$DATE1;export BKPDIR
  mkdir $BKPDIR
  chmod 777 $BKPDIR
  PATH=$ORACLE_HOME/bin:$PATH;export PATH

  # Initiating RMAN

  $ORACLE_HOME/bin/rman log=${BKPDIR}/rman_${ORACLE_SID}_OffsiteBkp_$DATE1.log <<EOF
  connect target /
  run{
  CONFIGURE CONTROLFILE AUTOBACKUP ON;
  SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$BKPDIR/Control_%F';

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