#!/bin/sh
echo "\n" >> /disk1/backups/pcms/cronjob/backup_pcms_nt.err
echo `date` >> /disk1/backups/pcms/cronjob/backup_pcms_nt.err
echo " *** Starting Connect Script ..." >> /disk1/backups/pcms/cronjob/backup_pcms_nt.err
echo " *** Starting Export SQL ..." >> /disk1/backups/pcms/cronjob/backup_pcms_nt.err
ORACLE_HOME=/disk1/app/oracle/product/7.3.3
export ORACLE_HOME
ORACLE_SID=RTM
export ORACLE_SID
TNS_ADMIN=/disk1/app/oracle/product/7.3.3/network/admin
export TNS_ADMIN
cd /disk1/backups/pcms/cronjob
/disk1/backups/pcms/cronjob/backup_pcms_nt.sql >> /disk1/backups/pcms/cronjob/backup_pcms_nt.err 2>&1
echo `date` >> /disk1/backups/pcms/cronjob/backup_pcms_nt.err
echo " *** End Of Export. " >> /disk1/backups/pcms/cronjob/backup_pcms_nt.err
cd /disk1/backups/pcms/exports
FROM_FILE=exp_pcms_nt_complete.dmp
TO_FILE=`date | cut -c1-19 | sed 's/ /_/g'`
mv $FROM_FILE $TO_FILE".dmp"
/usr/bin/gzip *.dmp