OCP-1Z0-053-V12.02-665题

Oracle - 4 - ADR(Automatic Diagnostic Repository) 2 使用 Github 官网:github.com 2.1 目的 借助 github 托管项目代码 2.2 基本概念 仓库(Repository) 仓库用来存放项目代码,每个项目对应一个仓库,多个开源项目则有多个仓库。 收藏(Star) 复制克隆项目(Fork) 该 fork 的项目独立存在 发送请求(Pull Request) 关注(Watch) 关注项目,当项目更新可以... 阅读详情

665.Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A. The ADR base keeps all diagnostic information in binary format

B. SQL*Plus provides the ADRI script, which can be used to work with ADR

C. The ADR can be used for problem diagnosis only when the database is open

D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

E. The ADR can be used for problem diagnosis even when the database instance is down

F. The ADR base is shared across multiple instances

Answer: EF

答案解析:

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


Structure, Contents, and Location of the Automatic Diagnostic Repository

The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down.

Automatic Diagnostic Repository (ADR)

The ADR is a file-based repository for database diagnostic data such as traces, dumps, the alert log, health monitor reports, and more. It has a unified directory structure across multiple instances and multiple products. Beginning with Release 11g, the database, Oracle Automatic Storage Management (Oracle ASM), the listener, and other Oracle products or components store all diagnostic data in the ADR. Each instance of each product stores diagnostic data underneath its own home directory within the ADR. For example, in an Oracle Real Application Clusters environment with shared storage and Oracle ASM, each database instance and each Oracle ASM instance has an ADR home directory. ADR's unified directory structure, consistent diagnostic data formats across products and instances, and a unified set of tools enable customers and Oracle Support to correlate and analyze diagnostic data across multiple instances.


 
Oracle 11g自动诊断信息库(Automatic Diagnostic Repository,ADR)概述 主要介绍了Oracle11g的自动诊断信息库,需要的朋友可以参考下 立即下载

相关推荐

108 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.) A.

108 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.) A. The ADR base keeps all diagnostic information in binary format B. SQL*Plus provides the ADRI scri

EVISWANG的博客 1788

Oracle 数据库自动诊断库 ADR(Automatic Diagnostic Repository)简介

作者介绍姚远:鼎甲科技高级技术顾问,墨天轮MVP。Oracle ACE,华为云MVP,专注于 Oracle、MySQL 数据库多年,拥有 Oracle 10g、12c OCM, MyS...

Enmotech的博客 1406

OCP-052考试库汇总(49)-CUUG内部解答版

Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE. ...

chouluanzhi0562的博客 802

ADR(Automatic Diagnositc Repository)

环境:linux、oracle12c1、ADR(Automatic Diagnositc Repository) 存放数据库诊断的数据的目录结构ADR Base基础目录 位置有diagnostic_dest参数决定如果没有设置diagnostic_dest参数1)设置ORACLE_BASE环境变量 ,参数diagnostic_dest设置为ORACLEB​ASE2没有设置ORACLEB​ASE环境变量,参数diagnosticd​。

m0_38082819的博客 893

46.Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two

46.Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

dwj19830118的专栏 1683

OCP-1Z0-053-V12.02-29

29.Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.) A. A single ADR can support multiple ADR homes for different database insta

一抹曦阳-Oracle 9856

2.Which two statements are true about the Automatic Workload Repository (AWR)

2.Which two statements are true about the Automatic Workload Repository (AWR)

dwj19830118的专栏 2675

OCP-1Z0-052-V8.02-46

46. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.) A.The ADDM requires at least four AWR snapshots for analysis. B.The ADDM runs after each AWR

一抹曦阳-Oracle 1万+

OCP-1Z0-052-V8.02-2

2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.) A.All AWR tables belong to the SYSTEM schema. B.The AWR contains systemwide tracing and logging informat

一抹曦阳-Oracle 1万+

初了解Oracle 11g的Automatic Diagnostic Repository新特性

Oracle 11g之前,当数据库出现问时,往往第一时间需要看alert日志,看看里面记录了哪些错误,可以给我们提示。alert文件名则 是alert_.log,文件存储路径由参数background_dump_dest决定,例如: SQL> show parameter background_dump_dest NAME

bisal的专栏 4051

OCP-1Z0-053-V12.02-496

496.Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.) A. As ASM instance mounts an ASM control file B. An ASM instance uses the ASMB process for

一抹曦阳-Oracle 8631

OCP-1Z0-052-V8.02-50

50. Which two statements are true about alerts? (Choose two.) A.Clearing an alert sends the alert to the alert history. B.Response actions cannot be specified with server-generated alerts. C.The no

一抹曦阳-Oracle 1万+

oracle数据库管理库,oracle数据库

OCP-052考试库汇总(48)-CUUG内部解答版Which is true about the Automatic Diagnostic Repository (ADR) ?A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured.B) It onl...文章bjcuug2019-09-04494浏览...

weixin_28931507的博客 457

自动诊断资料档案库(ADR)

ADR 是一个基于文件的资料档案库,用于存放数据库诊断数据,如跟踪、意外事件转储和程序 包、预警日志、健康状况监视器报表、核心转储等。ADR 保存在数据库之外,在数据库关闭时 也可以用来进行故障的诊断。 ...

m0_67751585的博客 320

Oracle 数据库自动诊断库 ADR(Automatic Diagnostic Repository)简介 发表在 数据和云

文章目录ADR 的作用ADR 中的文件ADR 的目录结构数据库的 ADR 家目录结构Alert Logsbtio logADRCI 工具 ADR 的作用 Oracle 数据库如果出现故障,我们的第一个反应是查看数据库的 alert log,但一些工程师对 alert log 不熟悉,实际上 alert log 位于Oracle 数据库自动诊断库(Automatic Diagnostic Repository,以下简称 ADR) 中,要熟悉 alert log,我们必需全面了解 ADR 的概念。ADR(Aut

姚远OracleACE的博客 2150

Oracle 11g新特性:Automatic Diagnostic Repository

Oracle Database 11g的FDI(Fault Diagnosability Infrastructure)是自动化诊断方面的又一增强。 FDI的一个关键组件是自动诊断库(Automatic Diagnostic Repository-ADR)。 在oracle 11g中,alert文件的信息是以xml的文件格式存在的,另外提供了普通文本格式的alert文件。 这两份log文...

duncan 178

Oracle 11g 诊断新特性——自动诊断资料库ADR

   ADR(Automatic Diagnostic Repository)是一个基于文件的档案库,用于存放数据库的诊断信息,例如跟踪文件,意外dump文件,IPS包,警告日志文件,健康监控报告,核心dump文件以及其它诊断信息。ADR的根目录叫做ADR base, 位置通过参数DIAGNOSTIC_DEST设置。ADR拥有统一的目录结构,在数据库之外存储多个产品和实例的诊断信息,因此即使在数...

jolly10的专栏 1065
上一篇: OCP-1Z0-053-V12.02-662题
下一篇: OCP-1Z0-052-V8.02-102题
Riveore
博客等级 码龄19年 1801粉丝 1432原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值