List failure recorded by data recovery advisor in RMAN
RMAN> list failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- -------------------- -------
2342 HIGH OPEN 15-MAY-2014 04:03:16 One or more non-system datafiles are offline
