---

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
A:Take the USERS tablespace offline and re-create the lost data file.
B:Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
C:Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
D:Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

---

出自：Oracle认证

显示答案