nerdexam
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)
  • A
    5% (3)
  • B
    2% (1)
  • C
    8% (5)
  • D
    2% (1)
  • E
    84% (53)

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice