export ORACLE_HOME=/oracle/oracle11g $ORACLE_HOME/bin/sqlplus "sys/sys@KPNDB as sysdba" <<EOF spool $ORACLE_HOME/DBA_SCRIPTS/pre-freeze.log; alter database begin backup; spool off; EOF