Re: Q: export/import many files over 2GB limit

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Fri, 13 Jun 2003 10:38:56 +0200
Message-ID: <3ee98da1$0$6792$9b4e6d93@newsread4.arcor-online.net>

Hi there, at first thanks for your help. I'm "creating" the following script :

#! /bin/sh
. /etc/profile.d/oracle.sh

EXPORT_DIR=/backup/ora
export EXPORT_DIR
cd $EXPORT_DIR

#
MAXFILESIZE=1800m
export MAXFILESIZE

#

FILENAME1=$EXPORT_DIR/backup1_$ORACLE_SID.dmp
FILENAME2=$EXPORT_DIR/backup2_$ORACLE_SID.dmp
FILENAME3=$EXPORT_DIR/backup3_$ORACLE_SID.dmp
FILENAME4=$EXPORT_DIR/backup4_$ORACLE_SID.dmp
FILENAME5=$EXPORT_DIR/backup5_$ORACLE_SID.dmp

LOGFILE=$EXPORT_DIR/backup_$ORACLE_SID.log #
mv $FILENAME1 $FILENAME1.old
if [ -f $FILENAME2 ]
then
mv $FILENAME2 $FILENAME2.old
fi
if [ -f $FILENAME3 ]
then
mv $FILENAME3 $FILENAME3.old
fi
if [ -f $FILENAME4 ]
then
mv $FILENAME4 $FILENAME4.old
fi
if [ -f $FILENAME5 ]
then
mv $FILENAME5 $FILENAME5.old
fi

mv $LOGFILE $LOGFILE.old

#
# erstelle pipes
#

mkfifo exportpipeaa
mkfifo exportpipeab
mkfifo exportpipeac
mkfifo exportpipead
mkfifo exportpipeae

mkfifo wrkpipe
umask 000

#

dd if=exportpipeaa of=$FILENAME1 &
dd if=exportpipeab of=$FILENAME2 &
dd if=exportpipeac of=$FILENAME3 &
dd if=exportpipead of=$FILENAME4 &
dd if=exportpipeae of=$FILENAME5 &

#
dd if=wrkpipe|compress|split -b $MAXFILESIZE - exportpipe & #
exp "user/pass" file=wrkpipe full=y grants=y indexes=y compress=n buffer=4096000 LOG=$LOGFILE
#

rm wrkpipe exportpipea?

#
#
#

ps -ef|grep exportpipe|grep -vi grep|awk '{printf ("kill -9 %d; \n",$2)}'>kill.lst
chmod u+x kill.lst
sh kill.lst
rm kill.lst

But the export hangs in the middle of the second exportfile without any erros in any log. A "normal" Export runs without any errors. So there must all be ok with the database.
Any ideas ?

ralf

Ralf Bender wrote:
> Hi
>
> I'm using Oracle 8.1.7 on Linux.
>
> I want to export the full database, which has a size of 10 GB. Running
> export with parameter file to create files under the 2GB file limit
> works. But right now there not enough space to create all files.
>
> Is there a way to directly compress all created files? I found a way to
> do so with one file:
> /etc/mknod pipename p
> compress < pipename > newfilename.Z &
> exp <username>/<password> file=pipename
> rm -f pipename
>
> But how to with oracle parameter file a
>
Received on Fri Jun 13 2003 - 03:38:56 CDT