Cold Backup with Ex Libris Backup package fails with Oracle 19c in an all-in-one environment

Description

The Cold Backup with the Ex Libris Backup package (Oracle 19c) in an all-in-one environment fails with error:

By default the following option is  set up in $alephe_root/aleph_start

$alephe_root/aleph_start

if ($ORA_HOST != $Z39_HOST) then

           setenv    TWO_TASK $aleph_db

           setenv    ora_connect_mode   LISTENER

endif

$alephe_root/aleph_start was defined as:

setenv    ORA_HOST          alephprod

setenv    Z39_HOST          alephprod.library.uk

Since variable ORA_HOST is not equal to Z39_HOST, the system is assumed to be working as a TWO_TASK system, i.e. dedicated Oracle Host, causing the Backup to fail.

Resolution

1. Adjust Z39_HOST to contain the same value of ORA_HOST in $alephe_root/aleph_start

$alephe_root/aleph_start

setenv    ORA_HOST          alephprod

setenv    Z39_HOST          alephprod

2. rerun the Cold Backup

Result:

Additional Information 

Related article: Oracle cold backup fails with Ex Libris Backup package since upgrading to Aleph 23

• Article last edited: 30-March-2022