nerdexam
Oracle

1Z0-034 · Question #14

Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally because the disk on…

The correct answer is D. Restore the latest backup control file, perform incomplete recovery using backup control file, and. See the full explanation below for the reasoning.

Question

Examine the following scenario:

  • Database is running in ARCHIVELOG mode.
  • Complete consistent backup is taken every Sunday.
  • On Tuesday the instance terminates abnormally because the disk on

which control files are located gets corrupted

  • The disk having active online redo log files is also corrupted.
  • The hardware is repaired and the paths for online redo log files and

control files are still valid. Which option would you use to perform the recovery of database till the point of failure?

Options

  • ARestore the latest whole backup, perform complete recovery, and open the database normally
  • BRestore the latest whole backup, perform incomplete recovery, and open the database with the
  • CRestore the latest backups control file, perform complete recovery, and open the database with
  • DRestore the latest backup control file, perform incomplete recovery using backup control file, and

How the community answered

(32 responses)
  • A
    9% (3)
  • B
    3% (1)
  • C
    3% (1)
  • D
    84% (27)

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice