Open topic with navigation

# Preparing the ArcSight Database for Upgrade

Applies to on-premises, AWS, and Azure upgrades that involve the ArcSight Database.

In releases before ArcSight Platform 23.1.0, the back up tool for the ArcSight Database contained a defect that could cause the back up to fail under some conditions. To remediate this issue, you must apply a fix to the backup tool before you can back up the database as part of the upgrade process. Complete the following procedure to fix the tool.`(Defect Tracking ID: OCTCR33I570016)`

1. Log in to the master node where you downloaded the files.

2. Copy the `db-installer_x.x.x-x.tar.gz` file to the Database cluster node 1.

   The file is located by default in the `{unzipped-installer-dir}/installers/database/` directory where `{unzipped-installer-dir}` represents the folder that contains the downloaded installation files.

3. Log in to Database cluster node 1.
4. Create a directory to extract the `db-installer_x.x.x-x.tar.gz` file into. We will refer to this directory as `{unzipped-db-installer-dir}`.
Do not use the directories `/root`, `/opt/vertica`, or the existing database installer directory which is located by default at `/opt/arcsight-db-tool`. The files in `/opt/arcsight-db-tools` will be upgraded by the database upgrade tool.
5. To change to the directory, run the following command:

       cd {unzipped-db-installer-dir}

6. To extract (untar) the `db-installer_x.x.x-x.tar.gz` file into the directory, run the following command:

       tar xvfz  db-installer_x.x.x-x.tar.gz

7. To copy the upgrade file to the `/opt/arcsight-db-tools/scripts` directory, run the following command:

       cp scripts/patch_vbr.sh /opt/arcsight-db-tools/scripts

8. To change to the scripts directory, execute the following command:

       cd /opt/arcsight-db-tools/scripts

9. Grant execution rights to the following scripts, and then execute them in the following order:

       chmod +x patch_vbr.sh
       ./patch_vbr.sh

10. Continue to the next task in the Checklist for upgrading your environment.