Exports using Multiple files and Pipes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Exports using Multiple files and Pipes

  1. #1
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    I have a large database that needs to be exported nightly. Currently we use a Unix Pipe to have the dmp file compress as it's being written. Similar to:

    mknod exp_pipe p
    nohup cat exp_pipe |compress -f > /oradumps/exp_PROD.dmp.Z &

    exp system/password full=Y compress=N direct=Y file=exp_pipe


    The problem is that the database is now so large that even compressed the export is ~11 Gig. So when I try to uncompress, it needs > 40 Gig of space. I don't have any filesystems that large.

    I have tried using multiple files and FILESIZE in the exp where each file is a separate pipe. However, I have found that this isn't very reliable. It doesn't seem to work consistently with filesize > 2Gig. It writes one file and then dies with "EXP-00002: error in writing to export file". (I can write files larger than 2 Gig).

    I would like to use at least 5 Gig, preferably 10 Gig so I don't have to split it into 20 files.

    Does anyone know of a way to get this to work consistently? Any other ideas? I need some help because my exports are basically useless until I get this to work.

    Thanks so much!!
    Jodie

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    man split
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    Doesn't split only work on a completed file, and the original is unchanged. I don't have room for a full export on one filesystem.

    If I'm incorrect here, please let me know.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    no, you can split via a pipe...

    http://www.oracle.com/oramag has about 1000 examples of how to do this...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    Fantastic!

    Thanks so much, Jeff!


  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    Why not just enable large file size on the Unix box, this way you are not limited to 2 gigs. Also, if you can not uncompress your backup, or do not have a mount point large enough for it, well, how good is your backup?

    Jeff, where did you see an article on man split, I search and come up with nada.

    MH
    I remember when this place was cool.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Mr Hanky read again the post, this is not a size limit issue

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width