Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Preventing tarring/compression of Oracle data when target is same server as source

    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Desired Outcome Goal:
    In the case where the server where the target and the source are on the same server prevent the (unnecessary) tarring and zipping of the data.

    (Analysis has shown that skipping the compression and decompression of export files during the export and import process can reduce the time for each of these processes by as much as 50%.)

    Procedure:
    1. In the regular (all-in-one) case.... ***********************************************************

    a. To prevent compression in the export insert the following line: in the ./upgrade_express_2101_2201/util/create_user_data procedure
    set use_dp="DP_no_zip"

    immediately before the command:
    echo "Export will now run in the background."

    b. To prevent the attempt to unzip on import, comment out certain lines in ./upgrade_express_2101_2201/upgrade_util and ./util/install_utree files, as shown in Additional Information below:


    2. In a TWO_TASK environment.... *******************************************************

    a. In order to skip the compression of the of export files after the Data Pump export is completed one needs to comment out the lines 36 - 38 of the script expdp_on_two_task.csh:
    -------------------------------------------
    echo Compressing...
    gzip ${target_dir}/dpdir/*.dmp
    ls -ltrh ${target_dir}/dpdir/*dmp.gz
    -------------------------------------------


    b. In order to skip the decompression of the of export files before the Data Pump import starts one needs to comment out the lines 30 - 33 of the script impdp_on_two_task.csh:
    -------------------------------------------
    echo User dropped. Extracting files...

    gzip -d ${target_dir}/dpdir/*.gz
    echo Extracted files:
    -------------------------------------------

    c. In order to skip the compression of the of export files after the Data Pump import is completed one needs to comment out the lines lines 37 - 39 of the script impdp_on_two_task.csh:
    -------------------------------------------
    echo Import finished. Compressing the files back again...
    gzip ${target_dir}/dpdir/*.dmp
    echo Done Compressing the files.
    -------------------------------------------

    Additional Information


    In the regular (all-in-one) import:

    ***** ./upgrade_util changes....

    Comment out the seven lines beginning with:

    #                 if (! -f $uk_root/data/$S_ALEPH_APP_VERSION.tar.gz) then

    and ending with:

    #                                  read_line >& /dev/null

    And commment out the second "endif":

    #                                      csh -f ./util/install_utree
    #                                   endif
    #                           endif                <--------

    Comment out all the lines in the "case 2" section except for the first

                                      csh -f ./util/install_utree

    (immediately following the "else") and the 

                            goto begin_proc

    Like this:

                    case 2:
    #                          if (! -f $uk_root/data/$S_ALEPH_APP_VERSION.tar.gz) then
    #                                  echo "   Missing ./data/$S_ALEPH_APP_VERSION.tar.gz"
    #                                  echo "   run create and/or transfer customer data"
    #                                  echo "   If you transferred the u-tree from another v.${ALEPH_APP_VERSION} server, use option 9 to upload it"
    #                                  echo "   "
    #                                  echo -n "Enter to continue"
    #                                  read_line >& /dev/null
    #
    #                          else
                                      csh -f ./util/install_utree
    #                             source $aleph_proc/clear_screen
    #                                  csh -f ./util/yesorno "Install customer data"
    #                                  set rr = $status
    #                                  if $rr == 1 then
    #                                     goto begin_proc
    #                                  endif
    #
    #                                  if (-d data/$S_ALEPH_APP_VERSION) then
    #                                        rm -rf data/$S_ALEPH_APP_VERSION
    #                                  endif
    #                                  (cd ./data/; tar -xf ./$S_ALEPH_APP_VERSION.tar.gz)
    #                                   if ($status) then
    #                                      echo "There was a problem opening the ./data/$S_ALEPH_APP_VERSION.tar.gz file"
    #                                      echo -n "Enter to continue"
    #                                      read_line >& /dev/null
    #                                   else
    #                                      csh -f util/logs_log
    #                                      setenv step_number install_utree


    ***** ./util/install_utree changes....

    Comment out the twelve lines beginning with echo "removing old data ...", through and including the "else".  Also comment out the "endif" three lines below.  

    Like this:

    #       echo "removing old data ..."
    #        if (-d data/$S_ALEPH_APP_VERSION) then
    #             rm -rf data/$S_ALEPH_APP_VERSION
    #        endif
    #         echo "Opening tar file ..."
    #         (cd ./data/; tar -xf ./$S_ALEPH_APP_VERSION.tar.gz)
    #         if ($status) then
    #              echo "There was a problem opening the ./data/$S_ALEPH_APP_VERSION.tar.gz file"
    #              echo -n "Enter to continue"
    #              read_line >& /dev/null
    #              exit
    #         else
                 csh -f util/logs_log
                 setenv step_number install_utree
    #               endif

    Note the preceding can apply to the case where a removable disk is written to by the export on the source server, and then moved to the target server where it's read for the import, 

    Category: Installation & Upgrades (500)


    • Article last edited: 11/18/2014