Data corruption diagnostic engine

• US 8,074,103 B2
• Filed: 10/17/2008
• Issued: 12/06/2011
• Est. Priority Date: 10/19/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Dilman, Mark, Stewart, Michael James, Hu, Wei-Ming, Kuchibhotla, Balasubrahmanyam, Susairai, Margaret, Sun, Hubert Ken
• Primary Examiner(s): Baderman, Scott
• Assistant Examiner(s): Ko, Chae
• Application Number:
  US12/253,873
• Publication Number:
  US 20090106603A1
• Time in Patent Office: 1,145 Days
• Field of Search: 714/25, 707/690
• US Class Current: 714/6.1
• CPC Class Codes: G06F 11/0727 in a storage system, e.g. in a DASD or network based storage system drivers for digital recording or reproducing units G06F3/06; circuits for error detection or correction within digital recording or reproducing units G11B20/18; for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS], H04L67/1097
• CPC Class Codes: G06F 11/0793 Remedial or corrective actions recovery from an exception in an instruction pipeline G06F9/3861; by retry G06F11/1402; for recovering from a failure of a protocol instance or entity H04L69/40
• CPC Class Codes: G06F 11/1004 to protect a block of data words, e.g. CRC or checksum G06F11/1076 takes precedence; security arrangements for protecting computers or computer systems against unauthorized activity G06F21/00
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: G06F 11/327 Alarm or error message display

Abstract

A computer is programmed to execute a diagnostic procedure either on a pre-set schedule or asynchronously in response to an event, such as an error message, or a user command. When executed, the diagnostic procedure automatically checks for integrity of one or more portions of data in the computer, to identify any failure(s). In some embodiments, the failure(s) may be displayed to a human, after revalidation to exclude any failure that no longer exists.

Claims

1. A computer-implemented method to process a plurality of errors related to a data storage system, said errors arising from a plurality of storage structures in said data storage system, the method comprising:

accessing data by use of a storage structure;

using occurrence of a first error during said accessing to at least lookup and find an identity of a first diagnostic procedure to be executed;

wherein each error among the plurality of errors is associated with at least one diagnostic procedure among a plurality of predetermined diagnostic procedures;

checking integrity of data accessed using the storage structure from which said error arises by execution of the first diagnostic procedure;

wherein a failure that caused the first error to occur is identified by the execution of the first diagnostic procedure; and

storing in a computer memory, a set of failures, said set comprising said failure and additional failures;

wherein said additional failures, if existing in said storage structure, are identified by at least one of;

(a) said checking and (b) repeating said checking.

2. The method of claim 1 wherein:

said first diagnostic procedure is identified by use of at least a type of said first error to perform the lookup on a table.

3. The method of claim 1 wherein:

the first diagnostic procedure, when executed, verifies correctness of at least one value in at least one storage structure in the data storage system to automatically identify the failure that caused the first error.

4. The method of claim 1 further comprising:

determining, for each failure in the set of failures, an attribute indicative of impact of said each failure; and

storing in said computer memory, said attribute for said each failure.

5. The method of claim 1 wherein:

each diagnostic procedure verifies correctness of at least one value in one of said plurality of storage structures.

6. The method of claim 1 wherein said storing comprises saving to said memory, associated with each failure, at least:

priority of the failure;

a time of creation of said each failure;

a status of said each failure selected from a group consisting of open and closed; and

an identifier of software to revalidate said each failure.

7. The method of claim 1 further comprising:

revalidating each failure in said set of failures; and

mark said each failure as closed if said revalidating finds said each failure no longer exists in said data storage system.

8. The method of claim 1 wherein:

said storage structure comprises a file;

said checking verifies no corruption in at least a header of said file, followed by use of at least a portion of information in the file to verify no corruption or loss of a second storage structure.

9. The method of claim 1 wherein:

said system comprises a database management system; and

said storage structure comprises a data block of a database accessible via said database management system.

10. A computer-implemented method to process errors related to a data storage system, said errors arising from a plurality of storage structures in said data storage system, the method comprising:

checking integrity of data in a storage structure from which a first error arises;

wherein a failure, if existing in said storage structure, is identified by said checking; and

storing in a memory, a set of failures, said set comprising said failure and additional failures;

wherein said additional failures, if existing in said storage structure, are identified by at least one of;

(a) said checking and (b) repeating said checking;

prior to said checking integrity, determining whether a second error identical to said first error had occurred within a predetermined duration prior to said first error; and

performing said checking integrity only if a result of said determining is false.

11. A non-transitory computer-readable storage medium comprising instructions to one or more computers to process errors related to a data storage system, said errors arising from a plurality of storage structures in said data storage system, the instructions comprising:

instructions to check integrity of data in a storage structure from which an error arises;

wherein a first failure, if existing in said storage structure, is identified by execution of said instructions to check; and

instructions to store in a computer memory, a set of failures, said set comprising said first failure and a plurality of additional failures;

wherein said plurality of additional failures are identified by at least one of;

(a) execution of said instructions to check and (b) repetition of execution of said instructions to check;

wherein each failure has a type and each failure has at least one parameter;

instructions, to be executed prior to said instructions to check, to additionally check whether a second failure among said additional failures is of same type as said first failure; and

instructions to create a third failure with a third value for said parameter based on a first value of the first failure and a second value of the second failure;

wherein said third failure is included in said set by said instructions to store; and

wherein said third failure is identified in said computer memory as a parent of the first failure and the second failure.

12. The non-transitory computer-readable storage medium of claim 11 further comprising:

instructions to identify said instructions to check integrity, by use of at least said first error.

