Oracle 11G OCP 1Z0-053 625

（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 of temporary tablespace

F. Archive Logs since the latest backup to point of failure

答案：（A、C、F）

解析：

做完全恢复的两个条件是归档和redolog必须存在，所以A和F是必须选择的，然后哪个数据文件坏了，就转储给数据文件，故选C

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1329179/，如需转载，请注明出处，否则将追究法律责任。