Subject | Identifying damanged pages |
---|---|
Author | Josef Kokeš |
Post date | 2012-03-29T11:30:15Z |
Hi!
Due to hardware malfunction, my database got damaged. GFIX (-v -f -i)
tells me that a database has 1 "record level error", 9 "data page
errors", 41 "index page errors" and 322 "database page errors".
I am not concerned about Index page errors - is seems obvious these will
get fixed by a backup/restore cycle. But I would like to know:
1) What do the individual error types mean?
2) Is there a way to identify which tables were affected? I can live
with damage to many tables, but not all of them.
Thanks,
Josef Kokes
Due to hardware malfunction, my database got damaged. GFIX (-v -f -i)
tells me that a database has 1 "record level error", 9 "data page
errors", 41 "index page errors" and 322 "database page errors".
I am not concerned about Index page errors - is seems obvious these will
get fixed by a backup/restore cycle. But I would like to know:
1) What do the individual error types mean?
2) Is there a way to identify which tables were affected? I can live
with damage to many tables, but not all of them.
Thanks,
Josef Kokes