Checking data integrity

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20

Description:
We had a system crash and want to check the integrity of our data. Should we run the indexing jobs to rebuild the Aleph indexes?

Resolution:
Oracle is set up to constantly check and insure data integrity.

Running the Aleph indexing jobs is unnecessary and undesirable. I suggest that you use the SQL queries shown in KB 8192-6423 to determine if the necessary tables/indexes are present.

Util a/17/15/4 ("Validate Index Structure") could also be used, but I would do this only in a case where it seems there might be a problem.

There's an Oracle "dbv" utility: DBVERIFY is an external command-line utility that performs a physical data structure integrity check on an offline database. It can be used against backup files and online files (or pieces of files). You use DBVERIFY primarily when you need to ensure that a backup database (or datafile) is valid before it is restored or as a diagnostic aid when you have encountered data corruption problems. See http://download.oracle.com/docs/cd/B10500_01/server.920/a96652/ch13.htm for more.

Article last edited: 10/8/2013