2-node RAC on 11.2.0.3.5 on Solaris Sparc 11.1
When I run this query:
SQL> select file#, unrecoverable_time, unrecoverable_change# from v$datafile where unrecoverable_time is not null;
FILE# UNRECOVER UNRECOVERABLE_CHANGE#
---------- --------- ---------------------
5 10-NOV-12 1774222
94 10-NOV-12 15263028
106 10-NOV-12 15262676
240 10-NOV-12 15258111
244 10-NOV-12 15259701
250 10-NOV-12 15262273
254 10-NOV-12 15260190
256 10-NOV-12 15261471
291 10-NOV-12 1776582
318 10-NOV-12 15256886
349 10-NOV-12 15261876
351 10-NOV-12 15260644
12 rows selected.
...I am told that there are 12 data files which are unrecoverable. This is something the raccheck utility picks up on, and gives me a "fail" for data file recoverability as a result.
But the database is in force logging mode (switched on in about June this year). So when I check with RMAN:
RMAN> report unrecoverable;
using target database control file instead of recovery catalog
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------
RMAN>
...I get told that nothing is unrecoverable, which is what I originally expected.
Is there anything I can do to clear the data in dba_data_files so that the raccheck utility won't choke on it every time? Or is there a genuine problem which raccheck is picking up that RMAN is unaware of?