Check: Verify data files are recoverable

On latest ORAchk 12.1.0.2.4 check "Verify data files are recoverable" is faulty. I see FAIL on 11.2.0.4.6 DB even when there are all datafiles with unrecoverable_change# = 0 (and also db_unrecoverable_scn_tracking=TRUE by default).

 

Check used to detect this is not perfect ..

 

select 'unrecoverable_data_files = '||count(file#) from v$datafile where unrecoverable_time is not null;

 

This SQL should be also extended to check if there is an "unrecoverable_change# != 0" since it will track SCN of the NOLOGGING change.

 

Regards,

Stanislav