Oracle 11G OCP 1Z0-053 566

（566）You have lost all your SYSTEM tablespace datafiles(system_01.dbf and system_02.dbf) and 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.

A. a,c,f,g

B. b,d,e,h

C. a,b,c,f,g

D. d,a,e,g

E. b,c,f,e,g

答案：（D）

解析：

如果某個資料檔案丟失或損壞，且該檔案屬於SYSTEM或UNDO表空間，請執行以下任務：

1.例項可能會也可能不會自動關閉。如果未自動關閉，請使用SHUTDOWN ABORT關閉例項。

2.裝載資料庫。

3.還原並恢復缺失的資料檔案。

4.開啟資料庫。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1318292/，如需轉載，請註明出處，否則將追究法律責任。