Export of GEMS database

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s