Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

Recovery Area Free Space (%) metric not triggered

edited Jan 20, 2019 4:03AM in Managing Databases using Enterprise Manager (MOSC) 4 commentsAnswered

I have the following setup.

Cloud Control 13.3

DB 18.3 Single instance.

I want to create a warning about Recovery Area Usage.

I'm following non Oracle link:

Oracle Enterprise Manager notify when Recovery Area low

I also reviewed:

EM 12c, EM 13c: Understanding the Recovery Area/Recovery Area Free Space (%) Metric in Enterprise Manager Cloud Control (Doc ID 1926767.1)

Currently the below query returns:

select 100-round((space_used - space_reclaimable)/space_limit * 100, 1) pct_free

from v$recovery_file_dest;

pct_free=6.7

it means that my FRA is full 93.3%.

If I go under Cloud Control -> All Metrics -> Recovery Area -> Recovery Area Free Space (%)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center