DB Crash -> Recovery fails

[davos12]

Hi,

I am looking for help to configure and start a Recovery with initialization.

I have gone through the steps for Recovery with initialization (restore from a backup medium) but it fails.

The error text:

-24988, ERR_SQL:

-3068, Missmatch of parameter configuration between backup and instance

6,Error in backup task occured, Errorcode 5224 "wrong_configuration"

Also i've been throug the link https://wiki.sdn.sap.com/wiki/x/GkM and SAP Note 01377148.

We are using the database as sap content Server.

The dbm.utl listed now:

-

---

Date Time Message-Text

-

---

2011-08-10 13:04:01 4E4265A10001 0000 IC1 CREATE INSTANCE WITH RESTORE DATA FROM 'e:\backup\DB\dbtda40sdb.dat' FILE BLOCKSIZE 8 MEDIANAME 'complete'

2011-08-10 14:55:30 4E4265A10001 0001 RET RETURNCODE -3068

2011-08-10 14:55:30 4E4265A10001 0002 TAP DATE..............

2011-08-10 14:55:30 4E4265A10001 0003 TAP TIME.............. \b:ac:ku

2011-08-10 14:55:30 4E4265A10001 0004 TAP SERVERDB.......... \DB\dbtda40sdb.dat

2011-08-10 14:55:30 4E4265A10001 0005 TAP SERVERNODE........

2011-08-10 14:55:30 4E4265A10001 0006 TAP KERNEL VERSION....

2011-08-10 14:55:30 4E4265A10001 0007 TAP PAGES TRANSFERRED. ***********

2011-08-10 14:55:30 4E4265A10001 0008 TAP PAGES LEFT........ ***********

2011-08-10 14:55:30 4E4265A10001 0009 TAP NO OF VOLUMES..... ***********

2011-08-10 14:55:30 4E4265A10001 000A TAP MEDIA NAME........

2011-08-10 14:55:30 4E4265A10001 000B TAP TAPE NAME.........

2011-08-10 14:55:30 4E4265A10001 000C TAP TAPE ERRORTEXT....

2011-08-10 14:55:30 4E4265A10001 000D TAP TAPE LABEL........

2011-08-10 14:55:30 4E4265A10001 000E TAP IS CONSISTENT..... TRUE

2011-08-10 14:55:30 4E4265A10001 000F TAP FIRST IO SEQUENCE. ***********

2011-08-10 14:55:30 4E4265A10001 0010 TAP LAST IO SEQUENCE.. ***********

2011-08-10 14:55:30 4E4265A10001 0011 TAP DBSTAMP1 DATE..... - -

2011-08-10 14:55:30 4E4265A10001 0012 TAP DBSTAMP1 TIME..... : :

2011-08-10 14:55:30 4E4265A10001 0013 TAP DBSTAMP2 DATE..... - -

2011-08-10 14:55:30 4E4265A10001 0014 TAP DBSTAMP2 TIME..... : :

2011-08-10 14:55:30 4E4265A10001 0015 TAP BD PAGE COUNT..... ***********

2011-08-10 14:55:30 4E4265A10001 0016 TAP TAPEDEVICES USED.. ***********

2011-08-10 14:55:30 4E4265A10001 0017 TAP DB_IDENT..........

2011-08-10 14:55:30 4E4265A10001 0018 TAP MAX USED DATA PNO. ***********

2011-08-10 14:55:30 4E4265A10001 0019 TAP CONV PAGE COUNT... ***********

2011-08-10 15:05:40 001A RDB RESTORE DATA CANCEL

2011-08-10 15:05:40 001B RET RETURNCODE -104

2011-08-10 15:05:47 4E42822B0004 0000 RST RESTART

-

---

current write position -

---

[Former Member]

Daniel

I am not sure why are you deleting the database.

You can perform recovery without deleting the database.

Also i assume you are using latest dbmgui . Previous version of dbmgui has some bugs in it and recovery use to fail sometime.

Cheers !

Manish

Edited by: Manish Jain on Oct 6, 2011 4:39 PM

[davos12]

Hi erverybody,

thanx for your ideas. The DB crash is solved by another backupfile. My first backupfile 2543 was corrupt. After the change to backupfile 2535 everything was fine.

Have nice day.

Greetings

Daniel

[Former Member]

Mark this problem as resolved

Cheers !

Manish

[markus_doehr2]

Please check KnlMsg (using protconv) or Knldiag message file for more information about the error.

Markus

[davos12]

1. Did the complete backup successful?

The backup history listed the backupfile as succesful , type complete backup, but if you check the medium it is corrupt.

error text

