Oracle APEX application and workspace backup script - Revision history

Ittichai at 13:55, 5 August 2013

2013-08-05T13:55:27Z

Ittichai at 19:45, 12 June 2013

2013-06-12T19:45:10Z

Ittichai: Created page with "

 ###################################################################### # Export the location of the APEX utility scripts # Use the scripts from the APEX download with same ..."

2013-06-12T19:40:35Z

Created page with "<pre> ###################################################################### # Export the location of the APEX utility scripts # Use the scripts from the APEX download with same ..."

New page

<pre>
######################################################################
# Export the location of the APEX utility scripts
# Use the scripts from the APEX download with same version of the APEX installation.
# If not, some java run errors may be experienced.
export APEX_UTIL_HOME=/project/engdw/scripts/APEX/utilities

# Export the CLASSPATH
export ORACLE_HOME=/opt/oracle/product/11.1.0/db_1
#export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc6.jar
export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc5.jar

# Setup environment variables
export BACKUP_LOC=/project/engdw/${ORACLE_SID}/APEX/backups
export CURRDATE=`date '+%Y''%m''%d''%H''%M'`

echo =========================================== | tee -a ${LOGFILE}
echo Start APEX applications export at `date` | tee -a ${LOGFILE}

DBHOST=il02dwdev1.comm.mot.com:1521:DEDW
USR="APEX_040200"
PASSW="Motapex123$"

# Perform exports
cd ${APEX_UTIL_HOME}
# java oracle/apex/APEXExport -db ${DBHOST} -user ${USR} -password ${PASSW} -workspaceid ${WKID} 2>&1 | tee -a ${LOGFILE}
java oracle.apex.APEXExport -db ${DBHOST} -user ${USR} -password ${PASSW} -instance 2>&1 | tee -a ${LOGFILE}
java oracle/apex/APEXExport -db ${DBHOST} -user ${USR} -password ${PASSW} -expWorkspace 2>&1 | tee -a ${LOGFILE}

# Archive and zip all fxxx.sql files generated from the APEX export.
echo Compressing all .sql files to ${BACKUP_LOC}/${CURRDATE}.tar.gz
cd ${APEX_UTIL_HOME}
tar cvf - ./*.sql | gzip -c > ${BACKUP_LOC}/${CURRDATE}.tar.gz

# Remove all fxxx.sql files
rm -rf ${APEX_UTIL_HOME}/*.sql

echo End APEX applications export at `date` | tee -a ${LOGFILE}

cat ${LOGFILE} >> ${BATCH}/${ORACLE_SID}/daily${DATE}.log

</pre>

[[Categegory: APEX]]

@@ Line 17: / Line 17: @@
 echo Start APEX applications export at `date` | tee -a ${LOGFILE}
-DBHOST=host:port:SID
+DBHOST="host:port:SID"
 USR="APEX_040200"
-PASSW="PWD$"
+PASSW="PWD"
 # Perform exports

@@ Line 1: / Line 1: @@
 <pre>
 ######################################################################
-# Export the location of the APEX utility scripts
+# The export files will be automatically placed at the location of the APEX utility scripts
-# Use the scripts from the APEX download with same version of the APEX installation.
+# Use the scripts from the APEX download with same version of the APEX installation. If not, some java run errors may be experienced.
-# If not, some java run errors may be experienced.
+export APEX_UTIL_HOME=/u01/scripts/APEX/utilities
 # Export the CLASSPATH
-export ORACLE_HOME=/opt/oracle/product/11.1.0/db_1
+export ORACLE_HOME=/u01/oracle/product/11.2.0/db_1
 #export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc6.jar
 export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc5.jar
 # Setup environment variables
-export BACKUP_LOC=/project/engdw/${ORACLE_SID}/APEX/backups
+export BACKUP_LOC=/u01/${ORACLE_SID}/APEX/backups
 export CURRDATE=`date '+%Y''%m''%d''%H''%M'`
@@ Line 18: / Line 17: @@
 echo Start APEX applications export at `date` | tee -a ${LOGFILE}
-DBHOST=il02dwdev1.comm.mot.com:1521:DEDW
+DBHOST=host:port:SID
 USR="APEX_040200"
-PASSW="Motapex123$"
+PASSW="PWD$"
 # Perform exports
 cd ${APEX_UTIL_HOME}
 java oracle.apex.APEXExport -db ${DBHOST} -user ${USR} -password ${PASSW} -instance 2>&1 | tee -a ${LOGFILE}
 java oracle/apex/APEXExport -db ${DBHOST} -user ${USR} -password ${PASSW} -expWorkspace 2>&1 | tee -a ${LOGFILE}
@@ Line 37: / Line 35: @@
 echo End APEX applications export at `date` | tee -a ${LOGFILE}
 </pre>
-[[Categegory: APEX]]
+[[Category: APEX]]