Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Non-data-pump export/import of entire database

    Non-data-pump export/import of entire database

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description

    Can a database be exported without using the Oracle data pump?

    Resolution

    For larger databases the $aleph_proc/oracle_expdp_aleph_libs / oracle_impdp_aleph_libs work best (-- see the article Refreshing Test server data Using Oracle Data Pump in that regard --), but with smaller databases (in the range of, say, 100,000 - 400,000 bib records) the simpler non-data-pump oracle_exp_aleph_libs / oracle_imp_aleph_libs (which use the file-03/file-04 procedures) can also work.  


    This is the procedure (where "0727" is the date:  July 27):

    Logon to the (20_1) Production instance

    > cd $alephe_scratch 
    1. > csh -f $aleph_proc/oracle_exp_aleph_libs > & $alephe_scratch/oracle_exp_aleph_libs.0727.log &

    > cd /exlibris/aleph/u20_1/ 
    2. > tar -cvf prod.ora.tar.0727 */files/*export.gz* 
    3. > cp -p /exlibris/aleph/u20_1/prod.ora.tar.0727 /exlibris/aleph/u20_2/prod.ora.tar.0727
    4. > tar -xvf prod.ora.tar.0727

    5.  Logout and login to the 20_2 Test instance

    > cd $alephe_scratch 
    > csh -f $aleph_proc/oracle_imp_aleph_libs yes > & $alephe_scratch/oracle_imp_aleph_libs.0727.log &

    [Note:  in the above example, the Test instance (20_2) is on the same server as the Prod (20_1).  If it is not, then, instead of the steps 3 - 5, you would need to ftp or sftp the prod.ora.tar.mmdd file from the /exlibris/aleph/u20_1/ directory on the Prod server to the /exlibris/aleph/u20_n/ on Test, and then connect to the Test server for the other steps.  Below is a sample dialog for an sftp (on a v21 server, with the date of "0611"):

    aleph@lib-aleph-01(a21_1):~/u21_1>sftp lib-aleph-02
    Connecting to lib-aleph-02...
    Password:
    sftp> cd /exlibris/aleph/u21_1/
    sftp> put prod.ora.tar.0611
    Uploading prod.ora.tar.0611 to /exlibris/aleph/u21_1/prod.ora.tar.0611
    prod.ora.tar.0611                              29% 1224MB  31.1MB/s   01:33 ETA

    * Login to the Test instance

    > cd /exlibris/aleph/u21_1/ 

    > tar -xvf prod.ora.tar.0611

    > csh -f $aleph_proc/oracle_imp_aleph_libs yes > & $alephe_scratch/oracle_imp_aleph_libs.0611.log &

    ]

    The above took 20 minutes for the export and 3 hours for the import for a database of 75,000 bib records (-- without any z00p)....

    In another case, with 400,000 records, with a z00p, the export took an hour and the import, 12 hours. 

     The z98 is what takes the longest.

    NOTE:  In one case the $aleph_proc/oracle_imp_current_lib proc (being executed in background) was issuing and stopping on the  "enter yes to confirm" message.  We changed the  proc to skip the issuance of this message (which is not necessary or appropriated when i'ts being executed in the background). 

     

     

     

     


    • Article last edited: 12-Jun-2018
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Non-circulating items are loaned
      • Non-filing Indicators Not Working for Browse Index
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. oracle_exp_aleph_libs
      3. oracle_imp_aleph_libs
      4. Prod:Aleph
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved