• Article Type: General
• Product: Aleph
• Product Version: 21

Desired Outcome Goal:
Produce easily-recoverable backups of Oracle tables prior to running manage-nn index jobs in the actual library (as opposed to a parallel library).

Procedure:
The first choice is to perform a full backup of Oracle before running the indexing job, stop the servers while the job is running, and, if there's any problem, restore the full backup.

The alternative, if you can't do this, is to back up individual tables using the Oracle Data Pump....

1. One time only:

> s+ ALEPH_ADMIN
SQL> grant JAVA_ADMIN to aleph_admin WITH ADMIN OPTION;

2. Enter the following commands on the command line. As described in KB 16384-49361 ("Unable to open file "oracle_expdp_current_lib.sql"), the oracle_expdp_table and oracle_impdp_table procs *must* be run in the $aleph_proc directory. "XXX01" is the library for which the job is being run.

Preceding manage-01 (Rebuild Word Index):

> cd $aleph_proc
> csh -f oracle_expdp_table XXX01,z95 > & $alephe_scratch/oracle_expdp_table.z95.mmdd.log &
> csh -f oracle_expdp_table XXX01,z97 > & $alephe_scratch/oracle_expdp_table.z97.mmdd.log &
> csh -f oracle_expdp_table XXX01,z98 > & $alephe_scratch/oracle_expdp_table.z98.mmdd.log &
> csh -f oracle_expdp_table XXX01,z980 > & $alephe_scratch/oracle_expdp_table.z980.mmdd.log &
> csh -f oracle_expdp_table XXX01,z52 > & $alephe_scratch/oracle_expdp_table.z52.mmdd.log &


Preceding Headings jobs:

> cd $aleph_proc
> csh -f oracle_expdp_table XXX01,z01 > & $alephe_scratch/oracle_expdp_table.z01.mmdd.log &
> csh -f oracle_expdp_table XXX01,z02 > & $alephe_scratch/oracle_expdp_table.z02.mmdd.log &
> csh -f oracle_expdp_table XXX01,z52 > & $alephe_scratch/oracle_expdp_table.z52.mmdd.log &


Preceding manage-32 (Build Counters for Logical Bases):

> cd $aleph_proc
> csh -f oracle_expdp_table XXX01,z0102 > & $alephe_scratch/oracle_expdp_table.z0102.mmdd.log &
> csh -f oracle_expdp_table XXX01,z52 > & $alephe_scratch/oracle_expdp_table.z52.mmdd.log &


Preceding manage-35 (Update Brief Records):

> cd $aleph_proc
> csh -f oracle_expdp_table XXX01,z0101 > & $alephe_scratch/oracle_expdp_table.z0101.mmdd.log &
> csh -f oracle_expdp_table XXX01,z52 > & $alephe_scratch/oracle_expdp_table.z52.mmdd.log &


Note: Backup prior to indexing is a customer responsibility. Full backup of the database prior to running p_manage jobs is the preferred option.