Instructions for Database Cloning
- Article Type: Q&A
- Product: Aleph
- Product Version: 18.01
Question
The Upgrade Express documentation includes "Database Cloning" as a method for moving the Oracle data. Where is this procedure documented?
Answer
The document How to clone Oracle Database using CopyDb package describing this procedure for an Oracle 9 DB is attached.
Contact Ex Libris support for instructions on retrieving the associated scripts from the Ex Libris ftp site.
Additional Information
Data pump is relatively fast. The time that is needed of course depends on local factors (hardware, size of DB,...) but for example we are aware about one example where the whole process (export+ftp+import) took 7 hours for a DB of 200 GB.
The vast majority of our Aleph customers have used the data pump option as it is easy to use and very stable.
Therefore using data pump is the preferred option.
Please note:
Database clone and upgrade is a complicated process that even when you have experienced DBA and everything runs smoothly may also take several hours as a lot of actions needs to be performed.