Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
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