oracle health monitor,Oracle 11g Health Monitor

后化
2023-12-01

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 theDBMS_

HMPL/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-onlinemode means the check can be run while the database is open (that is, in

OPENmode orMOUNTmode).

■DB-offlinemode means the check can be run when the instance is available but

the database itself is closed (that is, inNOMOUNTmode).

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 inNOMOUNTmode, 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 theV$DATABASE_BLOCK_

CORRUPTIONview. 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 inV$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 astab$andcol$. 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$, andecol$.

 类似资料:

相关阅读

相关文章

相关问答