EXPORT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: EXPORT

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    I'm trying to export an 8.0.6 database on the HP-UX 10.20 platform. The size of the export size is about to grow more than the max file size on the OS, and then fail. What i have to do? I would consider exporting tablespace by tablespace. What is the exact commands to do that?

    Regards
    Alexandre
    In god i trust

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    You Can break up the export file into smaller files use export to a PIPE and have compress and split read the pipe. The result is a couple of 500meg compressed files that consistute the export. At 500meg, any utility can deal with this files and I can move them around easier.

    #!/bin/csh -vx

    setenv UID /
    setenv FN exp.`date +%j_%Y`.dmp
    setenv PIPE /tmp/exp_tmp_ora8i.dmp

    setenv MAXSIZE 500m
    setenv EXPORT_WHAT "full=y COMPRESS=n"

    echo $FN

    cd /nfs/atc-netapp1/expbkup_ora8i
    ls -l

    rm expbkup.log export.test exp.*.dmp* $PIPE
    mknod $PIPE p

    date > expbkup.log
    ( gzip < $PIPE ) | split -b $MAXSIZE - $FN. &
    #split -b $MAXSIZE $PIPE $FN. &

    exp userid=$UID buffer=20000000 file=$PIPE $EXPORT_WHAT >>&
    expbkup.log
    date >> expbkup.log


    date > export.test
    cat `echo $FN.* | sort` | gunzip > $PIPE &
    #cat `echo $FN.* | sort` > $PIPE &
    imp userid=sys/o8isgr8 file=$PIPE show=y full=y >>& export.test
    date >> export.test

    tail expbkup.log
    tail export.test

    ls -l
    rm -f $PIPE

    The code is shamelessly copied from tomkytes book.

    regards
    Hrishy

  3. #3
    Join Date
    Oct 2000
    Posts
    467
    Originally posted by hrishy
    Hello

    The code is shamelessly copied from tomkytes book.

    regards
    Hrishy
    thanx anyway. Could b useful for others who don't have the book.

    Vinit

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    Export to disk:

    mknod /tmp/exp_pipe p
    compress < /tmp/exp_pipe > export.dmp.Z &
    exp file=/tmp/exp_pipe ....

    Export directly to tape:

    mknod /tmp/exp_pipe p
    dd if=/tmp/exp_pipe of= &
    exp file=/tmp/exp_pipe ....

    Hope that helps

    Angel

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