AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC)

MOSC Banner

orachk - Verify data files are recoverable always failed

edited Sep 9, 2020 3:27PM in AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC) 1 commentAnswered

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 TypeStatusTypeMessageStatus OnDetails
CRITICALSQL CheckThe data files should be recoverableAll Databases

Hide

Verify data files are recoverable

 

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center