Checker run found %d new persistent data failures

>> Thursday, 21 July 2011

I have been getting the warning "Checker run found %d new persistent data failures" in my alert log when renaming datafiles but I struggled to get information about it's source and whether there was a true issue.

The Oracle® Database Administrator's Guide 11g Release 2 (11.2) (Chapter 9 Managing Diagnostic Data, Running Health Checks with Health Monitor) covers the Health Monitor but I didn't find it very helpful.


I managed to recreate the error in test:

CREATE TABLESPACE TEST DATAFILE
'/u03/oradata/test01.dbf' SIZE 64M AUTOEXTEND OFF  LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 32K
SEGMENT SPACE MANAGEMENT AUTO  FLASHBACK ON;
alter tablespace test offline;
cp '/u03/oradata/test01.dbf' '/u03/oradata/test_new01.dbf'
alter tablespace test rename datafile '/u03/oradata/test01.dbf' to '/u03/oradata/test_new01.dbf';
SQL> begin
DBMS_HM.RUN_CHECK('DB Structure Integrity Check', 'my_run');
 end;
 /
PL/SQL procedure successfully completed.
SQL> SELECT DBMS_HM.GET_RUN_REPORT('my_run') FROM DUAL;
alter tablespace test online;
drop tablespace test including datafile;

The alert log reported:
Checker run found 1 new persistent data failures

The report was:
SQL> SELECT DBMS_HM.GET_RUN_REPORT('my_run') FROM DUAL;

DBMS_HM.GET_RUN_REPORT('MY_RUN')
------------------------------------------------------------------------------
Basic Run Information
Run Name : my_run
Run Id : 6421
Check Name : DB Structure Integrity Check
Mode : MANUAL
Status : COMPLETED
Start Time : 2011-07-04 16:19:42.391361 +01:00
End Time : 2011-07-04 16:19:42.423941 +01:00
Error Encountered : 0
Source Incident Id : 0
Number of Incidents Created : 0

Input Paramters for the Run
Run Findings And Recommendations
Finding
Finding Name : Offline Datafile
Finding ID : 6425
Type : FAILURE
Status : OPEN
Priority : HIGH
Message : Datafile 32: '/u03/oradata/test_new01.dbf' is offline
Message : Some objects in tablespace TEST might be unavailable
Finding
Finding Name : Tablespace Offline
Finding ID : 6428
Type : FAILURE
Status : OPEN
Priority : HIGH
Message : Tablespace 28: 'TEST' is offline
Message : Some objects in tablespace TEST might be unavailable


In this particular case, a tablespace is brought offline which is considered an issue as the data in the tablespace is no longer available.
It is also considered 'persistent' because a offline tablespace is not brought online automatically, it needs manual intervention.

By default the database runs the Health Check on a regular basis.  You can see these reactive runs via:

select * from V$HM_RUN;
If you want to see the results of a run in particular then do:

SET LONG 100000;
SET LONGCHUNKSIZE 1000SET PAGESIZE 1000SET LINESIZE 512SELECT DBMS_HM.GET_RUN_REPORT('HM_RUN_XXXX') FROM DUAL;

Where 'XXXX' is the number of the run taken from name in V$HM_RUN.

As there was limited information coming up in searches on the error, I hope this helps you get a little further with your quest to decipher it.

0 comments:

  © Blogger template Simple n' Sweet by Ourblogtemplates.com 2009

Back to TOP