>-----Original Message----- >From: Dirk Vleugels [mailto:dvl@;2scale.net] >Sent: Freitag, 8. November 2002 15:01 >To: [EMAIL PROTECTED] >Subject: BAD LOG PAGE > > >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). >
Hi Dirk, first you should try again a db_warm, because sometimes RAID-Systems return temporarily errors. If this doesn't help, a log page is really defect. This can be a result of the hard reset, which could have interrupted a page-write. By this a page wasn't written completely and thus the integrity-rules are violated. One could check this by using x_diagnose. If you don't have a data/log-backup, you can try to restore the filesystem-dump. We do not recommend filesystem-backups, because the database works independent from the filesystem-backup, so you do not really know, which state you are backing up. regards, Martin -- Martin Brunzema SAP AG (SAP DB Kernel) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
