Kbase 20461: How to Detect Different Types of Corruptions in Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/09/2006 |
|
Status: Unverified
GOAL:
Indicators that help uncover types of corruption within a database.
FIX:
The levels of corruption and indicators that help you detect it are as follows:
Corruption Type:
Block Level corruption
Indicators:
1124 message
Method of Detection:
PROBKUP, PROCOPY, or any process that reads the entire database.
Corruption Type:
Block content Corruption
Indicators:
Core dumps
Methods of Detection:
dbanalys, idxbuild, Corruption etc.
Corruption Type:
Record Corruption
Indicators:
137, or other record based msg
Methods of Detection:
dbanalys, idxbuild
Corruption Type:
Index Corruption or Record Content Corruption
Indicators:
1422, or other index based msg
Methods of Detection:
IDFIX, IDXCHK
The above table is structured with the least intensive checks at the top and the most intensive types of checks at the bottom.
In general, the more intensive checks also perform the same checks as those that are done at the previous level.
For example, idxcheck performs both index and record level checking as well as block level checking, while dbanalys, does record checking, and block checking, but not index checking.