Sys Maintenance: Reporting Engine Backup and Recovery

Document created by RSA Information Design and Development on Nov 23, 2016Last modified by RSA Information Design and Development on Aug 2, 2017
Version 10Show Document
  • View in full screen mode
 

Administrators can back up and restore configuration and database files for the Reporting Engine, so that if information is lost or deleted, it can be restored.

Back Up Files

For a full backup of configuration and database files:

  1. Stop the Reporting Engine using the following command:

    stop rsasoc_re

  2. Create a tar.bz2 of the bulk folder stored under /home/rsasoc

    tar -C / --atime-preserve --recursion -cvpPhjf <BackupDirectory>/re.tar.bz2 --exclude='home/rsasoc/rsa/soc/reporting-engine/temp' /home/rsasoc

To back up Puppet and RabbitMQ files:

  1. Create a tar.bz2 file of the Puppet and RabbitMQ files:
    tar -C / --atime-preserve --recursion -cvpjf /root/puppet-rabbit-backup.tar.bz2 --exclude=/var/lib/puppet/bucket --exclude=/var/lib/puppet/reports --exclude=/var/lib/puppet/lib --exclude=/var/lib/rabbitmq/mnesia /var/lib/puppet /etc/puppet /var/lib/rabbitmq
  2. If you are backing up a system that is still being used, start the Reporting Engine using the following command:
    start rsasoc_re

To back up only the configuration files: 

Note: This is the same as the full backup, but does not back up the report results and history.

  1. Stop Reporting Engine using the following command:
    stop rsasoc_re

  2. Create a single tar.bz2 of all the subdirectories except the subdirectories resultstorelivecharts, alertsstatusdb, logs, temp, formattedReports, and subreports under /home/rsasoc/rsa/soc/reporting-engine.

    tar -C / --atime-preserve --recursion -cvpPhjf <BackupDirectory>/refiles.tar.bz2 --exclude='/home/rsasoc/rsa/soc/reporting-engine/resultstore' --exclude='/home/rsasoc/rsa/soc/reporting-engine/livecharts' --exclude='/home/rsasoc/rsa/soc/reporting-engine/alerts' --exclude='/home/rsasoc/rsa/soc/reporting-engine/statusdb' --exclude='/home/rsasoc/rsa/soc/reporting-engine/logs' --exclude='/home/rsasoc/rsa/soc/reporting-engine/temp' --exclude='/home/rsasoc/rsa/soc/reporting-engine/formattedReports'--exclude='/home/rsasoc/rsa/soc/reporting-engine/subreports' /home/rsasoc/rsa/soc/reporting-engine

  3. If you are backing up a system that is still being used, start Reporting Engine using the following command:
    start rsasoc_re

Restore Files

When you are restoring files that have been backed up, put the files in a consistent place. In this document, we are using the /tmp/ folder as the location for the tar files to be extracted. You can use a different folder if needed.

For a full restore of configuration and database files:

  1. Stop the Reporting Engine using the following command:

    stop rsasoc_re

  2. Re-install the Reporting Engine RPM using the following command:

    rpm -i --force [reporting-engine.rpm]

    Note: On reinstalling, some directories will be created under /home/rsasoc.

  3. To remove the already created rsasoc directory:

    rm -r /home/rsasoc

  4. Change to the / directory.

    cd /

  5. Copy the tar file re.tar.bz2, using a utility like Secure Copy (SCP), to the host in the /tmp/ folder.
  6. Extract the tar file using the following command:

    tar -C / -/tmp/xvf re.tar.bz2

  7. Delete the tar files.

    rm /tmp/re.tar.bz2

  8. If the restored content does not have permission for rsasoc, use the following command to reinstate the user privilege:

    chown -R rsasoc:rsasoc /home/rsasoc

To restore the configuration files:

  1. Log onto the host that you intend to restore from a saved backup using SSH.
  2. Stop the Reporting Engine using the following command:
    stop rsasoc_re
  3. Change to the / directory.
    cd /
  4. Copy the tar file, using a utility like Secure Copy (SCP), to the host in the /tmp/ folder.
  5. Extract the tar file by using the following command:
    tar -C / -xvf /tmp/refiles.tar.bz2
  6. Delete the tar file.
    rm /tmp/refiles.tar.bz2

To restore Puppet and RabbitMQ Files:

  1. Change to the / directory.
    cd /
  2. Copy the tar file puppet-rabbit-backup.tar.bz2, using a utility like Secure Copy (SCP), to the host in the /tmp/ directory.
  3. Extract the tar file by using the following command:
    tar -C / -xvjf /tmp/puppet-rabbit-backup.tar.bz2
  4. Delete the tar file.
    rm /tmp/puppet-rabbit-backup.tar.bz2
  5. Start the Reporting Engine by using the command:

    start rsasoc_re

You are here
Table of Contents > Sys Maintenance: Reporting Engine Backup and Recovery

Attachments

    Outcomes