[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference eps::oracle

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

1521.0. "HP->DU-tar,cpio" by HGOVC::NANDAN () Sat Feb 22 1997 07:58

    
    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.RTitleUserPersonal
Name
DateLines
1521.1In addition...HGOVC::NANDANMon Feb 24 1997 09:5820
    
    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::FPRUSSFrank Pruss, 202-232-7347Mon Feb 24 1997 11:585
    Is the "file" mandatory for exp?  What happens if you leave it off
    altogether?
    
    FJP
    
1521.3EXPDAT.DMPHGOVC::NANDANMon Feb 24 1997 23:007
    
    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.4an idea not really a solutionALFAM7::GOSEJACOBMon Mar 03 1997 10:4214
    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.5Thank you !!HGOVC::NANDANSun Mar 09 1997 02:5811
    
    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