OCP 1Z0 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: AB 

http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN11273

Running Health Checks Manually

Health Monitor provides two ways to run health checks manually:

• By using the 

  DBMS_HM

   PL/SQL package
• By using the Enterprise Manager interface, found on the Checkers subpage of the Advisor Central page

Running Health Checks Using the DBMS_HM PL/SQL Package

The 

DBMS_HM

 procedure for running a health check is called 

RUN_CHECK

. To call 

RUN_CHECK

, supply the name of the check and a name for the run, as follows:

BEGIN
  DBMS_HM.RUN_CHECK('Dictionary Integrity Check', 'my_run');
END;
/
      

SQL> show user
USER is "SYS"
SQL> BEGIN
  2  DBMS_HM.RUN_CHECK('Data Block Integrity Check', 'HM_RUN_1061',null,'BLC_DF_NUM=1;BLC_BL_NUM=23456');
  3  END;
  4  /

PL/SQL procedure successfully completed.

SQL> SELECT DBMS_HM.GET_RUN_REPORT('HM_RUN_1061') FROM DUAL;

DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
--------------------------------------
Basic Run Information
 Run Name                     : HM_RUN_1061
 Run Id                       : 421
 Check Name                   : Data Block Integrity Check
 Mode                         : MANUAL
 Status                       : COMPLETED
 Start Time                   : 2014-06-28 14:57:00.187000 +08:00
 End Time                     : 2014-06-28 14:57:00.640000 +08:00
 Error Encountered            : 0
 Source Incident Id           : 0
 Number of Incidents Created  : 0

Input Paramters for the Run
 BLC_DF_NUM=1
 BLC_BL_NUM=23456

Run Findings And Recommendations


1 row selected.