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
数据文件损坏，数据库不能直接打开，故A和C错误。
数据库重启后，发现数据文件损坏是在MOUNT阶段，故不需要再MOUNT；如果必须要MOUNT，只能先SHUTDOWN。
E在MOUNT阶段OFFLINE数据文件有点多此一举。
D最为合适。
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
数据文件损坏，数据库不能直接打开，故A和C错误。
数据库重启后，发现数据文件损坏是在MOUNT阶段，故不需要再MOUNT；如果必须要MOUNT，只能先SHUTDOWN。
E在MOUNT阶段OFFLINE数据文件有点多此一举。
D最为合适。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2120416/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q53
下一篇：
1Z0-053 V13.02 Q93
请登录后发表评论
登录
全部评论
