18 Rolling Back Your BRM Database Upgrade

Learn how to roll back your Oracle Communications Billing and Revenue Management (BRM) 15.2 database upgrade to its prior version.

Topics in this document:

About Rolling Back Your BRM Database

The rollback feature allows you to revert your BRM database and other supported components to their previous stable state if issues occur after an upgrade. For example, if you upgrade your database from BRM 12.0.0.8.0 to BRM 15.2 and encounter problems, you can roll it back to BRM 12.0.0.8.0.

Note:

You can roll back your BRM database only to the exact version that existed before the upgrade. For instance, if you upgrade from BRM 15.0 to 15.2, you can roll back only to 15.0. You cannot roll back to 15.1 or 12.0.0.x.0.

Before rolling back your BRM database, carefully review all prerequisites. Avoid making changes to system keys between the upgrade and rollback, and ensure you complete any rollbacks before making further schema or environment changes. In particular:

  • Do not add secondary schemas to your BRM database before performing a rollback. Adding a schema first may hinder the rollback process.

  • Do not rotate root keys between the upgrade and rollback.

  • Do not add new optional managers to your existing BRM setup between the upgrade and rollback.

  • Run the rollback script using BRM 15.2 (the current BRM version). After the database schema rollback completes successfully, revert to the previous file system and verify that the supported database server and client are in place before you restart services.

The BRM database rollback feature has the following limitations:

  • Rolling back is supported only for BRM 15.2 or later. You cannot roll back from BRM 15.1 or earlier versions.

  • Rolling back is limited to BRM 12.0.0.4.0 or later. You cannot revert to earlier releases.

  • Rolling back can be performed only immediately after an upgrade.

  • Rolling back is not supported for full BRM installations. To revert after a full installation, you must reinstall the earlier version of the software.

  • After rolling back from BRM 15.2 to BRM 12.x, attempting to read BRM 15.2 events in BRM 12.x fails if the event version supported in BRM 12.x is lower than the version used in BRM 15.2. Because no automatic event downgrade occurs, you must manually convert the BRM 15.2 event format to the BRM 12.x event version before these events can be accessed in the rolled-back environment.

After rolling back your BRM database, you can:

  • Start using the previous BRM release. See "About Reusing Your Old BRM Installation".

  • In case you want to upgrade your BRM database again, you can upgrade to the same release you had rolled back from or a higher version.

    For example, if you roll back from BRM 15.2 to BRM 15.0, you can subsequently upgrade again to BRM 15.2 or later, but you cannot upgrade to BRM 15.1.

Tasks for the Database Rollback Process

The following lists the tasks required to roll back your BRM database to a previously installed release version.

  1. Ensure the upgrade to BRM 15.2 completed successfully.

    If the upgrade failed, resolve all issues before proceeding. The rollback procedure cannot be used in the middle of the upgrade flow.

  2. Stop all BRM daemons, processes, and managers.

    See "Starting and Stopping the BRM System" in BRM System Administrator's Guide.

  3. Go to the BRM_home/setup/scripts directory.

  4. Run the BRM database rollback script:

    perl pin_rollback.pl

  5. Adjust your environment to point to the previously installed release version:

    • Restore all third-party software to versions supported by the previous release.

    • Update your environment variables, including those for Perl and Java, to reference the appropriate supported versions.

    For supported software versions, see the BRM Compatibility Matrix for your version of the software.

  6. Verify that the database rollback completed successfully. Check that the ROLLBACK_STATUS field in the BRM_PS_T table is set to 1.

  7. If rolling back a minor upgrade, such as from 15.2 to 15.1, restore the previous BRM environment's file system:

    cd BRM_home/brm_backup
sh fileSystemRollback.sh

  8. Restart all BRM services.

    Note:

    If rolling back a major upgrade, such as from BRM 15.2 to 12.0.0.x.0, restart BRM services using the previous version's file system. For example, if you rolled back from 15.2 to 12.0.0.7.0, use the 12.0.0.7.0 file system.

About Reusing Your Old BRM Installation

After successfully rolling back your BRM database, you can resume using your system. However, before launching BRM, creating accounts, or running billing, do the following:

  • If you rolled back to 15.0 or 15.1: Go to the BRM_home/sys/data/config directory, and run the load_pin_notify utility.

  • If you rolled back to 12.0.0.x.0: Enter the 12.0.0.x.0 file system, go to the BRM_home/sys/data/config directory, and run the load_pin_notify utility.

For information about the utility's syntax and parameters, see "load_pin_notify" in BRM Managing Customers.