Database Down After running an Rman script
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';
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';
0