Oracle
1Z0-052 · Question #156
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 overwritt
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #156. The question stem and answer options stay visible for context.
Performing Backup and Recovery
Question
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?
Options
- ATake the USERS tablespace offline and re-create the lost data file
- BShutdown the instance, restore the data file from the last consistent backup and restart the database
- CShutdown the instance, restores all the database files from the last consistent backup and restart the
- DTake the USERS tablespace offline, restore all the data files of the USERS tablespace from the last
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#NOARCHIVELOG recovery#media failure#consistent backup restore#overwritten redo logs