5th million,
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: 22:11:02. 032292-
End Time: 22:11:20. 835135-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 saved med manually.
B. Health Check was saved med to check the disk image block quota uptions.
C. Health Check was completed MED to check interblock and intersegment failed uption.
D. Health Check was saved med to verify the integrity of database files and report failures.
E. Health Check was saved med by the Health Monitor automatically in response to a critical error.
Answer: BE
Original answer AB, correct answer BE
Data Block Integrity Check-This check detects disk image block quota uptionsSuch as checksum failures, head/tail mismatch, and logical inconsistencies within the block. Most specified uptions can be retried red using Block Media Recovery. Specified upted block information is also captured inV$DATABASE_BLOCK_CORRUPTION
View. This check does not detect inter-block or inter-segment partition uption.
- About Health Monitor Checks
Health Monitor checks (also known as checkers, health checks, or checks) examine varous layers and components of the database. health checks detect file quota uptions, physical and logical block quota uptions, undo and redo quota uptions, data dictionary quota uptions, and more. the health checks generate reports of their findings and, in each case, recommendations for resolving problems. health checks can be run in two ways:
Reactive-The fault diagnosability infrastructure can run health checksAutomaticallyIn response to a critical error.
Manual-As a DBA, you can manually run health checks using eitherDBMS_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.
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.