Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle EXPORT directly to TAPE device after compress

Amit Kureel
Advisor

Oracle EXPORT directly to TAPE device after compress

I am using the following sequence of commands to compress my Oracle Export :

# Make a pipe
mkfifo expdat.dmp
# Start compress sucking on the pipe in background
compress < expdat.dmp > expdat.dmp.Z &
# Wait a second or so before kicking off the export
sleep 5
# Start the export
exp user/password filename=expdat.dmp

But I also want to simultaneously feed the expdat.dmp.Z to tape. Can anybody help me...?

Amit Kureel
4 REPLIES
steven Burgess_2
Honored Contributor

Re: Oracle EXPORT directly to TAPE device after compress

Amit

Hi

You can simply

compress < expdat.dmp > expdat.dmp.Z | tar cvf /dev/rmt/0m expdat.dmp.Z &

or

compress < expdat.dmp > expdat.dmp.Z | fbackup -v -f /dev/rmt/0m -i expdat.dmp.Z &

Hope this helps

Steve

take your time and think things through
steven Burgess_2
Honored Contributor

Re: Oracle EXPORT directly to TAPE device after compress

Amit

Has this worked for you ?

Steve
take your time and think things through
Amit Kureel
Advisor

Re: Oracle EXPORT directly to TAPE device after compress

Steve, I had already tried your suggestion but that approach doesn't work. Any other ideas ?

Amit
Volker Borowski
Honored Contributor

Re: Oracle EXPORT directly to TAPE device after compress

Try this one:

1) make pipe (ok)
2) export to pipe (ok)

3) read from pipe, compress and write:

dd if=expdat.dmp | compress | dd of=/dev/rmt/0m

To reimport do

dd if=/dev/rmt/0m | uncompress | dd of=expdat.dmp

...and start import reading from pipe.

Hope this helps
Volker