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. Upgrade Express: downtime when using Oracle Data Pump vs. database cloning

    Upgrade Express: downtime when using Oracle Data Pump vs. database cloning

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    Do you have experience with downtime during 18-20, esp. 19-20, upgrade when using data pump?

    In a Powerpoint, I see that 1 Million titles takes approx. 3 hours, so will 5 million take 15 hours? (I know that we can not predict it exactly as it is also dependent on the hardware).

    Would you recommend a customer with 5 Million BIB records do DB cloning instead of data pump (if they have DBA knowledge)?

    Resolution:
    [From Eyal:]

    For larger databases I personally prefer using DB clone rather than DB Pump because it is faster but all depends on their DBA, what he is more comfortable on doing.

    About timing, yes, DB Pump is linear, so, if 1M takes 0.5 hours, then 5M would take 2.5 hours.

    [From Jerry:]

    "1 Million titles takes approx. 3 hours" is too high. It's more like 0.5 hours for 1 million titles.

    See also KB 16384-19041.


    • Article last edited: 4/16/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Upgrade Express: Are Custom Services files in a-tree copied to target?
      • Upgrade Express: Export Customer Data: snapshot too old: rollback Z98...
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      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