OCP 1Z0 053 86
来源:互联网 发布:三个矩阵分配律 编辑:程序博客网 时间:2024/05/23 14:32
86.Your production database is running in archivelog mode and you are using recovery manager (RMAN)
with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the
database instance after a regular maintenance task on Sunday, the database fails to open displaying the
message that the data file belonging to the users tablespace are corrupted.
The steps to recover the damaged data files are follows:
1. Mount the database
2. Open the database
3. Recover the data file
4. Restore the data file
5. Make the data file offline
6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files?
A. 2, 4, 3
B. 1, 4, 3, 2
C. 2, 5, 4, 3, 6
D. 5, 2, 4, 3, 6
E. 1, 5, 4, 3, 6, 2
Answer: E
因有文件损坏,不能open。只有先mount,修复后再open
参见
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta2008.htm#RCMRF90312
with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the
database instance after a regular maintenance task on Sunday, the database fails to open displaying the
message that the data file belonging to the users tablespace are corrupted.
The steps to recover the damaged data files are follows:
1. Mount the database
2. Open the database
3. Recover the data file
4. Restore the data file
5. Make the data file offline
6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files?
A. 2, 4, 3
B. 1, 4, 3, 2
C. 2, 5, 4, 3, 6
D. 5, 2, 4, 3, 6
E. 1, 5, 4, 3, 6, 2
Answer: E
因有文件损坏,不能open。只有先mount,修复后再open
参见
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta2008.htm#RCMRF90312
Example 3-19 Setting a New Name for a Restored Data File
Assume that /disk1
, which contains data file 9, suffers a media failure. This example specifies a new name for the data file, restores it, updates the control file to use the new name, recovers it, and then brings it online:
RUN{ SQL "ALTER DATABASE DATAFILE 9 OFFLINE"; SET NEWNAME FOR DATAFILE 9 TO '/disk2/users01.dbf'; RESTORE DATAFILE 9; SWITCH DATAFILE ALL; RECOVER DATAFILE 9; SQL "ALTER DATABASE DATAFILE 9 ONLINE";}
0 0
- OCP 1Z0 053 86
- OCP 1Z0 051 86
- OCP 1Z0 052 86
- OCP 1Z0 053 1
- OCP 1Z0 053 2
- OCP 1Z0 053 3
- OCP 1Z0 053 4
- OCP 1Z0 053 5
- OCP 1Z0 053 6
- OCP 1Z0 053 7
- OCP 1Z0 053 8
- OCP 1Z0 053 9
- OCP 1Z0 053 10
- OCP 1Z0 053 11
- OCP 1Z0 053 12
- OCP 1Z0 053 13
- OCP 1Z0 053 14
- OCP 1Z0 053 15
- Android的Looper类使用的5个要点
- C语言学习笔记13
- USACO-cha1-sec1.5 Checker Challenge
- 【机房重构】“ConnectionString属性尚未初始化”
- C语言学习笔记14
- OCP 1Z0 053 86
- Windows界面编程-背景图片、透明特效使用
- python 学习笔记 12 -- 写一个脚本获取城市天气信息
- Java内部类的使用与理解
- android之Bundle
- poj 3468 线段树区间更新维护
- Tetris game编程过程
- C语言学习笔记15
- mongoose源码分析系列一