---

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）
A: Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.
B: Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.
C: Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.
D: Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.

---

出自：Oracle认证

显示答案