To action the request to create a full daytime export on the GEMS database on LSC3. I first deleted the previous export from ‘/tmp/exports’ to create the needed 7.7GB.
Then I navigated to ‘/ad00/orabase/admin/scripts/exports’ and checked there was a directory called ‘exp_gems_logs’. As GEMS is quite small, and the customer wants a ‘daytime’ export so not to interfere with the evening backups, I ran the export at the command line with ‘./ exp_gems.sh’.
Thirty minutes later the request was complete.
exp_gems.sh
#!/usr/bin/ksh
# Script : exp_gems.sh
DAY=`date '+%d%m%y'`
EXLOG=/ad00/orabase/admin/scripts/exports/exp_gems_logs/exp_gems${DAY}.log
export EXLOG
echo "Starting export of gems database - `date`" > $EXLOG
ORACLE_SID=gems
ORAENV_ASK=NO
. oraenv
ORAENV_ASK=
exp parfile=/ad00/orabase/admin/scripts/exports/exp_gems.par >> $EXLOG
echo "End of export of gems database - `date`" >> $EXLOG
exp_gems.par
userid=system/gems123
buffer=10000000
full=y
file=/tmp/exports/exp_gems.dmp
log=/ad00/orabase/admin/scripts/exports/exp_gems_logs/exp_gems.log
compress=n
consistent=y
Database Consultant 