| Title: | Oracle |
| Notice: | For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010 |
| Moderator: | EPS::VANDENHEUVEL |
| Created: | Fri Aug 10 1990 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1574 |
| Total number of notes: | 4428 |
We want to transport data from a HP system to a DIGITAL UNIX
system on a DAT tape (120mtrs) reading it using a TLZ07. The
volume of data is such that it can NOT fit on to one tape.
The data is basically Oracle 'exp' data. The first time around we
tried to use the data that was directly exported on to 2 tapes. In
trying to import it it would read data up to (what we guess) to
the end of the tape & then the process would go into a sleep.
Oracle has explicitly told us to avoid using export directly on to
a tape, saying it would not work. They have suggested the use of
the 'exp' being piped to 'tar' or 'cpio' and then on to tape.
Keeping in mind that the data is coming from a HP system, I have
the following queries -
1. Between 'tar' & 'cpio' which is more "robust", or "flexible"
across different vendors ?
2. Are there any specific flags that need to be taken care of on
the HP, or on DIGITAL UNIX to ensure compatibility ?
3. As mentioned earlier, the data would definitely span two or
more tapes. Between 'tar' and 'cpio', which can handle
multi-volume tapes better ?
4. Or, is it advisable to avoid multi-volumes, especially with DAT
media, and considering that it is HP to DIGITAL ?
Can someone please advise me on this.
Thanks in advance.
Nandan
------------------------------------------------------------------
Cross-posted in TURRIS::DIGITAL_UNIX
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1521.1 | In addition... | HGOVC::NANDAN | Mon Feb 24 1997 06:58 | 20 | |
An additional problem I have discovered on actually trying to
pipe the output of 'exp', is that it does not work.
I tried to pipe the output of 'exp' to 'tar', but possibly because
of a wrong parameter given by me, it creates a local file.
For example, I tried -
$exp userid=scott/tiger file=- | tar cf /dev/rmt0h -
It creates a file called "-.dmp". I tried quoting that parameter,
for e.g-
'file=-' or file=(-) or file=\-.
From the Server Utility User's Guide, I am not able to find an
option to pipe out the output of 'exp'.
Thanks in advance.
Nandan
| |||||
| 1521.2 | ? | USPS::FPRUSS | Frank Pruss, 202-232-7347 | Mon Feb 24 1997 08:58 | 5 |
Is the "file" mandatory for exp? What happens if you leave it off
altogether?
FJP
| |||||
| 1521.3 | EXPDAT.DMP | HGOVC::NANDAN | Mon Feb 24 1997 20:00 | 7 | |
Frank,
If you do not specify the "file" parameter, the default is to create a
file called EXPDAT.DMP in the current directory.
Nandan
| |||||
| 1521.4 | an idea not really a solution | ALFAM7::GOSEJACOB | Mon Mar 03 1997 07:42 | 14 | |
re .1 How about this procedure:
cd /usr/tmp
mknod datapipe p
exp userid=scott/tiger file=datapipe &
That will write the export to the named pipe 'datapipe'. But I'm afraid
this is no solution to your problem. Neither 'tar' nor 'cpio' can read
a stream of data from stdin and archive it. And tar'ing the named pipe
will only archive tha special file; not the stream of data that's
written to it. Looks like you have to 'exp' to a plain file and tar or
cpio that file to tape.
Martin
| |||||
| 1521.5 | Thank you !! | HGOVC::NANDAN | Sat Mar 08 1997 23:58 | 11 | |
Martin,
Thank you for the idea. I find the 'exp' does accept this option &
sends data to the pipe. However,...
'tar' & 'cpio' expect a list of filenames to be piped to it. A
possibility is 'dd' which would just accept a stream of bytes. I need
to explore 'dd' some more.
Nandan
| |||||