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

Description

Since upgrading to Aleph 23, the Ex Libris Backup Package does not execute an Oracle Cold Backup

Resolution

The Ex Libris Backup Package is not adapted to Oracle 12c.

a. Use RMAN instead

b. Use the following workaround:

Change script

../backup/scripts/oc_fb_rman

From:

if (($ORACLE_VERSION == 10)||($ORACLE_VERSION == 11)) then

To:

if (($ORACLE_VERSION == 11)||($ORACLE_VERSION == 12)) then

This should enable cold backups for Oracle 12c.

Additional Information

Note, that other scripts require similar changes:

* oa_rman
* oh_ib0_rman
* oh_ib1_rman

In order to adapt the version to Oracle 19, replace 11 by 19:

cd /exlibris/backup/scripts

find . -type f | grep "ORACLE_VERSION == 11"

./oa_rman:if (($ORACLE_VERSION == 10)||($ORACLE_VERSION == 11)) then

./oh_ib0_rman:if (($ORACLE_VERSION == 10)||($ORACLE_VERSION == 11)) then

./oh_ib1_rman:if (($ORACLE_VERSION == 10)||($ORACLE_VERSION == 11)) then

./oc_fb_rman:if (($ORACLE_VERSION == 12)||($ORACLE_VERSION == 11)) then

After change

./oa_rman:if (($ORACLE_VERSION == 10)||($ORACLE_VERSION == 11) ||($ORACLE_VERSION == 19)) then

./oh_ib0_rman:if (($ORACLE_VERSION == 10)||($ORACLE_VERSION == 11) ||($ORACLE_VERSION == 19)) then

./oh_ib1_rman:if (($ORACLE_VERSION == 10)||($ORACLE_VERSION == 11) ||($ORACLE_VERSION == 19)) then

./oc_fb_rman:if (($ORACLE_VERSION == 12)||($ORACLE_VERSION == 11) ||($ORACLE_VERSION == 19)) then

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

• Article last edited: 15-Aug-2021