Listing the failure of the database

1.If the list failure command is not displaying any failure, use validate database to check for any failure and then use list failure to display failure.

RMAN> list failure;

no failures found that match specification

RMAN> validate database;

Starting validate at 09-JUN-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00001 name=+DATA/cvrman/datafile/system.304.849559339
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.286.849559341
input datafile file number=00005 name=+DATA/cvrman/datafile/example.314.849560251
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.270.849559341
input datafile file number=00004 name=+DATA/cvrman/datafile/users.391.849559341
channel ORA_DISK_1: validation complete, elapsed time: 00:01:56
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1    OK     0              14899        92200           1168765
  File Name: +DATA/cvrman/datafile/system.304.849559339
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              60413
  Index      0              12719
  Other      0              4129

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2    OK     0              22530        69122           1168781
  File Name: +DATA/cvrman/datafile/sysaux.286.849559341
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              11330
  Index      0              8323
  Other      0              26937

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3    OK     0              1            8960            1168781
  File Name: +DATA/cvrman/datafile/undotbs1.270.849559341
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0
  Index      0              0
  Other      0              8959

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4    OK     0              18           667             1168212
  File Name: +DATA/cvrman/datafile/users.391.849559341
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              91
  Index      0              39
  Other      0              492

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5    OK     0              33694        44240           1123430
  File Name: +DATA/cvrman/datafile/example.314.849560251
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              6594
  Index      0              1148
  Other      0              2804

channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type    Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE       OK     0              2
Control File OK     0              606
Finished validate at 09-JUN-14

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