The SpectroSERVER system crashed and had to be rebuilt. How to recover?

Products

• DX NetOps
• CA Spectrum

Issue/Introduction

We are running a Fault Tolerant SpectroSERVER environment.

The system running the Primary SpectroSERVER crashed and had to be rebuilt from scratch.

We have no off site backups of the of the SpectroSERVER database and no snapshots of the VM before it crashed.

How can we recover the SpectroSERVER database in this instance?

Environment

Release : Any
Component: SpectroSERVER

Resolution

Since you are running a Fault Tolerant environment, you can take a backup of the Secondary SpectroSERVER database and load it on the Primary SpectroSERVER as follows:

- Log into the Secondary SpectroSERVER system as the user that owns the Spectrum installation

- If running Windows, start a bash shell by running "bash -login"

- Shutdown the SpectroSERVER as normal

- cd to the $SPECROOT/SS directory and run the following command to backup the SpectroSERVER database:

../SS-Tools/SSdbsave -mc SSdb_Backup

- When complete, copy the SSdb_Backup.SSdb file to the $SPECROOT/SS directory on the Primary SpectroSERVER system

- Start the SpectroSERVER as normal

-- Log into the Primary SpectroSERVER system as the user that owns the Spectrum installation

- If running Windows, start a bash shell by running "bash -login"

- cd to the $SPECROOT/SS directory and run the following command to load the backup file from the Secondary SpectroSERVER:

../SS-Tools/SSdbload -r 10 -il SSdb_Backup.SSdb

- When complete, start the SpectroSERVER as normal

Additional Information

If you had custom events, you can copy the $SPECROOT/custom/Events directory from the Secondary SpectroSERVER to the Primary SpectroSERVER.