13. The non-transitory computer-readable storage medium of claim 11 wherein:

said instructions to check integrity comprise instructions to verify correctness of a value in at least a portion of the storage structure, to automatically identify said failure that caused the first error.

14. The non-transitory computer-readable storage medium of claim 11 further comprising:

instructions to determine, for each failure in the set of failures, an attribute indicative of impact of said each failure; and

instructions to store in said computer memory, said attribute for said each failure.

15. The non-transitory computer-readable storage medium of claim 11 further comprising:

instructions to store in said computer memory a priority of the failure;

instructions to store in said computer memory a time of creation of said each failure; and

instructions to store in said computer memory, an identifier of software to revalidate said each failure.

16. The non-transitory computer-readable storage medium of claim 11 wherein:

said data storage system comprises a database management system; and

said storage structure comprises a data block of a database accessible via said database management system.

17. A non-transitory computer-readable storage medium comprising instructions to one or more computers to process errors related to a data storage system, said errors arising from a plurality of storage structures in said data storage system, the instructions comprising:

instructions to check integrity of data in a first storage structure from which an error arises;

wherein a first failure, if existing in said first storage structure, is identified by execution of said instructions to check, said first failure having a type; and

instructions to store in a computer memory, a set of failures, said set comprising said first failure and a plurality of additional failures;

wherein said plurality of additional failures are identified by at least one of;

(a) execution of said instructions to check and (b) repetition of execution of said instructions to check;

wherein an additional failure is hereinafter “

second failure” and

said second failure is of said type of said first failure;

wherein said second failure is related to a second storage structure in said plurality of storage structures;

wherein said first storage structure and said second storage structure are comprised in a third storage structure in said plurality of storage structures; and

instructions to create a third failure based at least partially on information related to said first failure and said second failure.

18. The non-transitory computer-readable storage medium of claim 17 further comprising:

instructions to identify said instructions to check integrity, by use of at least said first error.

19. The non-transitory computer-readable storage medium of claim 17 wherein:

said instructions to check integrity comprise instructions to verify correctness of a value in at least a portion of the storage structure, to automatically identify said failure that caused the first error.

20. The non-transitory computer-readable storage medium of claim 17 further comprising:

instructions to determine, for each failure in the set of failures, an attribute indicative of impact of said each failure; and

instructions to store in said computer memory, said attribute for said each failure.

21. The non-transitory computer-readable storage medium of claim 17 further comprising:

instructions to store in said computer memory a priority of the failure;

instructions to store in said computer memory a time of creation of said each failure; and

instructions to store in said computer memory, an identifier of software to revalidate said each failure.

22. The non-transitory computer-readable storage medium of claim 17 wherein:

said data storage system comprises a database management system; and

said first storage structure comprises a data block of a database accessible via said database management system.

23. A non-transitory computer-readable storage medium comprising instructions to process a plurality of errors related to a data storage system, said data storage system comprising a plurality of storage structures, each storage structure comprising data stored persistently in non-volatile storage media of the data storage system, the computer-readable storage medium comprising:

instructions to access data using a storage structure;

instructions to use a first error occurring during execution of the instructions to access to at least lookup and find an identity of a first diagnostic procedure to be executed;

wherein each error among the plurality of errors is associated with at least one diagnostic procedure among a plurality of predetermined diagnostic procedures;

instructions to check integrity of data by execution of the first diagnostic procedure thereby to identify a failure that caused the first error;

instructions to store in a computer memory at least said failure.

24. A non-transitory computer-readable storage medium comprising instructions to process a plurality of errors related to a data storage system, said data storage system comprising a plurality of storage structures, each storage structure comprising data stored persistently in non-volatile storage media of the data storage system, the computer-readable storage medium comprising:

instructions to check integrity of data in a storage structure from which said first error arises, thereby to identify a failure of said storage structure;

instructions to store in a computer memory, a set of failures, said set comprising said failure and additional failures; and

instructions to determine whether a second error identical to said first error occurred within a predetermined duration prior to said first error, and only if a result thereof is false invoke performance of said instructions to check integrity.

25. The computer-readable storage medium of claim 24 further comprising:

instructions to identify said instructions to check integrity by use of at least said error.

26. The computer-readable storage medium of claim 24 wherein:

said instructions to check integrity comprise instructions to verify correctness of a value in at least a portion of the storage structure to automatically identify said failure that caused the first error.

27. The computer-readable storage medium of claim 24 further comprising:

instructions to determine, for each failure in the set of failures, an attribute indicative of impact of said each failure; and

instructions to store, in said computer memory, said attribute for said each failure.

28. The computer-readable storage medium of claim 24 further comprising:

instructions to store, in said computer memory, a priority of the failure;

instructions to store, in said computer memory, a time of creation of said each failure; and

instructions to store, in said computer memory, an identifier of software to revalidate said each failure.

29. The non-transitory computer-readable storage medium of claim 24 wherein:

said data storage system comprises a database management system; and

said storage structure comprises a data block of a database accessible via said database management system.

30. A database management system, implemented at least partially by a computer, to correct a plurality of predetermined errors that corrupt data in a database in the computer, the database management system comprising:

means for accessing data using a storage structure;

means for using a first error occurring during use of the means for accessing to at least lookup and find an identity of a first diagnostic procedure to be executed;

wherein each error among the plurality of errors is associated with at least one diagnostic procedure among a plurality of predetermined diagnostic procedures;

means for checking integrity of data by execution of the first diagnostic procedure thereby to identify a failure that caused the first error;

means for storing in a computer memory at least said failure.