pre-freeze-script.sql (Oracle)

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

Loading...