export-oracle.txt

Delivered as text/plain

[ hide source ] | [ make this the default ]

File Contents

#!/bin/sh
HOME=/home/oracle
HZ=
LOGNAME=oracle
ORACLE_BASE=/ora8/m01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/8.1.7
PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
ORA_OWNER=oracle
ORACLE_SID=ora8
ORACLE_TERM=vt100
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/lib:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/sbin
SHELL=/bin/sh
TERM=vt100
TZ=US/Eastern

# Change these!
SERVICE_NAME=service_name
DATABASE_PASSWORD=database_password

exportdir=/ora8/m02/oracle-exports
file=$exportdir/$SERVICE_NAME.dmp
mv -f $file.gz $file.old.gz
su - $ORA_OWNER --command="exp $SERVICE_NAME/$DATABASE_PASSWORD file=$file owner=$SERVICE_NAME consistent=Y direct=Y"
gzip $file