Advise Failure Usage

Advise failure usage

RMAN> advise 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

analyzing automatic repair options; this may take some time
using channel ORA_DISK_1
analyzing automatic repair options complete

Mandatory Manual Actions
========================
no manual actions available

Optional Manual Actions
=======================
no manual actions available

Automated Repair Options
========================
Option Repair Description
------ ------------------
1      Online tablespace USERS
  Strategy: The repair includes complete media recovery with no data loss
  Repair script: /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/hm/reco_151749392.hm

RMAN> advise failure critical;

no failures found that match specification

RMAN> advise 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

analyzing automatic repair options; this may take some time
using channel ORA_DISK_1
analyzing automatic repair options complete

Mandatory Manual Actions
========================
no manual actions available

Optional Manual Actions
=======================
no manual actions available

Automated Repair Options
========================
Option Repair Description
------ ------------------
1      Online tablespace USERS
  Strategy: The repair includes complete media recovery with no data loss
  Repair script: /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/hm/reco_1312477392.hm