-24988 Sql error [backup_restore_check "DB" Data -7900 , different block size, first page of block is nil.

2. Here the KnlMessage comming soon.

[davos12]

Here the KernelMessage

-

---

2011-08-12 11:50:14 --- Starting GMT 2011-08-12 09:50:14 7.6.00 Build 018-123-119-055

2011-08-12 11:50:29 0x130C ERR 51080 SYSERROR -9407 unexpected error

2011-08-12 11:50:29 0x130C ERR 3 Admin Kernel_Administration.cpp:606

2011-08-12 11:50:29 0x130C ERR 3 Admin 2011-08-12 11:50:29 Admin Error 3

2011-08-12 11:50:29 0x130C ERR 3 Admin Database state: OFFLINE

2011-08-12 11:50:29 0x130C ERR 3 Admin + Kernel_Administration.cpp:723

2011-08-12 11:50:29 0x130C ERR 3 Admin + 2011-08-12 11:50:29 Admin Warning 20022

2011-08-12 11:50:29 0x130C ERR 3 Admin - ACTIVATE is missing

2011-08-12 11:50:29 0x82C ERR 7 Messages Msg_List.cpp:3617

2011-08-12 11:50:29 0x82C ERR 7 Messages 2011-08-12 11:50:29 Messages Error 7

2011-08-12 11:50:29 0x82C ERR 7 Messages Begin of dump of registered messages

2011-08-12 11:50:29 0x82C ERR 8 Messages Msg_List.cpp:3636

2011-08-12 11:50:29 0x82C ERR 8 Messages 2011-08-12 11:50:29 Messages Error 8

2011-08-12 11:50:29 0x82C ERR 8 Messages End of the message list registry dump

2011-08-12 11:50:29 0x998 ERR 20125 RTE RTE_ExternalCall.cpp:877

2011-08-12 11:50:29 0x998 ERR 20125 RTE 2011-08-12 11:50:29 RTE Error 20125

2011-08-12 11:50:29 0x998 ERR 20125 RTE Database automatic restart failed

2011-08-12 11:50:30 ___ Stopping GMT 2011-08-12 09:50:30 7.6.00 Build 018-123-119-055

2011-08-12 11:51:20 --- Starting GMT 2011-08-12 09:51:20 7.6.00 Build 018-123-119-055

2011-08-12 11:56:13 0x12A0 ERR 52012 RESTORE error occured, basis_err 5224

[markus_doehr2]

> 2011-08-12 11:50:14 --- Starting GMT 2011-08-12 09:50:14 7.6.00 Build 018-123-119-055

> 2011-08-12 11:50:29 0x130C ERR 51080 SYSERROR -9407 unexpected error

There are a few documented problems with -9407 and they are fixed in newer versions of the database.

Is there any reason why you use such an old build?

Markus

[davos12]

Is there any reason why you use such an old build?

No.

What is the way to upgrade the Kernel 7.6?

[davos12]

The sofware upgrade for the database is in progress. Results are following ...

[davos12]

Hi,

we did an upgrade of the database software, but it doesn't work.

7.6.06 Build 020-123-243-176

2011-08-15 11:21:19 0x31C ERR 51080 SYSERROR -9407 unexpected error

2011-08-15 11:21:19 0x31C ERR 3 Admin Database state: OFFLINE

2011-08-15 11:21:19 0x31C ERR 20025 Admin + ACTIVATE is missing

2011-08-15 11:21:19 0x11DC ERR 7 Messages Begin of dump of register

Which kernel / patch is the right one ?

Greetings

Daniel

[markus_doehr2]

> 7.6.06 Build 020-123-243-176

> 2011-08-15 11:21:19 0x31C ERR 51080 SYSERROR -9407 unexpected error

> 2011-08-15 11:21:19 0x31C ERR 3 Admin Database state: OFFLINE

> 2011-08-15 11:21:19 0x31C ERR 20025 Admin + ACTIVATE is missing

> 2011-08-15 11:21:19 0x11DC ERR 7 Messages Begin of dump of register

Try to activate the database using DBMGUI or by executing

dbmcli -u control,<controlpassword> -d <SID> db_activate <dbmuser>,<dbmpassword>

If that works put the database back to admin mode and try to recover again.

Markus

[Former Member]

Hi Daniel,

> 2011-08-10 14:55:30 4E4265A10001 0001 RET RETURNCODE -3068

> -3068, Missmatch of parameter configuration between backup and instance

Looks like, the database parameters from the data backup/source are not compatible with your target database.

Any changes on parameters: CACHE_SIZE/CacheMemorySize (mostly less value in target DB)

Make sure you keep the same value as in Backup. I guess, the DBMGUI tool ask the confirmation on parameter set before intilaizing and restore.

You may also check knldiag.

~sagar

[davos12]

Hi guys,

Thx for the ideas, Here are the results.

Try to activate the database using DBMGUI or by executing

dbmcli -u control,<controlpassword> -d <SID> db_activate <dbmuser>,<dbmpassword>

This command works: C:\Dokumente und Einstellungen\sapcon>dbmcli -u dbm,dbm -d SDB db_activate superdba,admin

OK

But the recovery fails: Here the LOGS

knldia.err

7.6.06 Build 020-123-243-176

2011-08-15 19:13:42 0x590 ERR 52012 RESTORE error occured, basis_err 5224

2011-08-15 19:13:42 0x590 ERR 6 Recovery Data recovery failed

2011-08-15 19:13:42 0x590 ERR 17 SrvTasks + Servertask Info: because Error in backup task occured

2011-08-15 19:13:42 0x590 ERR 10 SrvTasks + Job 1 (Backup / Restore Medium Task) [executing] WaitingT38 Result=5224

2011-08-15 19:13:42 0x590 ERR 6 KernelCo + Error in backup task occured, Error code 5224 "wrong_configuration"

dbm.prt

2011-08-15 19:13:42 0x00001364 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'db_activate' has ended and failed with return code -24988.

0x00001364 ERR -24988 DBMSrv ERR_SQL: SQL error

0x00001364 ERR -24778 DBMSrv -3068,Mismatch of parameter configuration between backup and instance

0x00001364 ERR -24778 DBMSrv 6,Data recovery failed

0x00001364 ERR -24778 DBMSrv 17,Servertask Info: because Error in backup task occured

0x00001364 ERR -24778 DBMSrv 10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT38 Result=5224

0x00001364 ERR -24778 DBMSrv 6,Error in backup task occured, Error code 5224 "wrong_configuration"

Edited by: Daniel Vosberg on Aug 15, 2011 8:26 PM

[davos12]

Hi

here the next idea:

"Looks like, the database parameters from the data backup/source are not compatible with your target database"

Yes, it seems so and

" I guess, the DBMGUI tool ask the confirmation on parameter set before intilaizing and restore."

First I drop the old instance SDB

Second I create a new database SDB and I take the parameters from backup medium

Third I got the parameters as dialog, but I only confirm it. ->So, I will study them.

Fourth Database is created and ADMIN state is on

Fifth I start recovery with initialisation

In the parameter dialog first i can read an value. Second I can read a new value.

Do I have discard the new value ?

Greetings

Daniel

Edited by: Daniel Vosberg on Aug 15, 2011 9:20 PM

[davos12]

Hi guys,

how do I get professional services to solve this DB crash.

Does anybody know ?

Greetings

Daniel

[former_member229109]

Hello Daniel,

1. If you are SAP customer => please create the SAP message and get SAP support.

2. Please update with additional details-summary:

• What is the version of the source database?

Was the databackup created successfuly?

• What is the current version of the target database?

• If you are using DBMGUI => what is the DBMGUI version?

• Was backup_restore_check of the databackup unsuccessful?

Regards, Natalia Khlopina

[davos12]

Hi Natalia,

Here is my update for you.

1. If you are SAP customer => please create the SAP message and get SAP support.

This SAP System YPC and SAP Content Server are no longer in a productive mode.The company has been sold. So it is not longer possible to create a new OSS Support message.

But the SAP System YPC is still online in order to lookup old technical drafts.

2. Please update with additional details-summary:

• What is the version of the source database?

2011-08-10 09:55:17 4E4239640001 0006 TAP KERNEL VERSION.... Kernel 7.6.00 Build 018-123-119-055

Was the databackup created successfuly?

Yes it is.

• What is the current version of the target database?

MSG: update from "7.6.0.18" to "7.6.06.20" allowed

• If you are using DBMGUI => what is the DBMGUI version?

7.6.00.19

• Was backup_restore_check of the databackup unsuccessful?

I did an check with dbmgui - Check -> Backupmedium

I got a popup message , which I don't understand.

You can see it here.

[Popup Message|https://skydrive.live.com/?cid=7D4AC1FA6D19EFEE&id=7D4AC1FA6D19EFEE%21472#cid=7D4AC1FA6D19EFEE&id=7D4AC1FA6D19EFEE%21473]

Just for information :

• If it helps, I can show pictures online.

• You can visit the DB Crash by using the software Teamwear.

Regards, Daniel Vosberg

[davos12]

Hi Natalia,

• Was backup_restore_check of the databackup unsuccessful?

I see the Popup message

[Ceck database backupfile|https://skydrive.live.com/#!/?cid=7d4ac1fa6d19efee&sc=documents&uc=1&id=7D4AC1FA6D19EFEE%21472!cid=7D4AC1FA6D19EFEE&id=7D4AC1FA6D19EFEE%21476&sc=documents]

so I think the databackup file 2543 is OK.

Greetings

Daniel

[davos12]

Here are my clicks to restore database. There is no different between Kernel 7.6.0.0.18 and 7.6.0.6.20

[My clicks to restore|https://skydrive.live.com/?cid=7D4AC1FA6D19EFEE&id=7D4AC1FA6D19EFEE%21481&sc=documents#cid=7D4AC1FA6D19EFEE&id=7D4AC1FA6D19EFEE%21495&sc=documents]

Greetings

Daniel

[Former Member]

Which mode you are doing recovery initialization and the name of backup medium is complete data or what? can you check?

[davos12]

*Hi,*

*The filename is 'e:\backup\DB\dbtda40sdb.dat' .*

*The name of the backup is complete.*

*the Mode is ADMIN.*

*Greetings*

*Daniel*

[Former Member]

Did the complete backup successful?