Oracle
1Z0-034 · Question #45
Your database is in NOARCHIVELOG mode. One of the two data files belonging to the SYSTEM tablespace is corrupt. You discover that all online redo logs have been overwritten since the last backup…
The correct answer is E. Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data files. See the full explanation below for the reasoning.
Question
Your database is in NOARCHIVELOG mode. One of the two data files belonging to the SYSTEM tablespace is corrupt. You discover that all online redo logs have been overwritten since the last backup. Which method would you use to recover the data file using RMAN?
Options
- AShut down the instance if not already shut down, restart in MOUNT state, restore both data files
- BShut down the instance if not already shut down, restart in mount state, restore the corrupted data
- CShut down the instance if not already shut down, restart in mount state, restore all data files for
- DShut down the instance if not already shut down, restart In MOUNT state, restore all data files
- EShut down the instance if not already shut down, restart In NOMOUNT state, restore all data files
How the community answered
(63 responses)- A5% (3)
- B2% (1)
- C8% (5)
- D2% (1)
- E84% (53)
Community Discussion
No community discussion yet for this question.