ORACLE RMAN advise failure

最新推荐文章于 2024-11-19 12:40:27 发布

原创最新推荐文章于 2024-11-19 12:40:27 发布 · 497 阅读

0 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

2 篇文章

订阅专栏

本文探讨了在RMAN会话中执行故障列表和建议故障命令时的场景。当在执行LIST FAILURE后诊断库中记录了新故障，再次运行ADVISE FAILURE时，RMAN将在提供关键和高优先级故障建议前发出警告。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

143.You executed the following commands in an RMAN session for your database instance that has
failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of
the last LIST FAILURE command.
Which statement is true for the above ADVISE FAILURE command in this scenario?
A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
C. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are
ignored.
D. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE
FAILURE command.

Syntax Element Description

Syntax Element	Description
`ADVISE FAILURE`	Displays information for all `CRITICAL` and `HIGH` priority failures recorded in the automatic diagnostic repository. You can only use `ADVISE FAILURE` with no options when a `LIST FAILURE` command was previously executed in the current session. Note: If a new failure has been recorded in the diagnostic repository since the last `LIST` `FAILURE` command in the current RMAN session, then RMAN issues a warning before advising on `CRITICAL` and `HIGH` failures.

ADVISE FAILURE

Displays information for all CRITICAL and HIGH priority failures recorded in the automatic diagnostic repository.

You can only use ADVISE FAILURE with no options when a LIST FAILURE command was previously executed in the current session.

Note: If a new failure has been recorded in the diagnostic repository since the last LIST FAILURE command in the current RMAN session, then RMAN issues a warning before advising on CRITICAL and HIGH failures.

由官网文档注解可以看出，RMAN在使用advise failure命令时，如果在list failure命令之后，诊断库中又产生了新的错误，那么rman会在进行关键和重大修复之前给出告警。