053第5

5.Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')

Run Name : HM_RUN_1061 Run Id : 1061 

Check Name : Data Block Integrity

 Check Mode :REACTIVE 

Status : COMPLETED 

Start Time : 2007-05-12 22:11:02.032292 -07:00 

End Time :2007-05-12 22:11:20.835135 -07:00 Error Encountered : 0

Source Incident Id : 7418
Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)
A. Health Check was performed manually.
B. Health Check was performed to check the disk image block corruptions.
C. Health Check was performed to check interblock and intersegment corruption.
D. Health Check was performed to verify the integrity of database files and report failures.
E. Health Check was performed by the Health Monitor automatically in response to a critical error.

Answer: BE

原答案AB，正确答案BE

• 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_CORRUPTION view. This check does not detect inter-block or inter-segment corruption.

• 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.