pre-freeze-script.sql (Oracle)

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

Loading...