Thursday, April 20, 2006

Example script => backup spfile and controlfile

script1:

#/bin/sh
export ORACLE_SID=$1
export ORACLE_BASE=/oracle/product
export ORACLE_HOME=/oracle/product/10.2.0/db

DATE=`date +'%a'`
echo $ORACLE_SID

FILE='/EMC/backup/config/pfile.ora.'$1'.'${DATE}

/oracle/product/10.2.0/db/bin/sqlplus / as sysdba <
create pfile='${FILE}' from spfile;
exit
EOF


script 2:

#/bin/sh
export ORACLE_SID=$1
export ORACLE_BASE=/oracle/product
export ORACLE_HOME=/oracle/product/10.2.0/db

DATE=`date +'%a'`
echo $ORACLE_SID

FILE='/EMC/backup/config/controlfile.ora.'$1'.'${DATE}

/oracle/product/10.2.0/db/bin/sqlplus / as sysdba <
alter database backup controlfile to '${FILE}' reuse;
exit
EOF

No comments: