Oracle Data File Errors Test
The most common reasons for data file errors are corrupted blocks and invalid blocks. Both these can cause damage to portions of the database or the whole database, and can thus result in minimal to heavy loss of data. This is why, you should waste no time in identifying the error-prone data files and in doing all that is necessary to clear the errors and salvage the data. The Oracle Data File Errors test can play a key role in this exercise.
This test combs all the data files on the target Oracle server for errors and reports the number of errors (if any). The test also provides the complete details of every error, thus enabling a speedy and effective resolution.
This test is disabled by default. To enable the test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Oracle Database as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the << button to move the test to the ENABLED TESTS list. Finally, click the Update button.
Target of the test : An Oracle server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for the Oracle server being monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Error files count: |
Indicates the number of data file errors that have occurred. |
Number |
Ideally the value of this measure should be zero. The detailed diagnosis of this measure indicates the File number, Status, Error, Recover and the Tablespace name for each error that has occurred in the datafiles. |