---

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认证

显示答案