GV$IR_REPAIR definition in Oracle Database 11.2
GV$IR_REPAIR
select
inst_id, -- INST_ID NUMBER
id, -- REPAIR_ID NUMBER
fid, -- ADVISE_ID NUMBER
name, -- SUMMARY VARCHAR2(32)
rank, -- RANK NUMBER
cast(ctime as date), -- TIME_DETECTED DATE
cast(etime as date), -- EXECUTED DATE
cast( -- ESTIMATED_DATA_LOSS VARCHAR2(20)
'UNKNOWN' as varchar2(20)),
reco_msg, -- DETAILED_DESCRIPTION VARCHAR2(1024)
script, -- REPAIR_SCRIPT VARCHAR2(512)
est_rtime, -- ESTIMATED_REPAIR_TIME NUMBER
act_rtime, -- ACTUAL_REPAIR_TIME NUMBER
decode( -- STATUS VARCHAR2(7)
status, 0, 'NOT RUN', 1, 'RUNNING', 2, 'SUCCESS', 3, 'FAILED', 'UNKNOWN')
from
x$dbkreco
where
type = 1