Oracle 11g Health Monitor
Oracle 11g 提供HealthCheck 獨立的功能,和10g AWR 一樣對第三方提供服務的廠商和個人來說是很有幫助,現在還不知道功能如何。支援自動呼叫和手動執行。
不知道有沒有我寫的HealthCheck 範圍有沒有11g 的全面,搭個環境來看看。
下面是我寫的主目錄:
Main Report
- Report Header
- Report Summary
- Wait Events Statistics
- SQL Statistics
- Tablespace & Datafiles
- Buffer Pool Statistics
- Advisory Statistics
- Segment Statistics
- Library Cache Statistics
- Oracle Security
- Backups Status RMAN/FLASHBACK
- Scheduler/Jobs
- Oracel Component Option
- Directories
- init.ora Parameters
- Character Parameters
Running Health Checks with Health Monitor
This section describes the Health Monitor and includes instructions on how to use it.
The following topics are covered:
■ About Health Monitor
■ Running Health Checks Manually
■ Viewing Checker Reports
■ Health Monitor Views
■ Health Check Parameters Reference
About Health Monitor
Beginning with Release 11g, Oracle Database includes a framework called Health
Monitor for running diagnostic checks on the database.
About Health Monitor Checks
Health Monitor checks (also known as checkers, health checks, or checks) examine
various layers and components of the database. Health checks detect file corruptions,
physical and logical block corruptions, undo and redo corruptions, data dictionary
corruptions, and more. The health checks generate reports of their findings and, in
many cases, recommendations for resolving problems. Health checks can be run in
two ways:
■ Reactive—The fault diagnosability infrastructure can run health checks
automatically in response to a critical error.
■ Manual—As a DBA, you can manually run health checks using either the DBMS_
HM PL/SQL package or the Enterprise Manager interface. You can run checkers on
a regular basis if desired, or Oracle Support may ask you to run a checker while
working with you on a service request.
Health Monitor checks store findings, recommendations, and other information in the
Automatic Diagnostic Repository (ADR).
Health checks can run in two modes:
■ DB-online mode means the check can be run while the database is open (that is, in
OPEN mode or MOUNT mode).
■ DB-offline mode means the check can be run when the instance is available but
the database itself is closed (that is, in NOMOUNT mode).
All the health checks can be run in DB-online mode. Only the Redo Integrity Check
and the DB Structure Integrity Check can be used in DB-offline mode.
Types of Health Checks
Health monitor runs the following checks:
■ DB Structure Integrity Check—This check verifies the integrity of database files
and reports failures if these files are inaccessible, corrupt or inconsistent. If the
database is in mount or open mode, this check examines the log files and data files
listed in the control file. If the database is in NOMOUNT mode, only the control file is
checked.
■ Data Block Integrity Check—This check detects disk image block corruptions
such as checksum failures, head/tail mismatch, and logical inconsistencies within
the block. Most corruptions can be repaired using Block Media Recovery.
Corrupted block information is also captured in the V$DATABASE_BLOCK_
CORRUPTION view. This check does not detect inter-block or inter-segment
corruption.
■ Redo Integrity Check—This check scans the contents of the redo log for
accessibility and corruption, as well as the archive logs, if available. The Redo
Integrity Check reports failures such as archive log or redo corruption.
■ Undo Segment Integrity Check—This check finds logical undo corruptions. After
locating an undo corruption, this check uses PMON and SMON to try to recover
the corrupted transaction. If this recovery fails, then Health Monitor stores
information about the corruption in V$CORRUPT_XID_LIST. Most undo
corruptions can be resolved by forcing a commit.
■ Transaction Integrity Check—This check is identical to the Undo Segment
Integrity Check except that it checks only one specific transaction.
■ Dictionary Integrity Check—This check examines the integrity of core dictionary
objects, such as tab$ and col$. It performs the following operations:
– Verifies the contents of dictionary entries for each dictionary object.
– Performs a cross-row level check, which verifies that logical constraints on
rows in the dictionary are enforced.
– Performs an object relationship check, which verifies that parent-child
relationships between dictionary objects are enforced.
The Dictionary Integrity Check operates on the following dictionary objects:
tab$, clu$, fet$, uet$, seg$, undo$, ts$, file$, obj$, ind$, icol$, col$,
user$, con$, cdef$, ccol$, bootstrap$, objauth$, ugroup$, tsq$, syn$,
view$, typed_view$, superobj$, seq$, lob$, coltype$, subcoltype$,
ntab$, refcon$, opqtype$, dependency$, access$, viewcon$, icoldep$,
dual$, sysauth$, objpriv$, defrole$, and ecol$.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/34596/viewspace-612252/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 11g health monitor健康監控Oracle
- 11g New Feature: Health monitor
- Health Monitor簡介
- 11g New Feature: Health monitor (Doc ID 466920.1)
- Health Monitor 健康檢查
- 11g_Health_Monitor
- [20190306]11g health monitor.txt
- 【RAC】11gR2 新特性:Oracle Cluster Health Monitor(CHM)簡介Oracle
- 11g R2新特徵:oracle cluster health moniter (CHM) 簡介特徵Oracle
- ORAchk Health Checks for the Oracle StackOracle
- 【MOS】Cluster Health Monitor (CHM) FAQ (文件 ID 1328466.1 ID 2062234.1)
- 【SQL】Oracle SQL monitorSQLOracle
- Oracle Real Time SQL MonitorOracleSQL
- Oracle Text Health Check (Doc ID 823649.1)Oracle
- ORACLE SQL Tuning Health-Check(SQLHC)OracleSQL
- 11g新動態效能檢視V$SQL_MONITOR,V$SQL_PLAN_MONITORSQL
- DBMS_MONITOR使用 (In 10g, 11g and Above)
- Check_oracle_health 之阻塞會話數Oracle會話
- nagios使用check_oracle_health配置文件iOSOracle
- Check_oracle_health之程式數使用率Oracle
- [Shell] monitor oracle database listener & instance statusOracleDatabase
- [Shell] monitor oracle alert.log file and sendmailOracleAI
- Nagios主動監控oracle資料庫check_oracle_healthiOSOracle資料庫
- Check_oracle_health之增加監控會話數Oracle會話
- Oracle10g新增DBMS_MONITOR包Oracle
- 7.monitor oracle database listener & instance statusOracleDatabase
- 8.Monitor oracle alert.log file and sendmailOracleAI
- Check_oracle_health之表空間使用及處理Oracle
- Microsoft IT Environment Health ScannerROS
- Oracle SQL調優系列之SQL Monitor ReportOracleSQL
- Oracle10g新增DBMS_MONITOR包(二)Oracle
- Oracle10g新增DBMS_MONITOR包(一)Oracle
- Statement Tracer For Oracle 與 SQL Monitor 的比較OracleSQL
- Tracing Enhancements Using DBMS_MONITOR (In 10g, 11g and Above)_293661.1
- 11G R2 V$SQL_MONITOR檢視繫結變數SQL變數
- How to Perform a Health Check on the DatabaseORMDatabase
- 括展actuator health check
- Table Monitor