SHIFT

--- Sjoerd Hooft's InFormation Technology ---

User Tools

Site Tools


Sidebar

Recently Changed Pages:

View All Pages


View All Tags


LinkedIn




WIKI Disclaimer: As with most other things on the Internet, the content on this wiki is not supported. It was contributed by me and is published “as is”. It has worked for me, and might work for you.
Also note that any view or statement expressed anywhere on this site are strictly mine and not the opinions or views of my employer.


Pages with comments

View All Comments

oracledump

Oracle Dump

Normally when creating backups you should prefer a RMAN backup. However, this is not the way to go when you want to transfer a database across an operating system. So say you have an Oracle database on AIX and you want to transfer it to Windows, you should use another method, simply being a dump. I have gathered here the required commands and variables you need just for the dump. If you need a script that creates this, use RMAN backup as an example and work from there.

Oracle Dump

BACKBACKUPDIR=/var/backup/oracle/schemadump
HOSTNAME=`hostname`
DATESTAMP=$(date +%Y%m%d%H%M)
export ORACLE_HOME=/opt/oracle/product/10.2
DUMP=$BACKBACKUPDIR/$DATESTAMP-${HOSTNAME}-Oracle.dmp
LOG=$BACKBACKUPDIR/$DATESTAMP-${HOSTNAME}-Oracle.log
 
# Connect to the database instance and make the dump as system
${ORACLE_HOME}/bin/exp system/<oraclesyspasswd> FULL=y DIRECT=y FILE=$DUMP LOG=$LOG
/usr/local/bin/tar -cf - $LOG $DUMP | /usr/bin/gzip > $BACKUPFILE
rm $LOG
rm $DUMP

Or without a password in the script:

${ORACLE_HOME}/bin/exp \'/ as sysdba\' FULL=y DIRECT=y FILE=$DUMP LOG=$LOG
You could leave a comment if you were logged in.
oracledump.txt · Last modified: 2021/09/24 00:25 (external edit)