| Advertise on warmetal.nl! Click for more information about advertising here. |
Did you find this website useful? Did I save you a lot of time? |
|
BACKBACKUPDIR=/var/backup/oracle/schemadump HOSTNAME=`hostname` DATESTAMP=$(date +%Y%m%d%H%M) export ORACLE_HOME=/opt/oracle/product/10.2 DUMP=$BACKBACKUPDIR/$DATESTAMP-${HOSTNAME}-Oracle.dmp LOG=$BACKBACKUPDIR/$DATESTAMP-${HOSTNAME}-Oracle.log # Connect to the database instance and make the dump as system ${ORACLE_HOME}/bin/exp system/<oraclesyspasswd> FULL=y DIRECT=y FILE=$DUMP LOG=$LOG /usr/local/bin/tar -cf - $LOG $DUMP | /usr/bin/gzip > $BACKUPFILE rm $LOG rm $DUMP
Or without a password in the script:
${ORACLE_HOME}/bin/exp \'/ as sysdba\' FULL=y DIRECT=y FILE=$DUMP LOG=$LOG
Discussion