What would you do to recover the data file?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *