Maxdb error while starting the DB

[Former Member]

Hi Everybody ,

I restored the Max DB after sucessfull recovery, when i try to start the database online,i am getting below error

./dbmcli -d ECQ -u control,axonlab1 db_restart

ERR

-24988,ERR_SQL: SQL error

-9407,System error: unexpected error

3,Database state: OFFLINE

Internal errorcode, Error code 6433 "system_error"

20030,Parameter LOG_SEGMENT_SIZE is greater then size of log area. 131071 < 0 + 213333(seg size)

20028,Initialization of log for 'restart' failed with 'LogSaveDistanceTooLarge'

again i tried to restore the database again getting the below error

i am getting the error -104 DBM command impossible at this time14,the critical state 'backup' could not be entered because T33 has already entered

can you someone help to get db started.

Regards,

Balaji Vikram.P

[former_member229109]

Hello Balaji Vikram.P,

-> What is the version of your database?

-> Please update with output of the commands:

    ./dbmcli -d ECQ -u control,axonlab1 param_getvolsall

    ./dbmcli -d ECQ -u control,axonlab1 param_directget  LOG_SEGMENT_SIZE

-> If the value 0 is specified for the database parameter AutoLogBackupSize/LOG_SEGMENT_SIZE, the database system automatically calculates 1/3 of the entire log area.

Run:

./dbmcli -d ECQ -u control,axonlab1 param_directput  LOG_SEGMENT_SIZE 0

./dbmcli -d ECQ -u control,axonlab1 param_checkall

./dbmcli -d ECQ -u control,axonlab1 param_directget  LOG_SEGMENT_SIZE 

./dbmcli -d ECQ -u control,axonlab1 db_online

Regards, Natalia Khlopina