List Failure usage

RMAN> list failure
2> ;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
548        HIGH     OPEN      09-JUN-14     Tablespace 4: 'USERS' is offline
542        HIGH     OPEN      09-JUN-14     One or more non-system datafiles are offline

RMAN> list failure 542 detail
2> ;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
542        HIGH     OPEN      09-JUN-14     One or more non-system datafiles are offline
  Impact: See impact for individual child failures
  List of child failures for parent failure ID 542
  Failure ID Priority Status    Time Detected Summary
  ---------- -------- --------- ------------- -------
  545        HIGH     OPEN      09-JUN-14     Datafile 4: '+DATA/cvrman/datafile/users.391.849559341' is offline
    Impact: Some objects in tablespace USERS might be unavailable

RMAN> list failure closed;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
2          CRITICAL CLOSED    06-JUN-14     Control file needs media recovery

RMAN> list failure all;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
548        HIGH     OPEN      09-JUN-14     Tablespace 4: 'USERS' is offline
542        HIGH     OPEN      09-JUN-14     One or more non-system datafiles are offline

RMAN> list failure high;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
548        HIGH     OPEN      09-JUN-14     Tablespace 4: 'USERS' is offline
542        HIGH     OPEN      09-JUN-14     One or more non-system datafiles are offline

RMAN> list failure low;

no failures found that match specification

RMAN> list failure exclude failure 542;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
548        HIGH     OPEN      09-JUN-14     Tablespace 4: 'USERS' is offline

RMAN> list failure 548 detail;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
548        HIGH     OPEN      09-JUN-14     Tablespace 4: 'USERS' is offline
  Impact: Some objects in tablespace USERS might be unavailable

List failure in RMAN

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