Fast Recovery Area Monitoring – Where are the metrics! #em12c

Oracle Enterprise Manager 12c is a great monitoring tool for the enterprise, I think I’ve said that more than once over the last two years; however, with every release small yet simple things change.  It is always the small things that will get you.  I had setup monitoring for a client using monitoring templates within OEM12c; everything was being monitored, so I thought!  I got a call from my client asking why nobody was alerted when the Fast Recovery Area (FRA) was filled due to archive logs.  My initial response was it should have alerted, I’ll look into what happen.

Naturally, the first place I started was with the monitoring template (Enterprise –> Monitoring –> Monitoring Templates –>View/Edit desired template) to check and make sure that the Archive Area Used (%) metric is set. 

image

The monitoring template for the database instances had the Archive Area Usage (%) metric and it is set to email a warning when 80% full and email a critical when 90% full.  Why was the emails not triggered?  The template has been applied to all database instances.

image

The easiest way to find out what this metric is “suppose” to do, is to look at the reference documentation on supported metrics (here).  This particular metric is listed under Database Instance.  In reading the description of the Archive Area Used (%) metric, I found a note that leads directly to what the issue was.

image

As the notes says, if the database is using the Fast Recovery Area (FRA) for archive logs; then the metrics associated with archive logs do not apply.  The metric Recovery Area Free Space (%) has to be used to monitor the Fast Recovery Area.  Ok, simple enough; lets just add the metric to the template. 

When trying to add Recovery Area Free Space (%) to the template using Database Instance Target Type, there is no metrics for Fast Recovery Area (Image shows a partial list of metric categories).  Where is Fast Recovery Area metrics?

image

Again, I go back to the reference guide and lookup Fast Recovery Metrics.  Section 5.34 of the reference guide has a good bit of information on the metrics related to the Fast Recovery Area, but no definitive answers on where these metrics are stored or how to add them to a template.

At this point, what do I know? 

  1. Archive Area Usage (%) cannot be used to monitor the Fast Recovery Area. 
  2. What metrics are needed to monitor Fast Recover Area, but cannot find them to add them to a template. 

Maybe “All Metrics” under a database target would shed some light on the situation.

To access “All Metrics” for a database instance, follow Targets –> Databases –> Database Instance.  Once I was at the database instance I wanted to look out, then I went  Oracle Database –> Monitoring –> All Metrics.

image

Once in “All Metrics”, I can see every metric that is associated with an Oracle Database Instance.  At the top of the metric tree, there is a search box for finding a metric.  When I search for “Fast”, I find all the Fast Recovery metrics.

image

Great, I found all the metrics that I want related to Fast Recovery Area.  Now how do I get them into a template so I can set thresholds for monitoring?  Back to the template (Enterprise –> Monitoring –> Monitoring Templates). 

When I edit the template, I noticed (have always noticed) the tabs at the top: General, Metric Thresholds, Other Collected Items, Access.  Normally, I’m only worried about the metrics on the Metric Thresholds tab; since I haven’t had any luck adding the metrics I wanted, lets take a look at the “Other Collected Items” tab.

image

Scrolling down through the “Other Collected Items” tab, I find the Fast Recovery category for metrics.

image

Apparently, the Fast Recovery metrics are already added to the template; how do the metrics, “Other Collected Items” tab, work or alerted against.  Again, back to the documentation.

This time when looking at the documentation,  I needed to look up templates to find the answer I needed.  In section 8.2 of the Oracle Enterprise Manager Cloud Control Administrator’s Guide, I find the answer I needed.  Here is why the Fast Recovery Area metrics are not configurable with thresholds:

image

Oracle has made all the metrics related to Fast Recovery Area non-metric!  That is right, OEM is gathering the information but not allowing you to alert on it with thresholds!  Although it is part of the template, the template will gather the information; but in the end I would need to go to “All Metrics” to see the results.

Workaround

If you want to monitor the Fast Recovery A
rea and have thresholds against metrics; the solution is to use Metric Extensions.  Metric Extensions allow the end user to create custom metrics for monitoring.  Once an Metric Extension is created, it will be seen in “All Metrics” and then can be added to a monitoring template with thresholds assigned.

Instead of going into how to develop Metric Extensions in this post, I have provided some really great posts on how to implement and use Metric Extensions below.  I have also provide a link to a similar post which includes showing how the metric extensions are setup by Courtney Llamas of Oracle. 

https://blogs.oracle.com/oem/entry/fast_recovery_area_for_archive

