Hi friends,
My database is around 40 GB and i want to do a export of the database,but since i have no sufficient space in my system.Can u please help me how i should go about.
I am using oracle 8.1.6 on solaris 5.7.
regards
anandkl
Printable View
Hi friends,
My database is around 40 GB and i want to do a export of the database,but since i have no sufficient space in my system.Can u please help me how i should go about.
I am using oracle 8.1.6 on solaris 5.7.
regards
anandkl
Just an Idea, you'll have to modify this code to pause it from OS, so that you take the piece to offline storage
## To export
mknod exp.dmp p # mkfifo on certain Unix flavours
split -b2047mexp scott/tiger file=exp.dmp record=n tables=tableX
## To Import
rm exp.dmp
mknod exp.dmp p
cat xaa xab xac xad >exp.dmp &
imp scott/tiger file=exp.dmp commit=y tables=tableX
Another option:
Use multiple dump file feature FILE=$P1/d1.dmp, $P2/d2.dmp,... FILESIZE=1GB
where P1,P2 are diffrent Paths where you have enough space
Assuming: You do not have big chunk of space to fit the whole dump on your device
Thanks friends,
can i use something like "compress", a command in unix.
help me on this command.
regards
anandkl
You can always use compress/gzip utilities to compress the dump files and make little more space. compress/gzip works unix just like winzip on windows.
read manual pages on compress..
$man compress
splitting and compressing :DCode:
unset TWO_TASK
ORACLE_BASE=/oracle; export ORACLE_BASE
ORACLE_HOME=/oracle/simp; export ORACLE_HOME
TNS_ADMIN=/oracle/simp/network/admin
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin:$PATH:/usr/lib/java/bin
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib:/usr/lib/java/lib
export CLASSPATH
if [ "$1" = "" ] ; then
echo "Uso: exportaBD.sh ORACLE_SID"
exit
fi
. /oracle2/backup/sh/$1.env
#########################################
#
export ORACLE_SID=$1
BACKUP_TOP=/oracle2/backup/$ORACLE_SID
PIPA=$BACKUP_TOP/dmp/export${ORACLE_SID}.pipe
#########################################
cd $BACKUP_TOP/dmp
mkdir log 2>/dev/null
echo `date`": Backing up instance $1" >> log/exportaBD$1.log
if [ ! -p $PIPA ]
then
mknod $PIPA p
fi
sleep 20
compress < $PIPA | split -b 2000m - export$1`date +"%Y%m%d"`- &
time exp ${username}/${password} compress=n buffer=12000000 file=${PIPA} log=log/$1`date +"%Y%m%d"`.log full=y consistent=y >> log/exportaBD$1.log 2>&1
Here's part of a script that you can use to compress the file while your export runs.
export PIP=/full_path/exp.pipe
export PAR=/full_path/parfile
# Create a pipe
mknod ${PIP} p
# Send pipe to dmp with compress #
nohup cat ${PIP} |compress -f > file_name.dmp.Z &
# Do the export #
${ORACLE_HOME}/bin/exp username/password file=${PIP}parfile=${PAR} 2> /dev/null
Hope that helps!
Jodie