This forum is currently locked. You can't register or post questions at this time. (read more)

oracle health monitor - exclude offline tablespaces ?

All posts relating to Oracle database administration.

Moderator: Tim...

wlourens
Member
Posts: 12
Joined: Sat Mar 09, 2013 8:58 pm

oracle health monitor - exclude offline tablespaces ?

Postby wlourens » Wed Oct 02, 2013 8:26 am

Hi

My OEM12c is generating a lot of unnecessary incidents with the likes of: "EM Event: Critical:G30_r3d03 - Checker run found 6 new persistent data failures."

I have used MOS note 1391202.1 (Checker Run Found xx New Persistent Data Failures) to determine the cause.

The health monitor, which runs many times a day, detects critical errors for tablespaces that I have offline'd:

DBMS_HM.GET_RUN_REPORT('HM_RUN_349041')
---------------------------------------------------------------
Basic Run Information
Run Name : HM_RUN_349041
Run Id : 349041
Check Name : DB Structure Integrity Check
Mode : REACTIVE
Status : COMPLETED
Start Time : 2013-10-02 10:08:31.170201 +02:00
End Time : 2013-10-02 10:08:33.240528 +02:00
Error Encountered : 0
Source Incident Id : 0
Number of Incidents Created : 0

Input Paramters for the Run
Run Findings And Recommendations
Finding
Finding Name : Offline Datafile
Finding ID : 349045
Type : FAILURE
Status : OPEN
Priority : HIGH
Message : Datafile 194: '/oracle/G30/sapdata83/el640d_1/el640d.data1'
is offline
Message : Some objects in tablespace PSAPEL640D might be unavailable
Finding
Finding Name : Offline Datafile
Finding ID : 349051
Type : FAILURE
Status : OPEN
Priority : HIGH
Message : Datafile 195: '/oracle/G30/sapdata84/el640i_1/el640i.data1'
is offline
Message : Some objects in tablespace PSAPEL640I might be unavailable
...


I offline'd this tablespaces with the purpose of dropping them later. Is it possible to get health monitor to exclude this tablespaces during checks, as not to generate OEM12c notifications?

Thanks,
Willem

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: oracle health monitor - exclude offline tablespaces ?

Postby Tim... » Thu Oct 03, 2013 6:43 pm

Hi.

I don't remember reading about any form of exclusion list. I guess in your position I would raise an SR with Oracle Support to ask about that... :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

wlourens
Member
Posts: 12
Joined: Sat Mar 09, 2013 8:58 pm

Re: oracle health monitor - exclude offline tablespaces ?

Postby wlourens » Mon Oct 07, 2013 9:03 am

Hi Tim

I changed the status of this tablespaces to READ ONLY, thinking it would fix the issue, but the error in the Oracle Health Monitor is now: :shock:

Finding
Finding Name : Datafile is old
Finding ID : 925
Type : FAILURE
Status : CLOSED
Priority : HIGH
Message : Datafile 283: '/oracle/G30/sapdata3/es701i_1/es701i.data1'
needs media recovery
Message : Some objects in tablespace PSAPES701I might be unavailable


This tablespaces was OFFLINE/READ ONLY for some time, I'm now going to safely drop them.

Thanks and Regards, :)
Willem 8)

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: oracle health monitor - exclude offline tablespaces ?

Postby Tim... » Mon Oct 07, 2013 9:22 am

Hi.

Different issue now. Before it was complaining about being offline. Now it is complaining about not being recovered correctly, which is what you would expect if the datafile was offline for a period of time and you've not done a recovery of it. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 6 guests

cron