Exachk critical check "The data files should be recoverable" fails for database.
(Doc ID 2685322.1)
Last updated on JULY 27, 2020
Applies to:
Oracle Exadata Storage Server Software - Version 19.3.2.0.0 to 20.1.0.0.0 [Release 12.2 to 20.0]Information in this document applies to any platform.
Symptoms
+ Exachk report that multiple databases have datafiles which are not recoverable.
Status on <Database Name>:
CRITICAL => The data files should be recoverable
DATA FOR <Database Name> FOR VERIFY DATA FILES ARE RECOVERABLE
FILE# UNRECOVER UNRECOVERABLE_CHANGE#
---------- --------- ---------------------
2 30-DEC-15 0
Value for "unrecoverable_time" points to very old date.
+ Database is already in force-logging mode
SQL> select FORCE_LOGGING from v$database;
FORCE_LOGGING
----------------
YES
+ Issue reported for Dataguard Standby database operating in Read-Only mode. But, can be seen on primary databases as well.
+ Customer confirmed that latest backups are available.
Changes
None
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |