-
I'm trying to export an 8.0.6 database on the HP-UX 10.20 platform. The size of the export size is about to grow more than the max file size on the OS, and then fail. What i have to do? I would consider exporting tablespace by tablespace. What is the exact commands to do that?
Regards
Alexandre
In god i trust
-
Hello
You Can break up the export file into smaller files use export to a PIPE and have compress and split read the pipe. The result is a couple of 500meg compressed files that consistute the export. At 500meg, any utility can deal with this files and I can move them around easier.
#!/bin/csh -vx
setenv UID /
setenv FN exp.`date +%j_%Y`.dmp
setenv PIPE /tmp/exp_tmp_ora8i.dmp
setenv MAXSIZE 500m
setenv EXPORT_WHAT "full=y COMPRESS=n"
echo $FN
cd /nfs/atc-netapp1/expbkup_ora8i
ls -l
rm expbkup.log export.test exp.*.dmp* $PIPE
mknod $PIPE p
date > expbkup.log
( gzip < $PIPE ) | split -b $MAXSIZE - $FN. &
#split -b $MAXSIZE $PIPE $FN. &
exp userid=$UID buffer=20000000 file=$PIPE $EXPORT_WHAT >>&
expbkup.log
date >> expbkup.log
date > export.test
cat `echo $FN.* | sort` | gunzip > $PIPE &
#cat `echo $FN.* | sort` > $PIPE &
imp userid=sys/o8isgr8 file=$PIPE show=y full=y >>& export.test
date >> export.test
tail expbkup.log
tail export.test
ls -l
rm -f $PIPE
The code is shamelessly copied from tomkytes book.
regards
Hrishy
-
Originally posted by hrishy
Hello
The code is shamelessly copied from tomkytes book.
regards
Hrishy
thanx anyway. Could b useful for others who don't have the book.
Vinit
-
Hi,
Export to disk:
mknod /tmp/exp_pipe p
compress < /tmp/exp_pipe > export.dmp.Z &
exp file=/tmp/exp_pipe ....
Export directly to tape:
mknod /tmp/exp_pipe p
dd if=/tmp/exp_pipe of= &
exp file=/tmp/exp_pipe ....
Hope that helps
Angel
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|