Hi,

due to a hard reset (during heavy load going on for 24 hours), the LOG
Devspace got hosed:

Remark: this is a test/benchmark db, so no valuable data would be lost.
But i would like to solve this issue anyways.....

knldiag.err during restart:

11-07 20:24:31� 3558 ERR 54001 I/O����� page
C321050004090400...C32105000409040011-07 20:24:31� 3558 ERR 54001
I/O����� BAD LOG PAGE 417
11-07 20:24:31� 3558 ERR 54001 I/O����� on DEVNO 1 DEV_OFFSET 417
11-07 20:24:31� 3558 ERR 53016 I/O����� /local/sapdb/TST/DISKL001
11-07 20:24:32� 3558 ERR 51080 SYSERROR -9030 Message not available

There is a HW-RAID involved and nothing in the linux messages logs, so i
guess this is a logical error.....

dbmcli on TST>db_warm
ERR
-24988,ERR_SQL: sql error
-9030,Message not available

Wiping the log doesn't work:

dbmcli on TST>util_execute diagnose devspace enable
'/local/sapdb/TST/DISKL001'
OK

---
dbmcli on TST>util_execute clear log
ERR
-24988,ERR_SQL: sql error
-7044,Message not available

Any chance to solve this without a restore? There is a filesystem dump
available (2 days old), but no db-backup (with or without checkpoint).

Regards,
Dirk



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to