>-----Original Message----- >From: Dirk Vleugels [mailto:dvl@;2scale.net] >Sent: Montag, 11. November 2002 16:44 >To: Brunzema, Martin >Subject: RE: BAD LOG PAGE > > >Hi, > >On Mon, 2002-11-11 at 11:48, Brunzema, Martin wrote: >> 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 > >Did so. No go. > >> 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. > >Is there any documentation available? Anyways, i played around. After a >complete Logcheck i find the following in the diag.prt: >[.....] > >LOGPAGE 242996/34B50300 (used: 8168 bytes, 100%) [page 1022] > > > > >LOGPAGE 242997/35B50300 (used: 8168 bytes, 100%) [page 1023] >*** Error -902: I/O error > >16:39:23 >COMMIT WORK RELEASE >SESSION END > >> 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. > >Sure, but: It seems that the error in the log is a older one (which got >triggered due to the re-start). Even 1week old fs-dumps fail with the >same error message at startup .... > >We're currently getting older dumps from tape ....
For a startup of the database you need the log-device for rollback and redo of open transactions. If the BadPage Error persists even in an older backup then it seems to be a real hardware error, because the probability that you need to access the same page as in your original system is low. So please check your hardware. Also use the autolog-feature. Pages saved by our backup-routines are checked before backing them up, so errors are found earlier. regards, Martin -- Martin Brunzema SAP AG (SAP DB Kernel) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
