Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Checking data integrity

    Checking data integrity

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Checkboxes and Arrows in the Group Node
      • Checking HOL 852 $$a values
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved