OCP-1Z0-053-V12.02-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: AB

答案解析:

参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN11274


Viewing Reports Using DBMS_HM

You can view Health Monitor checker reports with the DBMS_HM package function GET_RUN_REPORT. This function enables you to request HTML, XML, or text formatting. The default format is text, as shown in the following SQL*Plus example:

SET LONG 100000
SET LONGCHUNKSIZE 1000
SET PAGESIZE 1000
SET LINESIZE 512
SELECT DBMS_HM.GET_RUN_REPORT('HM_RUN_1061') FROM DUAL;
 
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



To obtain a list of health check names, run the following query:

sys@TEST1107> SELECT name FROM v$hm_check WHERE internal_check='N' ;

NAME
----------------------------------------------------------------
DB Structure Integrity Check
CF Block Integrity Check
Data Block Integrity Check
Redo Integrity Check
Transaction Integrity Check
Undo Segment Integrity Check
Dictionary Integrity Check
ASM Allocation Check

8 rows selected.


 
原文地址:https://www.cnblogs.com/hzcya1995/p/13316369.html