OCP-1Z0-053-V12 02-5题

我会带着你远行 2022-03-20 13:52 136阅读 0赞

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][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://blog.csdn.net/jiangjunshow][https_blog.csdn.net_jiangjunshow]

[http_docs.oracle.com_cd_E11882_01_server.112_e25494_diag.htm_ADMIN11274]: http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN11274
[https_blog.csdn.net_jiangjunshow]: https://blog.csdn.net/jiangjunshow/article/details/77338485