OCP-1Z0-053-V12.02-566题

566.You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the

database has crashed.

What would be the appropriate order of operations to correct the situation?

A. Mount the database with the startup mount command.

B. Take the SYSTEM datafile offline with the alter database command.

C. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.

D. Restore all SYSTEM tablespace-related datafiles from backup media.

E. Issue the recover tablespace SYSTEM command.

F. Issue the recover datafile SYSTEM_01.dbf command.

G. Open the database with the alter database open command.

H. Open the database with the alter database open resetlogs command.

I. a, c, f, g

J. b, d, e, h

K. a, b, c, f, g

L. d, a, e, g

M. b, c, f, e, g

Answer: D

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12622415

如果某个数据文件丢失或损坏，且该文件属于SYSTEM或UNDO表空间，请执行以下任务：

1. 实例可能会也可能不会自动关闭。如果未自动关闭，请使用SHUTDOWN ABORT关闭实例。

2. 装载数据库。

3. 还原并恢复缺失的数据文件。

4. 打开数据库。

只需要mount数据库，然后还原和恢复，最后打开数据库即可。

题中应该先A，再D,