After restoring Spectrum Data base Old event cannot load

[Uchira Amarasinghe]

Hi,

Five days back we did Spectrum ssdb and ddmdb database restoring. from that day we cannot see old events (last 45 days). can someone help me with this? 


Thanks,
Uchira.

[Mahesh Raj Singh Thakur]

Hi Uchira,

> Please let us know the steps you followed. ?
> Did you initialize to legacy and restored the database ?

You can check the first and last entry in the Archive Manager (DDM) database:

 1) Open a bash shell (bash -login)

2) Go to $SPECROOT/mysql/bin directory

3) Run:

    ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb

 

Show the first and the last event in the DDMdb database:

SELECT FROM_UNIXTIME(MIN(utime)) AS FIRST, FROM_UNIXTIME(MAX(utime)) AS LAST FROM event;

> By default Archive Manager stores 45 days of data, unless the default values are not changed.

We would need more details to help you troubleshoot on this.


------------------------------
Thanks & Regards,
Mahesh Raj Thakur.
Broadcom Support.
------------------------------

[Uchira Amarasinghe]

Hello Mahesh,

Below are steps that I have followed

cd /CA/Spectrum/SS/

../SS-Tools/SSdbload -il legacy.SSdb

../SS-Tools/SSdbload -il /bkup/db_20200229_0530.SSdb

--------------------------------------------------------------------------------

cd /CA/Spectrum/SS/DDM/

./ddm_load -quiet -initialize 64 -events_init /bkup/db_20200229_0530.DDMDb.tgz

Thanks,
Uchira.

[Uchira Amarasinghe]

Hello Mahesh,

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb   output showing as below 

Thanks,
Uchira.

[Uchira Amarasinghe]

Hi,

I'm getting an error while loading the DDMDB.  I have attached the error message. Is anyone know the way to load the ddmdb? I used below command to load ddmdb.

  [svradmin@dialoguat DDM]$ ./ddm_load -quiet /bkup/db_20201002_0200.DDMDb.tgz

Thanks,
Uchira.

Attachment(s)

ddmdb_error.txt   11 KB 1 version

[Mahesh Raj Singh Thakur]

Hi Uchira,

I believe the database was initialized, so you were not able to see old events.

To load the DDM database, ensure you are signed in as a spectrum user to run the following script: 

Please run this syntax ./ddm_load.pl /bkup/db_20200229_0530.DDMDb.tgz
(You can give the database you want to load for example :db_20200229_0530.DDMDb)

[Uchira Amarasinghe]

Hi Mahesh,

I tried to run ./ddm_load.pl command while I'm trying  It's given below error 

[svradmin@dialoguat DDM]$ ./ddm_load.pl /bkup/db_20201008_0200.DDMDb.tgz
Are you running as CA Spectrum install user [y/n] :y
ddm_load.pl: No significant options were specified.
Options\Arguments
-q disable interactive mode
-i -l <LANDSCAPE_HANDLE> initialize the database
-e initialize the events database only
-s initialize the statistical database only
-f <SAVE_FILE> DDM Database Save File
[svradmin@dialoguat DDM]$
[svradmin@dialoguat DDM]$ ./ddm_load.pl -f /bkup/db_20201008_0200.DDMDb.tgz
Are you running as CA Spectrum install user [y/n] :y
The backup file /bkup/db_20201008_0200.DDMDb.tgz extension is incorrect
[svradmin@dialoguat DDM]$


From here which option do I need to specify

Thanks,
Uchira.

[Uchira Amarasinghe]

Hello,

 

I did unpack the DDMDB. Result getting like as below

 

[root@dialoguat ddmdb_backup]# tar zxvf db_20201002_2103.DDMDb.tgz

[root@dialoguat ddmdb_backup]# cd ddmdb_backup/

[root@dialoguat ddmdb_backup]# ll

total 1346020

-rw-r--r--. 1 1001 1001  6871350 Oct  2 21:05 ddmdb_other.tgz

-rw-r--r--. 1 1001 1001 32928666 Oct  2 21:11 event_partition10.tgz

-rw-r--r--. 1 1001 1001 29694067 Oct  2 21:11 event_partition11.tgz

-rw-r--r--. 1 1001 1001 26783113 Oct  2 21:11 event_partition12.tgz

-rw-r--r--. 1 1001 1001 32951941 Oct  2 21:15 event_partition13.tgz

-rw-r--r--. 1 1001 1001 27722984 Oct  2 21:14 event_partition14.tgz

-rw-r--r--. 1 1001 1001 34093153 Oct  2 21:15 event_partition15.tgz

-rw-r--r--. 1 1001 1001 35516499 Oct  2 21:17 event_partition16.tgz

-rw-r--r--. 1 1001 1001 34242224 Oct  2 21:15 event_partition17.tgz

-rw-r--r--. 1 1001 1001 32802604 Oct  2 21:16 event_partition18.tgz

-rw-r--r--. 1 1001 1001 33357721 Oct  2 21:16 event_partition19.tgz

-rw-r--r--. 1 1001 1001 34461507 Oct  2 21:07 event_partition1.tgz

-rw-r--r--. 1 1001 1001 34317664 Oct  2 21:15 event_partition20.tgz

-rw-r--r--. 1 1001 1001 36774769 Oct  2 21:20 event_partition21.tgz

-rw-r--r--. 1 1001 1001 34680587 Oct  2 21:22 event_partition22.tgz

-rw-r--r--. 1 1001 1001 32209311 Oct  2 21:22 event_partition23.tgz

