orachk - Verify data files are recoverable always failed
Hi
With the latest version of AHF, we are now running orachk on a daily basis, trying to get read of most of the issue detected by the tools.
But there is one, I don't understand how to solve.
Orachk, detect the following issue :
Maximum Availability Architecture (MAA) Scorecard
Outage Type | Status | Type | Message | Status On | Details | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
It seems to run the following query on the db :
select file#, unrecoverable_time, unrecoverable_change# from v$datafile where unrecoverable_time is not null;
That return