Oracle
1Z0-067 · Question #48
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. https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89841
New Features for Availability
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
(17 responses)- B6% (1)
- C82% (14)
- D12% (2)
Explanation
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89841
Topics
#noarchivelog mode#system tablespace recovery#data file restore#complete database restore
Community Discussion
No community discussion yet for this question.