Fix index corruption

At the first indication of corruption, run the oncheck -cI command to determine if corruption exists in the index.

If you check indexes while the database server is in online mode, oncheck detects the corruption but does not prompt you for repairs. If corruption exists, you can drop and recreate the indexes using SQL statements while you are in online mode (the database server locks the table and index). If you run oncheck -cI in quiescent mode and corruption is detected, you are prompted to confirm whether the utility attempts to repair the corruption.


Copyright© 2019 HCL Technologies Limited