Originally posted by: SystemAdmin
Here is the script:
#!/bin/ksh -x
-
Subject: Run a oracle Export dump and backup to a tape
cd /oraPump/backup
echo "********** Oracle DB Backup starts at "$(date) >> log/BaanExpdp.log
-
a full schema
-
expdp baandb/##### directory=data_pump_baandb dumpfile=expBaan.dmp logfile=expBaan.log
expdp baandb/bbaann05 parfile=baan201610.par
grep " GB" expBaan201.log | sed "s/using BLOCKS method:/database size on $(date +'%d-%m-%Y') /" >> log/BaanExpdp.log
grep "estimation" expBaan201.log | sed "s/Total estimation using BLOCKS method:/$(date +'%d-%m-%Y') /" >> log/sizeDB.log
for i in expBaan*.*;
do mv ${i} ${i}$(date +%Y%m%d%H%M)
done
-
ls expBaan*.* | cpio -ovC512 >/dev/rmt0.1
tar -cvf /dev/rmt0.1 exp*.* >> log/BaanExpdp.log 2>&1
find data -name 'expBaan*.*' -mtime +7 -exec rm {} \;
find /remote/solar/flash_recovery/BAAN/data -name 'expBaan*.*' -mtime +7 -fstype nfs -exec rm -f {} \;
echo "Backup ends at "$(date) >> log/BaanExpdp.log
-
Adios!
#AIX-Forum