Skip to content

Instantly share code, notes, and snippets.

@asvignesh

asvignesh/oracle_post.sh

Created February 8, 2020 12:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save asvignesh/787407b6a575abc9a9c6178dc27f2895 to your computer and use it in GitHub Desktop.
Save asvignesh/787407b6a575abc9a9c6178dc27f2895 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle database pre and post script for Nimesa
Raw
oracle_post.sh
export ORACLE_HOME=/oracle/oracle11g
$ORACLE_HOME/bin/sqlplus / as sysdba <<EOF
spool $ORACLE_HOME/log/backup.log;
alter database end backup;
spool off;
EOF
Raw
oracle_pre.sh
export ORACLE_HOME=/oracle/oracle11g
$ORACLE_HOME/bin/sqlplus / as sysdba <<EOF
spool $ORACLE_HOME/log/backup.log;
alter database begin backup;
spool off;
EOF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment