Oracle
1Z0-063 · Question #174
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last…
The correct answer is C. Shut down the instance if not already shut down, restore all data files for the entire database from. See the full explanation below for the reasoning.
Question
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup. Which method would you use to recover the data file?
Options
- AShut down the instance if not already shut down, restore all data files belonging to the system
- BShut down the instance if not already shut down, restore the corrupted data file belonging to the
- CShut down the instance if not already shut down, restore all data files for the entire database from
- DMount the database, restore all data files belonging to the system tablespace from the last
How the community answered
(41 responses)- A5% (2)
- B12% (5)
- C80% (33)
- D2% (1)
Community Discussion
No community discussion yet for this question.