Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file()
- ATake the USERS tablespace offline and re-create the lost data file.
- BShut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
- CShut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
- DTake the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.