pre-freeze-script.sql (Oracle)

Updated

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