Restore alarms, owner and tickets after crash Spectroserver

[Christophe Houbre]

Following a network problem, a spectroserver stopped and the database was corrupted. The last backup SSdb file bas been restored.

The problem is that alarms and their associated owner/tickets are not raised.

Can you tell me which command (SSdbload) to use to restore alarms and their ticket after a crash?

Here is the command used in my case:

/data/Spectrum/SS $ ../SS-Tools/SSdbload -i -l /data/backups/SS-DB-Backup/tva_db/db_20180221_0100.SSdb

Regards,

Christophe H.

[Legacy User]

Hi

 

You also to restore the DDM DB, this include the Events etc.

 

Eric

[Christophe Houbre]

Hi Eric,

 

So with the file db_0100.DDMDb.tgz?

Which command should I use to restore?

 

Regard's,

 

Christophe H.

[Legacy User]

To run the ddm_load command:

1. Gunzip the <your_backup_filename> if compressed.
2. Open a command line as the Spectrum Owner account.
3. Stop the Spectro Server by $SPECROOT/bin/stopSS.pl
4. cd $SPECROOT/SS/DDM directory.
5. Run ./ddm_load <your_backup_filename>

 

[Christophe Houbre]

Thank's Eric.

[Christophe Houbre]

Hello,

I restored both SSdb and DDM databases. The alarms date from the restart of the Spectroserver (and not from their last appearance) and the information of the onwer and ticket have not been restored.

 

1/ ../SS-Tools/SSdbload -i -l /data/backups/SS-DB-Backup/db_20180223_0200.SSdb

2/ ./ddm_load db_20180223_0900.DDMDb.tgz

 

Do you know why ?

 

Regard's,

 

Christophe H.

[Jason Meader]

Hi Christophe, 

  Unfortunately the alarms are not saved as part of the SS backup process. The are synchronized with a secondary (FT) SpectroSERVER and when the primary comes back up any non communication related alarms would be marked stale but should sync back to the primary.  If you do not have a fault tolerant SS, or if the alarms were for communication purposes, then the alarms may be gone.

Cheers

Jay

[Christophe Houbre]

Hi Jason,

 

Thank's for your answer.

 

The Database "DDM" saved the alarms (owner, ticket, etc..), no ?

 

Regard's,

 

Christophe H.

[Jason Meader]

No, the ddmdb only has the events (and pcause id).  The alarms themselves have their own attributes and are stored in the SSAlarms db table (which gets reset when you initialize the SSdb).

Cheers

Jay