Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
#!/bin/bash
# script: prod1_export_full_db_1.sh (renamed from 35_macosx_prod1_export_full_db_1.sh)
# Features: This shell script performs a full database export to the /Volumes/backup location.
# Note: This script only needs scheduled as a CRON job if the same task has not
# been scheduled via an OEM job.
#
# Script Sequence#: 35
# Used By: CRON job via oracle UNIX account
# Usage:
# ******** Full Oracle Database Export nightly at 11:50PM ********
# 50 23 * * 0-6 /Volumes/u01/server_scripts/prod1_export_full_db_1.sh
# Copyright 2002 by .com Solutions Inc.
#
# ---------------------- Revision History ---------------
# Date By Changes
# 10-01-2001 dsimpson Initial Release
# 04-29-2002 dsimpson Added NLS_LANG environment variable
# to avoid EXP-0009 errors during export.
# 05-10-2002 dsimpson Updated to use oracle UNIX account.
# This output file was created by Installgen version 1.38 on Sat Nov 23 07:13:32 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
# define globally used paths/variables
PATH=/bin:/sbin:/usr/bin:/usr/sbin:.
ORACLE_BASE=/Users/oracle/v920
ORACLE_HOME=/Users/oracle/v920
ORACLE_OWNER=oracle
ORACLE_OWNER_PATH=/Users/oracle
ORACLE_GROUP=dba
PATH=$PATH:$ORACLE_HOME/bin
SRCHOME=$ORACLE_HOME
ORACLE_SID=prod1
CLASSPATH=$ORACLE_HOME/DBCreate/oradev/classes/orapts.jar:$ORACLE_HOME/jdbc/lib/classes12.zip:$CLASSPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
DYLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$DYLD_LIBRARY_PATH
ORAENV_ASK=NO
TNS_ADMIN=$ORACLE_HOME/network/admin
TERM=vt100
NLS_LANG=AMERICAN_AMERICA.US7ASCII
export PATH ORACLE_BASE ORACLE_HOME SRCHOME ORACLE_SID CLASSPATH LD_LIBRARY_PATH DYLD_LIBRARY_PATH ORACLE_OWNER TNS_ADMIN TERM NLS_LANG
# the following ulimit parameters are required by the Oracle database on Mac OS X
ulimit -c unlimited
ulimit -d unlimited
ulimit -s 65536
ulimit -u 500
ulimit -n 10000
# override default client set used for scripts - use database char set for exports
NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
export NLS_LANG
# log into the database and perform a full database export to the /Volumes/backup directory
#su - oracle -c "$ORACLE_HOME/bin/exp
$ORACLE_HOME/bin/exp USERID='admin/zx-vnm' FILE=/Volumes/backup/prod1_full_daily.dmp COMPRESS=Y DIRECT=Y ROWS=Y CONSISTENT=Y FULL=Y
