Taking ssdb backup

[Santhosh Adapa]

Hi Team,

Is it possible to take the ssdb backup when the spectrum control panel is displaying Terminated/Inactive status.

Regards,
Santhosh.

[Catalin Farcasanu]

No. The db is most likely corrupted.

------------------------------
Senior Consultant
SolvIT Networks
------------------------------

[Joseph Ackley]

Santhosh,

If the SpectroSERVER is not brought down gracefully, there is a risk of database corruption so you are prevented from taking a backup or restarting the SpectroSERVER process. You will need to reload from a previously saved backup.

Joe

[Santhosh Adapa]

Hi Joseph,

Suppose there is no back file. Is it possible to take the ssdb backup when the spectrum control panel is showing Terminated/Inactive?

Regards,
Santhosh

[Joseph Ackley]

Santhosh,

If the SpectroSERVER process was not shutdown gracefully, you cannot run a backup. If the SCP is showing terminated then it was not shut down gracefully.

Joe

[Marcelo Zacchi]

Santhosh,

If you have a running secondary server, you could take a backup of the SSDB there and restore it to the primary.

Regards,

------------------------------
Marcelo Zacchi
CA Spectrum consultant
Nets Denmark
------------------------------

[Santhosh Adapa]

Thanks Marcelo.

I have one more query, Suppose Spectrum control panel is showing inactive state instead of Terminated sate. Is it possible to take the backup?

and one more thing is if I take a backup from secondary and restored in primary, any extra steps I have to follow after restoration in primary or that's it?

Regards,
Santhosh

[Jason Volpini]

Hello Santhosh

A couple points to make: 

1. If taking a backup from Spectrum Control Panel, the server needs to be running, status shows 'Running'
2. if state is 'Inactive' then the server is not running. If you try to start it and it shows "database not gracefully closed" then you need to load a previous saved backup instead. 
3. Taking a backup with server shut down is possible with command-line SSdbsave and SSdbload. Read up on those here: https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-3-2/administrating/database-management/spectroserver-database-maintenance/database-backups/manual-backup.html
4. It is recommended to restart Tomcat service on OneClick server after loading a backup (but not required after saving a backup) 

HTH

------------------------------
Senior Support Engineer
Broadcom
------------------------------

[Marcelo Zacchi]

Hi Santhosh,

You should follow Jason's tips to get the backup done with the DB offline. After you do that and have a .tar.gz file in hand, you need to go through the following steps:
0) Copy the .tar.gz file to the primary server
1) Un-gzip the file using gzip -d <file>
2) Go to the  <specroot>/SS directory (IMPORTANT)
3) Run ../SS-Tools/SSdbload -cm -replace 10 <path/backup_file.tar>

If that is successful, then you can start Spectrum from SCP or using startSS.pl

Regards,

------------------------------
Marcelo Zacchi
CA Spectrum consultant
Nets Denmark
------------------------------

[Santhosh Adapa]

Hi Marcelo,

Please tell me how to perform this step.

1) Un-gzip the file using gzip -d <file>

and please give the example of the below mentioned path in detail as per this command " ../SS-Tools/SSdbload -cm -replace 10 <path/backup_file.tar>"


<path/backup_file.tar>

Thanks,

Regards,
Santhosh 

[Santhosh Adapa]

Hi Marcelo,

In our spectrum dev environment, there is no secondary server but the primary server SCP is showing terminated status. So how to make the primary SCP up and Running?

Regards,
Santhosh.

[Marcelo Zacchi]

If you don't have a secondary server or a backup file, then the only solution is to try to fix the DB or reinitialize it.
What error are you getting when you try to start the SS?

------------------------------
Marcelo Zacchi
CA Spectrum consultant
Nets Denmark
------------------------------

[Marcelo Zacchi]

Hi Sahthosh,

Please find below the examples:
- gzip
$ gzip -d db_20190803_0100.SSdb.gz
Command above will result in the file without the ".gz", used in the command below

- ssdbload (from the SS directory)
$ ../SS-Tools/SSdbload -cm -replace 10 db_20190803_0100.SSdb

------------------------------
Marcelo Zacchi
CA Spectrum consultant
Nets Denmark
------------------------------