The value of Fast Recovery Area % Used for
The value of Fast Recovery Area % Used for
Issue : Fast Recovery Area (FRA) utilization crossed threshold value 75%
EM Alert: EM Event: Critical:oprd1 – The value of Fast Recovery Area % Used for +RECOC1 is 77
Troubleshooting
SQL> show pdbs
2 PDB$SEED READ ONLY NO
3 OPRD1 READ WRITE NO
Archive generation Size for previous two days of that alert:
| SELECT TRUNC(COMPLETION_TIME) ARCHIVED_DATE,SUM(BLOCKS * BLOCK_SIZE) / 1024 / 1024 /1024 SIZE_IN_GB FROM V$ARCHIVED_LOG where TRUNC(first_time) >=’&Start_Date_DD_MON_YY’and TRUNC(first_time) < ‘&End_Date_DD_MON_YY’ GROUP BY TRUNC(COMPLETION_TIME) ORDER BY 1; |
Enter start date and end date in DD-MON-YY format
Sample o/p
1415.22556(GB)
1571.55547(GB)
Actions Taken
The FRA space alert has been taken care by adding the space from 3.5TB to 4.5TB.
Before adding space:
select round((SPACE_USED/SPACE_LIMIT)*100) from V$RECOVERY_FILE_DEST;
ROUND((SPACE_USED/SPACE_LIMIT)*100)
———————————–
77
After adding space:
select round((SPACE_USED/SPACE_LIMIT)*100) from V$RECOVERY_FILE_DEST;
ROUND((SPACE_USED/SPACE_LIMIT)*100)
———————————–
66
Complete sample alert from OEM looks like below:
EM Event: Critical:OPRD1 – The value of Fast Recovery Area % Used for +RECOC1 is 77
Host=orprdnode05
Target type=Cluster Database
Target name=OPRD1
Categories=Capacity
Message=The value of Fast Recovery Area % Used for +RECOC1 is 77
Severity=Critical
Platform=x86_64
Operating System=Linux
Associated Incident Id=171176
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=None
Associated Incident Escalation Level=0
Event Type=Metric Alert
Event name=ME$RECOVERY_AREA_MONITORING_RAC:FRAPercentUsed
Metric Group=ME$RECOVERY_AREA_MONITORING_RAC
Metric=FRAPercentUsed
Metric value=77
Key Value=+RECOC1
Key Column 1=FRADestination
Rule Name=Incident management rule set for all targets,Create incident for critical metric alerts
Rule Owner=System Generated
Update Details:
The value of Fast Recovery Area % Used for +RECOC1 is 77
Incident created by rule (Name = Incident management rule set for all targets, Create incident for critical metric alerts [System generated rule]).
See Also: