The Archive Manager database on my primary SpectroSERVER is corrupt and will not repair.

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

We are getting an error in the ARCHMGR.OUT file on the primary SpectroSERVER system stating the database is corrupt and to run a repiar.

We ran an "ArchMgr -repair" as well as a "mysqlcheck" repair on the DDM database yet the problem persists.

We do not have any backups of the DDM database.

How can we recover the data?

Environment

Release : Any

Component: Archive Manager

Resolution

If you are running Fault Tolerant SpectroSERVERs, you can make a backup of the Archive Manager database on the secondary SpectroSERVER and then load it on the primary SpectroSERVER.

- Log into the secondary SS as the user that owns the Spectrum installation

- Shutdown the Archive Manager if running

- Start a bash shell by running "bash -login"

- cd to the $SPECROOT/SS/DDM directory and enter the following command to backup the DDM database where <NAME> is a file name:

./ddm_save.pl -f <NAME> 

- The backup file will be called <NAME>.mbi

- Copy the <NAME>.mbi to the $SPECROOT/SS/DDM directory on the primary SS

- Log into the primary SS as the user that owns the Spectrum installation

- Shutdown the Archive Manager if running

- Start a bash shell by running "bash -login"

- cd to the $SPECROOT/SS/DDM directory and run the following command where <NAME> is the filename of the mbi backup file from the secondary:

./ddm_load.pl -f <NAME>

- Start the Archive Manger on the primary

Reference the "ddm_load" and ddm_save" sections of the documentation for more information.

Additional Information

If you are not backing up the DDM database at this time, it is highly recommend backing it up at least once a week.

References:

post_olb_script

How to backup the the Archive Manager (DDM) database

How to configure the CA Spectrum post_olb_script to perform a DDM back-up at a specific time