5 Replies Latest reply: Feb 26, 2013 9:20 PM by ngilbert RSS

    Archive Area Used (%) metric in EM12cR2

    ngilbert
      Under Metric and Collection Settings for a database instance I've set the Warning and Critical % fro Archive Area Used to 1% and 2% (for testing) yet no events are ever generated. I've also added a list of other 'archive areas' in this section (like /var/, /u01/app/oracle/fast_recovery_area, /u01/app/oracle/fast_recovery_area/mydb, etc.) yet they don't appear under 'All Metrics' nor does the 'Archive Area Used %' item in All Metrics show any values (just says 'No Data Found').

      The collection frequency is set to 15 minutes (and its been several hours) and I've verified that the locations I've added are all at > 5% used...
        • 1. Re: Archive Area Used (%) metric in EM12cR2
          ngilbert
          5th bug I've found this week. Archive metrics don't work if LOG_ARCHIVE_DEST_n set to USE_DB_RECOVERY_FILE_DEST (FRA). Bug has been around for over 6 years and oracle appears unable to resolve.
          • 2. Re: Archive Area Used (%) metric in EM12cR2
            sxkumar
            Can you please mention the bug number?
            • 3. Re: Archive Area Used (%) metric in EM12cR2
              AMcCollu-Oracle
              Hi,

              The Archive Area metric isn't applicable if an FRA is in use. Instead use the Recovery Area Free Space (%) metric. This is a server-generated alert (i.e. the database monitors the condition and raises an alert).

              You can refer to the doc for more details:
              http://docs.oracle.com/cd/E11882_01/server.112/e10803/monitor.htm

              Here's the description for Recovery Area Free Space (%) from the doc:
              "This is a database-level metric that is evaluated by the server every 15 minutes or during a file creation, whichever occurs first. The metric is also printed in the alert log. For cluster databases, this metric is monitored at the cluster database target level and not by member instances. The Critical Threshold is set for < 3% and the Warning Threshold is set for < 15%. You cannot customize these thresholds. An alert is returned the first time the alert occurs, and the alert is not cleared until the available space rises above 15%"

              Regards,
              Ana
              • 4. Re: Archive Area Used (%) metric in EM12cR2
                ngilbert
                Hi Ana - I was actually aware of the FRA monitor already but wanted to use my own thresholds, seems ridiculous that this is not configurable which is why I was exploring the archive area metric (which is configurable, but doesn't work well). For FRA in production we want to be very conservative, warning occurs at 70%, critical at 85%, as we cannot afford having an errant process generate a mass of archive logs and bring down the system. I ended up going with metric extensions which, surprisingly, actually work well.

                The bug in question is 5962743 - basically the archive metric skips archive areas that are set with USE_DB_RECOVERY_FILE_DEST - option is to explicitly specify the archive path which we are not interested in doing, and as oracle nominally supports USE_DB_RECOVERY_FILE_DEST it is obviously a problem with the software if the metric ignores this location. Note taht the bug was registered in 2007. Fairly confident that Oracle will fix it within the next decade, keeping my fingers crossed.
                • 5. Re: Archive Area Used (%) metric in EM12cR2
                  ngilbert
                  As noted, located the bug involved - developed custom metric to handle this situation