Oracle Fault Diagnosability Infrastructure consolidate all the error log and store the files in the ADR ( automatic diagnostic repository ) outside of Oracle database. Here are the error log tyeps
- Alert: XML base alert log.
- Cdump: Core dumps for the database.
- Trace: Trace files, including the text format of alert logs
- Incident: one for each incident.
- Health Monitor log
Health monitor check can be manually invoke by DBMS_HM package. Here are the Health Monitor check related tables:
- V$HM_RUN : List all the Health Check has been executed
- V$HM_FINDING : List the finding
- V$HM_RECOMMENDATION : List the recommendation.
- V$HM_CHEK: List all the check can be run by DBMS_HM
List all the diagnostic log file location
show parameter diagnostic_dest
col Name format A22
col value format A50
select Name,Value from v$diag_info;
List the check can be perform by DBMS_HM
SELECT name FROM V$HM_CHECK WHERE INTERNAL_CHECK = 'N'
Invoke DBMS_HM check
exec dbms_hm.run_check('Dictionary Integrity Check', 'MY_HM1');
List the check has been run
select run_id, name from v$hm_run;
Retrieve the report
SET LONG 100000
SET LONGCHUNKSIZE 1000
SET PAGESIZE 1000
SET LINESIZE 512
SELECT DBMS_HM.GET_RUN_REPORT('MY_HM1') FROM DUAL;
adrci:
adrci – Automatic diagnostic repository command line interface is the command line which we can use to retrieve the alert log , HM report. $ORACLE_HOME/bin/adrci
Use adrci to retrieve the alert log
show alert -tail
show homes
set homepath diag/rdbms/oradb0/oradb0
show alert -tail
The tail is the same result if we use linux tail command to tail the alert log
Use adrci to retrieve the health monitor report
show report hm_run HM_RUN_1
The output is going to be the same if we view the file under HM directory .
ReplyDeleteI simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site."Oracle Training in Bangalore"
I found your this post while searching for some related information on blog search...Its a good post..keep posting and update the information. Fault Location Services Sandy Hook
ReplyDeleteWe've just lately commenced a new web site, the details anyone present on this internet site features made it easier for us drastically. Cheers pertaining to your occasion & operate. Fault Location Services La Plata
ReplyDeleteSharing the same interest, Infycle feels so happy to share our detailed information about all these courses with you all! Oracle Training In Chennai , Oracle PLSQL Training In Chennai , Oracle DBA Training In Chennai , AWS Training in Chennai & get to know everything you want to about software trainings.
ReplyDeleteHi there to everyone, the contents present at this web page are actually amazing for people knowledge, well, you can also visit akswave for more Akswave related information and knowledge. Keep up the good work.
ReplyDeleteI am grateful for this blog to distribute knowledge about this significant topic. Here I found different segments and now I am going to use these new instructions with new enthusiasm. oracle fusion manufacturing certification in hyderabad
ReplyDeleteWorth reading! Our experts also have given detailed inputs about these trainings & courses! Presenting here for your reference. Do checkout
ReplyDeleteaws training in chennai & enjoy learning more about it.