#!/bin/bash
/bin/su - oracle -c "echo $(date) >> /u01/app/oracle/snapshot.log"
/bin/su - oracle -c "/u01/app/oracle/product/11.2.0/xe/bin/sqlplus /nolog @/u01/app/oracle/suspend.sql >> /u01/app/oracle/snapshot.log"
/usr/sbin/post-thaw-script
#!/bin/bash
/bin/su - oracle -c "echo $(date) >> /u01/app/oracle/snapshot.log"/bin/su - oracle -c "/u01/app/oracle/product/11.2.0/xe/bin/sqlplus /nolog @/u01/app/oracle/resume.sql >> /u01/app/oracle/snapshot.log"
/u01/app/oracle/suspend.sql
connect / as sysdba;
ALTER SYSTEM SUSPEND;
exit;
/u01/app/oracle/resume.sql
connect / as sysdba;
ALTER SYSTEM RESUME;
exit;
/u01/app/oracle/.bash_profile
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export PATH=$ORACLE_HOME/bin:$PATH