88.Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
来源:互联网 发布:淘宝日本直邮可信吗 编辑:程序博客网 时间:2024/05/21 08:51
88.Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A.The database files are corrupted when the database is open.
B.The user has dropped an important table that needs to be recovered.
C.The archived redo log files are missing for which the backup is not available.
D.The database is not opening because the required database files are missing.
答案:AD
解析:
1.Data Recovery Advisor(DRA):数据恢复顾问
2.rman中可以使用如下命令进入DRA
a.list failure
b.advise failure
c.repair failure
d..change failure
3.修正错误的时候数据库处于哪种状态取决于错误的类型,如果控制文件要恢复,数据库处于nomount状态, 如果是数据文件,则应该处于加载状态或打开状态
4.一般数据库崩溃时,首先使用list failure,然后使用advice failure,最后执行repair failure
5.list failure
list failure:可以列出检测出的错误以及错误的优先级别(关键、高、低),状态(打开、关闭)
list failure detail:列出错误的详细信息
list failure exclude failure n:可以从报告输出中排除特定的错误号
具体参数
ALL 列出所有错误
CRITICAL 只列出优先级为关键的错误
HIGH 只列出优先级为高的错误
LOW 只列出优先级为低的错误
CLOSED 只列出已经关闭的错误
EXCLUDE FAILURE 从列表中,去除列出错误号的错误,该选项后跟随一个由逗号隔开的希望去除的错误ID列表
DETAIL 提供列出的错误的其他细节
# 实际列出的错误号
list failure closed 254;
list failure closed exclude failure 242,248
--list failure 只能在单一的实例中运行,也不能在备用数据库上使用
--如果出现在列表中的一个错误处于打开状态,则意味着对当前的问题需要着手处理
6.advise failure
可以用于提供可使用的改正该错误的建议方案
--也是只能在单一实例中运行,也不能在备用数据库上使用
7.repair failure
--运行该命令必须启动目标数据库实例,同样只能在单一。。。。。
repair failure preview :查阅修复错误的操作,不会执行修复
8.change failure
change failure 187 priority low;--将187的错误更改为low
--不能将closed的错误切换到open状态
9.数据恢复顾问数据字典视图
以V$IR为前缀
V$IR 提供关于错误的信息,注意该视图中的记录可能在视图中存在父记录
V$IR_FAILURE_SET 该表提供了各种与错误关联的指导记录的列表,允许使用v$IR_FAILURE视图与V$IR_MANUAL_CHECKLIST视图连接
V$IR_MANUAL_CHECKLIST 该视图提供了与错误有关的详细的信息消息,这些消息提供了如何手动修复错误问题的信息
V$IR_REPAIR 当视图与v$IR_FAILURE和V$FAILURE_SET连接时,提供了由oracle建立的,用于改正检测到的错误,包含修复步骤的物理文件的指针
参考:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmintro.htm#BRADV99997
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmrepai.htm#BRADV246
A.The database files are corrupted when the database is open.
B.The user has dropped an important table that needs to be recovered.
C.The archived redo log files are missing for which the backup is not available.
D.The database is not opening because the required database files are missing.
答案:AD
解析:
1.Data Recovery Advisor(DRA):数据恢复顾问
2.rman中可以使用如下命令进入DRA
a.list failure
b.advise failure
c.repair failure
d..change failure
3.修正错误的时候数据库处于哪种状态取决于错误的类型,如果控制文件要恢复,数据库处于nomount状态, 如果是数据文件,则应该处于加载状态或打开状态
4.一般数据库崩溃时,首先使用list failure,然后使用advice failure,最后执行repair failure
5.list failure
list failure:可以列出检测出的错误以及错误的优先级别(关键、高、低),状态(打开、关闭)
list failure detail:列出错误的详细信息
list failure exclude failure n:可以从报告输出中排除特定的错误号
具体参数
ALL 列出所有错误
CRITICAL 只列出优先级为关键的错误
HIGH 只列出优先级为高的错误
LOW 只列出优先级为低的错误
CLOSED 只列出已经关闭的错误
EXCLUDE FAILURE 从列表中,去除列出错误号的错误,该选项后跟随一个由逗号隔开的希望去除的错误ID列表
DETAIL 提供列出的错误的其他细节
# 实际列出的错误号
list failure closed 254;
list failure closed exclude failure 242,248
--list failure 只能在单一的实例中运行,也不能在备用数据库上使用
--如果出现在列表中的一个错误处于打开状态,则意味着对当前的问题需要着手处理
6.advise failure
可以用于提供可使用的改正该错误的建议方案
--也是只能在单一实例中运行,也不能在备用数据库上使用
7.repair failure
--运行该命令必须启动目标数据库实例,同样只能在单一。。。。。
repair failure preview :查阅修复错误的操作,不会执行修复
8.change failure
change failure 187 priority low;--将187的错误更改为low
--不能将closed的错误切换到open状态
9.数据恢复顾问数据字典视图
以V$IR为前缀
V$IR 提供关于错误的信息,注意该视图中的记录可能在视图中存在父记录
V$IR_FAILURE_SET 该表提供了各种与错误关联的指导记录的列表,允许使用v$IR_FAILURE视图与V$IR_MANUAL_CHECKLIST视图连接
V$IR_MANUAL_CHECKLIST 该视图提供了与错误有关的详细的信息消息,这些消息提供了如何手动修复错误问题的信息
V$IR_REPAIR 当视图与v$IR_FAILURE和V$FAILURE_SET连接时,提供了由oracle建立的,用于改正检测到的错误,包含修复步骤的物理文件的指针
参考:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmintro.htm#BRADV99997
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmrepai.htm#BRADV246
0 0
- 88.Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
- 34 Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
- 34 Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) A.
- 140.Identify two situations in which the block header grows in a data block. (Choose two.)
- 90.Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
- Identify two situations in which the block header grows in a data block. (Choose two.) 选项 A.when ro
- 40 For which two situations would you use functionality provided by the Resource Manager? (Choose tw
- 74 For which two situations would you use functionality provided by the Resource Manager? (Choose tw
- 40 For which two situations would you use functionality provided by the Resource Manager? (Choose tw
- 126.Identify the two situations in which you use the alert log file in your database to check the de
- 127.Identify the two situations in which the alert log file is updated with details. (Choose two.)
- 89.Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Ch
- 146.Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)
- Data Recovery Advisor
- Data Recovery Advisor
- Data Recovery Advisor
- 152 You have enabled backup optimization for the RMAN environment. Identify two criteria on which RM
- 24 You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMA
- Eclipse连接MySQL数据库(傻瓜篇)
- dropout 的快熟实现笔记 --tensorlayer
- 87.You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery A
- 如何解决 TuneLayer read the docs API 不可见问题
- [leetcode] 310.Minimum Height Trees
- 88.Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
- 网站内容建设策略
- Word2vec 快熟实现之 TuneLayer (TensorLayer) 和 TensorFlow 篇
- 89.Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Ch
- 90.Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
- 只要好好努力!!!!!!!
- HP-UX小机故障检测之CMD篇(1)
- 网站建完后如何运营维护?
- 网站上线后必查清单