Re: Exporting large (>8 gig) database in UNIX?

You do the unix pipe using mknod utility.

Example...
mknod /tmp/exp_pipe p
compress < /tmp/exp_pipe > prod_exp.dmp.Z exp userid/password file=/tmp/exp_pipe ....other parms here or in parfile

Remember - you can't go over 2 gig! If over 2 gig, can just do exp to /dev/rmt etc
but you must use the volsize parameter of exp to tell it the size of tape. Also,
when I tried to span tapes, the exp utility only waits around 5 minutes and a couple retries when the tape is full - it then pukes the exp job!

Also, you can't exp compress to tape - nice idea though.

Bottom line, if you have export that compressed is larger than 2 gig and exp larger than tape size, you're screwed.

Markus Albert wrote:
>
> Anton Dischner wrote:
>
> Hi Simon,
>
> i do a 10GB database backup using the 'export to pipe and
> compress on the fly'
> method using gzip. See FAQ or mail me if you need syntax.
> Your resulting file must be < 2GB.
>
> Onother way is to backup to tape using something like
> /dev/rmt0 (AIX) as
> file-name. EXP asks for tape-capacity and will prompt for
> new tape.
>
>
> Hi Anton,
>
> I've read your posting and would like to try it out, cause I'm in a
> similar situation.
> Could you please explain what you mean by 'export to pipe and compress
> on the fly' ?
>
> Thanks in advance, Ciao Markus.
>
 

-- 
Gary Melhaff
Senior Database Analyst
Weyerhauser Corporation