# *
# * Where do you want the export backup files to go?
# * Note: it can be a remote directory.
# *

BKUP_DIRS="/orabkup01/export user@host:/orabkup02/export"

# *
# * How many simutaneous compress processes you want to run?
# * Rule of thumb is to set the number to be the same as the n of processors. 
# * Default is 3.
# *

NUM_PROCS=3

# *
# * What is the maximum time you allow the backup to run?
# * Backup will kill itself exceeding the maximum allowed time.
# * Default is 999999.
# *

MAX_SECS=999999

# *
# * Do you run schema by schema backup or full backup?
# * backup with "full=y rows=n" option will be performed for schema backup.
# * Default is full backup. 
# *

BKUP_BY_OWNER="N"

# *
# * IF it is schema backup, do you want backup ONLY those specified schemas
# * OR ALL schemas EXCEPT those excluded?
# *

# OWNER_ONLY=
# OWNER_EXCLUDE="'SYS','EMG'"

# *
# * What is the system password?
# * It is assumed the password is specified in a password file by
# * SYSTEMPASS=<the system password>.
#
# * You can use one of the three forms:
#
# * In the first form, the password is derived from password file,
# * which is derived from ORACLE_HOME, which is derived from ORATAB.
#
# * In the second form, the password file is specified directly.
#
# * In the third form, the password is specified directly, which I would
# * not recommend except for quick testing purpose.
# *

# *
# * First form:
# *

ORATAB=/var/opt/oracle/oratab
ORACLE_HOME=$(sed -n "s/^$ORACLE_SID:\([^:]*\):.*$/\1/p" $ORATAB)
eval $(sed -n "/^SYSTEMPASS=.*/{p; /^/q;}" $ORACLE_HOME/../../.ora_${ORACLE_SID}_passwd.ksh)

# *
# * Second form:
# *

# eval $(sed -n "/^SYSTEMPASS=.*/{p; /^/q;}" <password file>)
 
# *
# * Third form:
# *

# SYSTEMPASS=<the system password>

# *
# * What export options do you use?
# *

EXP_OPTS="userid=system/$SYSTEMPASS buffer=5000000 compress=n consistent=n constraints=y direct=y grants=y indexes=y recordlength=65000"

# *
# * What command do you use to compress a file to standard output?
# * Default is "compress -c".
# *

COMPRESS_C="/usr/bin/compress -c"
# COMPRESS_C="/usr/local/bin/gzip -c"
# COMPRESS_C="/usr/local/bin/bzip2 -c"

# *
# * What characterset do you use?
# * Default is US7ASCII
# *

# export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1