nerdexam
Oracle

1Z0-063 · Question #22

Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is…

The correct answer is C. 2, 3, 4, 5. See the full explanation below for the reasoning.

Question

Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted. Examine the steps to recover the online redo log group and move it to a new location. 1) Restore the corrupted redo log group. 2) Restore the database from the most recent database backup. 3) Perform an incomplete recovery. 4) Relocatethe member of the damaged online redo log group to a new location. 5) Open the database with the resetlogs option. 6) Issue a checkpoint and clear the log. Identify the required steps in the correct order.

Options

  • A1, 3, 4, 5
  • B6, 3, 4, 5
  • C2, 3, 4, 5
  • D6, 4,3, 5

How the community answered

(55 responses)
  • A
    15% (8)
  • B
    5% (3)
  • C
    76% (42)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice