Trying to load SSDB on secondary

[sudheerreddy524]

Trying to load SSDB on secondary using below command.

 

While running below command we are getting below error .

We need to run this command in secondary server right?

 

 

 ./SSdbload -il -add 20 SS-DB-Backup
SPC-DBS-20081: Error: Unable to open specified save file: SS-DB-Backup.SSdb

[Jason Meader]

Hi,

You need to be in the SS directory when you run the command...and for consistency put your SSdb file in the SS-DB-Backup directory.  So the command is:

 

../SS-Tools/SSdbload -ila 20 ../SS-DB-Backup/dbsavefile.SSdb

 

Cheers

Jay

[sudheerreddy524]

Thank you..

After running getting below error

 

SPC-DBS-23007: This save file cannot be loaded by version 10.2.0.000 of Spectrum.
It was saved as version loaded landscape address {0} .

[Jason Volpini]

Hi There

 

There is a couple of issues with your example SSdb load command... 

 

1. The command has to be run from the /SS directory

2. You're not defining an SSdb file to load ("SS-DB-Backup" is the default backup directory name on your Primary server)

 

SSdbload - CA Spectrum - 10.2 to 10.2.2 - CA Technologies Documentation 

 

Your command should look more like (from the /SS directory):

 

../SS-Tools/SSdbload -il -add 20 <SSdb backup file>.SSdb

 

Please review the Fault Tolerance documentation for further details: 

 

Establish Fault Tolerance - CA Spectrum - 10.2 to 10.2.2 - CA Technologies Documentation 

 

Regards

Jay V

[sudheerreddy524]

Thank you..

After running getting below error

 

SPC-DBS-23007: This save file cannot be loaded by version 10.2.0.000 of Spectrum.
It was saved as version loaded landscape address {0} .

[Jason Volpini]

Sounds like something may be wrong/corrupted with the SSdb file you are trying to load...

 

1. make sure the SSdb file is uncompressed

2. Save another SSdb from your Primary and try again

 

Also verify your Primary and Secondary are running the same version of Spectrum. Check the <SPECROOT>/Install-Tools/.history files

[sudheerreddy524]

Thank you.

 

Primary and secondary are in same version 10.2.0.0.245

Took new SSdb and trying to lode but getting below error. 

 

[root@XXXX SS-Tools]# ./SSdbload -a 20 -il /usr/Spectrum/SS/db_20171208,1.after.SSdb

SPC-DBS-20055: Error: The -add flag can only be used when loading models.

 

[root@XXXX SS-Tools]#./SSdbload -il -add 20 /usr/Spectrum/SS/db_20171208,1.after.SSdb

SPC-DBS-20055: Error: The -add flag can only be used when loading models.

[sudheerreddy524]

Is this out put is correct 

Which option i need to select Y or N ?

 

[XXXX-SS-Tools]$ ./SSdbload -il -add 20 /usr/Spectrum/SS/SS-DB-Backup/db_20171211_1505.SSdb
The specified save file: /usr/Spectrum/SS/SS-DB-Backup/db_20171211_1505.SSdb ,
was created with the following options:
-c (catalog)
-m (models)

and indicates these landscapes loaded on these servers:

Landscape Hostname Port Precedence
---------- ---------------- ------ ----------
0x800000 XXXXX 0xbeef 10

***Warning***

You have chosen the '-i' option. This option is used to initialize
the database. This means ALL data in the database will be deleted. If
you choose to continue with this option, you must be prepared to load
your modeling catalog (model types and relations), before starting the
SpectroSERVER.

Do you really want to initialize the database? (Y or N):

[Jason Meader]

You need to be in the SS directory so the SSdb files can be written:

 

 

$ .../SS-Tools/SSdbload -il -add 20 /usr/Spectrum/SS/SS-DB-Backup/db_20171211_1505.SSdb

 

Then when it asks you to initialize, press Y

[sirha02]

Hi, 

 

 As Jay mentioned, you would need to be in SS directory.

 

Run the commands as below:

 

cd /usr/Spectrum/SS

../SS-Tools/SSdbload -il -add 20 /usr/Spectrum/SS-DB-Backup/db_20171211_1505.SSdb

 

Press Y and hit enter when you are asked do u want to initialize database. 

[Silvio Okamoto]

Hello,

 

Make sure both SpectroSERVERs (primary and secondary) are in the same release.

Check the $SPECROOT/Install-Tools/.history file.

 

Thanks,

Silvio

[sudheerreddy524]

Hi 

 

Primary and secondary are in same version 10.2.0.0.245

[sirha02]

Hi,

 

Try the below steps please.

 

On the primary SpectroSERVER, take a new SSdb backup

Copy the backup to the Secondary SpectroSERVER in the %SPECROOT%/SS-DB-Backup folder (Create this folder if not present)

Uncompress the SSdb backup (if compressed - you should see the .gz extension -> uncompress it -> Ensure the extension ends with .SSdb and not .SSdb.gz)

Now, open command prompt and type the below

bash -l

cd SS

../SS-Tools/SSdbload.exe -il -add 20 <SSdb file name>

 

Let us know how it goes

[sudheerreddy524]

Thank you,

But getting below error.

 

[root@XXXX SS-Tools]# ./SSdbload -a 20 -il /usr/Spectrum/SS/db_20171208,1.after.SSdb

SPC-DBS-20055: Error: The -add flag can only be used when loading models.

 

[root@XXXX SS-Tools]#./SSdbload -il -add 20 /usr/Spectrum/SS/db_20171208,1.after.SSdb

SPC-DBS-20055: Error: The -add flag can only be used when loading models.

[sirha02]

The database you are using is not the right database. You are using the database "db_20171208,1.after.SSdb" - No, don't use this.

 

From the Primary SpectroSERVER -> Save the database (From Spectrum Control Panel -> Click Save Database -> Click Begin Backup Now)

 

The database saved now should have name similar to db_20171211_1705.SSdb.gz

 

Copy the above saved database, i.e. copy db_20171211_1705.SSdb.gz to the Secondary SpectroSERVER in the directory %SPECROOT%/SS-DB-Backup folder (Create this directory if not present)

 

Now, type the below commands

 

gunzip /usr/Spectrum/SS-DB-Backup/db_20171211_1705.SSdb.gz

cd /usr/Spectrum/SS

../SS-Tools/SSdbload -il -add 20 /usr/Spectrum/SS-DB-Backup/db_20171211_1705.SSdb

[sirha02]

The database you are using is not the right database. You are using the database "db_20171208,1.after.SSdb" - No, don't use this.

 

From the Primary SpectroSERVER -> Save the database (From Spectrum Control Panel -> Click Save Database -> Click Begin Backup Now)

 

The database saved now should have name similar to db_20171211_1705.SSdb.gz

 

Copy the above saved database, i.e. copy db_20171211_1705.SSdb.gz to the Secondary SpectroSERVER in the directory /usr/Spectrum/SS-DB-Backup directory (Create this directory if not present)

 

Now, type the below commands

 

gunzip /usr/Spectrum/SS-DB-Backup/db_20171211_1705.SSdb.gz

cd /usr/Spectrum/SS

../SS-Tools/SSdbload -il -add 20 /usr/Spectrum/SS-DB-Backup/db_20171211_1705.SSdb

[sudheerreddy524]

Is this out put is correct 

Which option i need to select Y or N ?

 

[XXXX-SS-Tools]$ ./SSdbload -il -add 20 /usr/Spectrum/SS/SS-DB-Backup/db_20171211_1505.SSdb
The specified save file: /usr/Spectrum/SS/SS-DB-Backup/db_20171211_1505.SSdb ,
was created with the following options:
-c (catalog)
-m (models)

and indicates these landscapes loaded on these servers:

Landscape Hostname Port Precedence
---------- ---------------- ------ ----------
0x800000 XXXXX 0xbeef 10

***Warning***

You have chosen the '-i' option. This option is used to initialize
the database. This means ALL data in the database will be deleted. If
you choose to continue with this option, you must be prepared to load
your modeling catalog (model types and relations), before starting the
SpectroSERVER.

Do you really want to initialize the database? (Y or N):

[Silvio Okamoto]

Hello,

 

Why are you trying to restore from the db_20171208,1.after.SSdb file?

 

1. Make a new OnLine Backup on the primary SS.

2. Copy the $SPECROOT/SS-DB-Backup/db_20171211_hhmm.SSdb.gz (primary) file to the secondary SS, in $SPECROOT/SS/ directory

3. On the secondary SS, navigate to the $SPECROOT/SS/ directory and extract the file.

Syntax: gunzip db_20171211_hhmm.SSdb.gz

4. On the secondary SS, perform the restore operation.

Syntax: ../SS-Tools/SSdbload -il a 20 db_20171211_hhmm.SSdb

 

Thanks,

Silvio

[Jason Meader]

Also make sure you aren't the root user.  You need to be the spectrum install owner user...

[sudheerreddy524]

Is this out put is correct 

Which option i need to select Y or N ?

 

[XXXX-SS-Tools]$ ./SSdbload -il -add 20 /usr/Spectrum/SS/SS-DB-Backup/db_20171211_1505.SSdb
The specified save file: /usr/Spectrum/SS/SS-DB-Backup/db_20171211_1505.SSdb ,
was created with the following options:
-c (catalog)
-m (models)

and indicates these landscapes loaded on these servers:

Landscape Hostname Port Precedence
---------- ---------------- ------ ----------
0x800000 XXXXX 0xbeef 10

***Warning***

You have chosen the '-i' option. This option is used to initialize
the database. This means ALL data in the database will be deleted. If
you choose to continue with this option, you must be prepared to load
your modeling catalog (model types and relations), before starting the
SpectroSERVER.

Do you really want to initialize the database? (Y or N):

[sudheerreddy524]

Is this out put is correct 

 

Which option i need to select Y or N ?

 

[XXXX-SS-Tools]$ ./SSdbload -il -add 20 /usr/Spectrum/SS/SS-DB-Backup/db_20171211_1505.SSdb
The specified save file: /usr/Spectrum/SS/SS-DB-Backup/db_20171211_1505.SSdb ,
was created with the following options:
-c (catalog)
-m (models)

and indicates these landscapes loaded on these servers:

Landscape Hostname Port Precedence
---------- ---------------- ------ ----------
0x800000 XXXXX 0xbeef 10

***Warning***

You have chosen the '-i' option. This option is used to initialize
the database. This means ALL data in the database will be deleted. If
you choose to continue with this option, you must be prepared to load
your modeling catalog (model types and relations), before starting the
SpectroSERVER.

Do you really want to initialize the database? (Y or N):

[sirha02]

Hi,

As Jay mentioned, you would need to be in SS directory.

Run the commands as below:

cd /usr/Spectrum/SS

../SS-Tools/SSdbload -il -add 20 /usr/Spectrum/SS-DB-Backup/db_20171211_1505.SSdb

Press Y and hit enter when you are asked do u want to initialize database.

[Shane Ryan]

As Jay and Hamza mentioned, you would need to be in SS directory and you are in the SS-Tools directory.

 

Run the commands as below:

 

cd /usr/Spectrum/SS

../SS-Tools/SSdbload -il -add 20 /usr/Spectrum/SS-DB-Backup/db_20171211_1505.SSdb

 

Press Y and hit enter when you are asked do u want to initialize database