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. Using Oracle Data Pump on live production server

    Using Oracle Data Pump on live production server

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    We may be acting over cautious here, but we wanted to confirm with you that we can indeed initiate the Oracle Data Pump via the Upgrade Express on our live production server with no ill effects to Aleph.

    In other words, can Aleph and Oracle both be up on production when we launch this script?

    Resolution:
    As described at http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/dp_perf.htm#SUTIL400 ,
    "Data Pump technology fully uses all available resources to maximize throughput and minimize elapsed job time.... The Data Pump Export and Import utilities enable you to dynamically increase and decrease resource consumption for each job. This is done using the PARALLEL parameter to specify a degree of parallelism for the job."

    We recommend that Aleph (the www_server, pc_server, etc.) be down when you are extracting the data. If you are importing the data on a different server, that component is a non-issue. If importing on the same server, you may want to minimize the parallelism....

    My experience has been that it's a very heavy user of system resources. It won't keep other things from happening, just slow them down. It runs extremely fast. You should be able to export your entire database in one night. We have found "For a ~400GB DB the dpdump export takes for us 1 hour and 40 min."

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Using multilingual OPAC for Mobile interface
      • Using placeholder variables in javascript
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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