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 since the 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.
Shutdown the instance, restore the data file from the last consistent backup and restart the
database instance
C.
Shutdown the instance, restores all the database files from the last consistent backup and restart
the database instance
D.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last
consistent backup and make the tablespace online
In the non-archive mode, only the cold backup to back up all files.
When the data file is missing, the redo log is overwritten.
It can only restore to the most recent consistent backup.
You can not be used to restore redo logs to a specified point in time.
With the database in NOARCHIVELOG mode (the default mode), it can only restore to the state of the last backup.
After the backup is performed, all transactions will be lost.
True, alonzo your logic is right.