To found views for information retrieve
select name from V$FIXED_TABLE where name like 'V$IR%';
V$IR_FAILURE
V$IR_REPAIR
V$IR_MANUAL_CHECKLIST
V$IR_FAILURE_SET
INFORMATION RETRIEVE view
col IMPACTS format a40
col description format a40
Set line 300
Set pagesize 400
select FAILURE_ID, TIME_DETECTED, MODIFIED, DESCRIPTION, IMPACTS, PRIORITY, STATUS from V$IR_FAILURE;
select * from V$IR_REPAIR;
select * from V$IR_MANUAL_CHECKLIST;
select * from V$IR_FAILURE_SET;
STEP FOR RUNNING DATA RECOVERY ADVISOR
- RMAN> List failure
- RMAN> Advise failure
- RMAN> Repair failure # repair and close failure using RMAN’s recommendation
- RMAN> Change failure
RMAN> Change failure 307 priority low;
Priority: CRITICAL, HIGH, LOW, CLOSED
E.G.
col CLASS_NAME format a20
col DETAILED_DESCRIPTION format a40
col REPAIR_SCRIPT format a40
select * from v$ir_failure;
select * from v$ir_repair
select * from V$IR_MANUAL_CHECKLIST;
select * from V$IR_FAILURE_SET;
rman target /
show failure;
using target database control file instead of recovery catalog
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
2 CRITICAL OPEN 10-SEP-17 SQL dictionary health check: seg$.type# 31 on object SEG$ failed
RMAN> advise failure;
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
2 CRITICAL OPEN 10-SEP-17 SQL dictionary health check: seg$.type# 31 on object SEG$ failed
Mandatory Manual Actions
========================
1. Please contact Oracle Support Services to resolve failure 2: SQL dictionary health check: seg$.type# 31 on object SEG$ failed
Optional Manual Actions
=======================
no manual actions available
Automated Repair Options
========================
no automatic repair options available
E.G.
col CLASS_NAME format a20
col DETAILED_DESCRIPTION format a40
col REPAIR_SCRIPT format a40
select * from v$ir_failure;
select * from v$ir_repair
select * from V$IR_MANUAL_CHECKLIST;
select * from V$IR_FAILURE_SET;
rman target /
show failure;
using target database control file instead of recovery catalog
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
2 CRITICAL OPEN 10-SEP-17 SQL dictionary health check: seg$.type# 31 on object SEG$ failed
RMAN> advise failure;
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
2 CRITICAL OPEN 10-SEP-17 SQL dictionary health check: seg$.type# 31 on object SEG$ failed
Mandatory Manual Actions
========================
1. Please contact Oracle Support Services to resolve failure 2: SQL dictionary health check: seg$.type# 31 on object SEG$ failed
Optional Manual Actions
=======================
no manual actions available
Automated Repair Options
========================
no automatic repair options available