http://dbasolved.com/2014/01/19/yet-another-way-to-monitor-oracle-goldengate-with-oem12c/

http://www.slideshare.net/Enkitec/em12c-monitoring-metric-extensions-and-performance-pages

Summary

Almost everyone now is using Fast Recovery Area to store their backups and archive log.  Monitoring of this area is critical; however, out of the box Oracle Enterprise Manager 12c, needs to be adjusted to monitor the Fast Recovery Area with the correct metrics.  This slight change in metric monitoring came as a surprise versus previous editions of OEM.  In the end, OEM is still a good monitoring tool for the enterprise; just now we need to make some small adjustments.

References

Friendly Oracle Employees – Pete Sharman (would say find him on twitter as well but he doesn’t tweet)

Oracle Enterprise Manager 12c Documentation (http://docs.oracle.com/cd/E24628_01/index.htm)

Enjoy!

twitter: @dbasolved

blog: http://dbasolved.com

Please follow and like:
Comments
  • Ultimate Guide to Sport Bet: Tips and Strategies for Success Sport betting has become a… 1xBet — это одна из самых популярных и надежных платформ, которая предлагает уникальные возможности и привлекательные бонусы для своих пользователей. Независимо от того, являетесь ли вы новичком в мире ставок или опытным игроком, промокоды 1xBet — это отличный способ повысить свои шансы на выигрыш. Aviator oyna sadəcə bir oyun deyil, bu, hər bir missiya ilə uçuş bacarıqlarınızın növbəti səviyyəyə çıxarıldığı virtual dünyada immersiv bir təcrübədir.
    https://pumpyoursound.com/u/user/1502460
    ทำไมต้องโหลด app Fun88? 1win app 1win app . prescription drugs without doctor approval: canadian pharmacy – ed men Gra Aviator to gra online, w której na ekranie zakładów samolot startuje i leci. To, aż w pewnym momencie przyspiesza i odlatuje, znika z ekranu. Can it be a simple, a few dimensional framework, otherwise are there lots of pulsating advertising neon cues and you may scrolling ads? Some individuals including an enjoyable leisurely basic background and acquire all of the those people glitzy interruptions too much. Anyone else is bored stiff because of the pastel colors and you can unlimited sky and require some thing a tad bit more glamorous. We’ll tell you how it try, so you can pick if the web site is actually for your. You agree to the new Fine print and Privacy policy by the using our website for those who don’t head. If you do not accept such fine print, delight do not use all of our site.

  • Здравствуйте
    На днях я посетил Уфу и погрузился в её атмосферу. Приятные прогулки по центральным улицам привели меня к интересным местам. В один из вечеров мне захотелось общения, и я нашёл компанию на сайте, предоставляющем услуги. Это был отличный опыт, который я запомню надолго.
    Более подробно про сайт знакомств здесь: элитный досуг Уфа

  • My family always say that I am wasting my time here at net,
    except I know I am getting familiarity all the time by reading thes nice content.

    Here is my blog post: vpn

  • Some of the figures have changed, though, well, the RTP has at least. Where the previous release had a default RTP of 96.71%, the number has dropped a notch or two to 96.5%. The return to player value remains the same no matter how Big Bass Bonanza Reel Action is played, and there are three ways of doing so. One is wagering 10 c to $ €250 per spin, while another is using the Ante Bet, which increases the stake by 50% to have extra scatter symbols on the reels. Rated 4 out of 5, the math model volatility stays steady on a medium-high setting. By comprehensively understanding the paytable, you can strategically plan your gameplay, identify the most lucrative symbols or features to target, and make informed decisions about your bets. Treat the paytable as your strategic tool for maximizing your potential winnings in Big Bass Bonanza Reel Action.
    https://datos.estadisticas.pr/user/fobigrmytim1978
    It is likewise possible that Sweet Bonanza is offered to participate in directly through the mobile browser and not having to down load an additional application. You want to play from your own smartphone, then you certainly have to download typically the mobile app for Android” “or even iOS. During typically the round of free of charge spins special reels are involved in the video game. If you don’t want to await free spins to appear, you may use typically the «Buy Bonus» performance. First of all, the Sweet Bonanza slot machine has six reels that turn vertically at each spin, i.e. each “go” at the game. Each reel contains repeats of all the multiplier symbols, in this case, different candies and fruits that we’ll explain in a moment. At the end of the spin, the reels will stop moving and display five rows of symbols. Your winnings will depend on what symbols you land on and how many of the same ones you get on one spin.

Leave a Reply

Your email address will not be published. Required fields are marked *

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.