-rw-r--r--. 1 1001 1001 34623478 Oct  2 21:19 event_partition24.tgz

-rw-r--r--. 1 1001 1001 33111496 Oct  2 21:18 event_partition25.tgz

-rw-r--r--. 1 1001 1001 29147668 Oct  2 21:13 event_partition26.tgz

-rw-r--r--. 1 1001 1001 35890690 Oct  2 21:18 event_partition27.tgz

-rw-r--r--. 1 1001 1001 34655606 Oct  2 21:23 event_partition28.tgz

-rw-r--r--. 1 1001 1001 36775034 Oct  2 21:23 event_partition29.tgz

-rw-r--r--. 1 1001 1001 34124547 Oct  2 21:07 event_partition2.tgz

-rw-r--r--. 1 1001 1001 36169575 Oct  2 21:23 event_partition30.tgz

-rw-r--r--. 1 1001 1001 36811351 Oct  2 21:23 event_partition31.tgz

-rw-r--r--. 1 1001 1001 33743631 Oct  2 21:23 event_partition32.tgz

-rw-r--r--. 1 1001 1001 28401531 Oct  2 21:20 event_partition33.tgz

-rw-r--r--. 1 1001 1001 31444640 Oct  2 21:23 event_partition34.tgz

-rw-r--r--. 1 1001 1001 20491142 Oct  2 21:22 event_partition35.tgz

-rw-r--r--. 1 1001 1001 23979001 Oct  2 21:21 event_partition36.tgz

-rw-r--r--. 1 1001 1001 24974413 Oct  2 21:22 event_partition37.tgz

-rw-r--r--. 1 1001 1001 23991905 Oct  2 21:22 event_partition38.tgz

-rw-r--r--. 1 1001 1001 21978748 Oct  2 21:21 event_partition39.tgz

-rw-r--r--. 1 1001 1001 32909961 Oct  2 21:07 event_partition3.tgz

-rw-r--r--. 1 1001 1001 20831597 Oct  2 21:20 event_partition40.tgz

-rw-r--r--. 1 1001 1001 26013629 Oct  2 21:22 event_partition41.tgz

-rw-r--r--. 1 1001 1001 25798674 Oct  2 21:23 event_partition42.tgz

-rw-r--r--. 1 1001 1001 26842571 Oct  2 21:23 event_partition43.tgz

-rw-r--r--. 1 1001 1001 18635068 Oct  2 21:19 event_partition44.tgz

-rw-r--r--. 1 1001 1001 22418610 Oct  2 21:17 event_partition45.tgz

-rw-r--r--. 1 1001 1001      110 Oct  2 21:17 event_partition46.tgz

-rw-r--r--. 1 1001 1001 27820147 Oct  2 21:09 event_partition4.tgz

-rw-r--r--. 1 1001 1001 28246338 Oct  2 21:09 event_partition5.tgz

-rw-r--r--. 1 1001 1001 30896832 Oct  2 21:09 event_partition6.tgz

-rw-r--r--. 1 1001 1001 32113110 Oct  2 21:09 event_partition7.tgz

-rw-r--r--. 1 1001 1001 32680989 Oct  2 21:09 event_partition8.tgz

-rw-r--r--. 1 1001 1001 33290143 Oct  2 21:09 event_partition9.tgz

-rw-r--r--. 1 1001 1001     1307 Oct  2 21:05 event_schema.tgz

-rw-r--r--. 1 1001 1001        3 Oct  2 21:05 partition_count.txt

[root@dialoguat ddmdb_backup]#

 

This is the result. From here wich file should I run?

 

 

Thank you,

Uchira.

[Silvio Okamoto]

Hi Uchira,

Run this syntax:
 ./ddm_load.pl -f /bkup/db_20201008_0200.DDMDb.tgz

------------------------------
Technical Support Engineer IV
Broadcom Inc
------------------------------

[Uchira Amarasinghe]

Hi Silvio,

When executing that you command it's getting below error do you have any idea?

Thanks,
Uchira.

[Uchira Amarasinghe]

Hello Team,

Can I verify, if we load the ddmdb without using initialize attribute does it update the existing ddm database with previous events?

as an example, the existing database has events from 02-oct to 09-oct. we have another backup before 02-oct. if we restore this backup without initializing can we get events before and after 02-oct.

Thanks,
Uchira.

[Silvio Okamoto]

Hi Uchira,

I suspect you have upgraded Spectrum to 10.4.1 release, it is not a fresh install of 10.4.1. 

In this scenario, you may have multiples files in the $SPECROOT/SS/DDM/ directory:

• ddm_save
• ddm_save.pl
• ddm_load
• ddm_load.pl
• ddm_backup
• mysqlbackup

If you uncommented the ddm_backup section of the $SPECROOT/custom/CsScript/post_olb_script, then you will have to use the ddm_load to perform the restore. Note that ddm_backup will stop the Archive Manager to perform the backup of DDM database.

If you uncommented the ddm_save.pl section of the $SPECROOT/custom/CsScript/post_olb_script, then you will have to use the ddm_load.pl to perform the restore.

------------------------------
Technical Support Engineer IV
Broadcom Inc
------------------------------

[Uchira Amarasinghe]

Hi Silvio,

Thanks for the response..!
we successfully loaded old ddmdb backup file by using below command on spectrum 10.4.0

./ddm_load  /bkup/db_20200229_0530.DDMDb.tgz

Thanks,
Uchira.