Non-data-pump export/import of entire database

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