053-625

Your database is running in ARCHIVELOG mode.One of the data files,USERDATA01.dbf,in
the USERS tablespace is damaged and you need to recover the file until the point of failure.
The backup for the datafile is available. Which three files would be used in the
user-managed recovery process performed by the database administrator (DBA)? (Choose Three)
A. Redo logs
B. Control file
C. The latest backup of only the damaged data file
D. The latest backup of all the data file in the USERS tablespace
E. Temporary files o ftemporary tablespace
F. Archive Logs since the latest backup to point of failure  

此题考点是在有备份的情况下,进行常规的数据文件恢复。
恢复过程中需要使用的是损坏数据文件的备份,C 正确,D 错误,可以在数据文件级别对单个文件进行恢复。
restore 数据文件之后,要恢复到故障点(完全恢复),就需要备份以来的归档和 redo 日志文件,A,C 正确,如果没有日志文件,或者缺少归档,那么只能进行不完全恢复,不能恢复到故障点。
在恢复中由于控制文件并未损坏,不会涉及到控制文件。更不会涉及到临时文件 B,E 错。

posted @ 2017-11-15 17:20  巴啦啦大魔王  阅读(158)  评论(0编辑  收藏  举报