nerdexam
Oracle

1Z0-052 · Question #247

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is…

The correct answer is F. You would need to restore the missing log file by copying one of the remaining files from the same. Because redo log groups are multiplexed, all members within a group hold identical data, so a lost non-current member can be recovered simply by copying a surviving member from the same group.

Performing Backup and Recovery

Question

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?

Options

  • ASMON would automatically restore the lost file.
  • BYou would need to restore the whole database from the last backup.
  • CYou would need to restore the file from the last full database backup.
  • DYou would need to use flashback technology to restore the lost redo log member.
  • EYou would need to use Recovery Manager (RMAN) to restore the lost redo log member.
  • FYou would need to restore the missing log file by copying one of the remaining files from the same

How the community answered

(43 responses)
  • A
    5% (2)
  • B
    2% (1)
  • D
    14% (6)
  • E
    7% (3)
  • F
    72% (31)

Why each option

Because redo log groups are multiplexed, all members within a group hold identical data, so a lost non-current member can be recovered simply by copying a surviving member from the same group.

ASMON would automatically restore the lost file.

SMON handles instance recovery and free-space coalescing but has no ability to automatically detect or recreate lost redo log member files.

BYou would need to restore the whole database from the last backup.

A full database restore is unnecessary because the lost member's content is preserved in the other surviving members of the same multiplexed group.

CYou would need to restore the file from the last full database backup.

Restoring from a full backup is not required since identical data exists in the remaining members of the same redo log group, making a backup restore redundant.

DYou would need to use flashback technology to restore the lost redo log member.

Flashback technology uses Flashback Logs to rewind database state to a prior SCN, but it cannot recreate or restore physical redo log member files.

EYou would need to use Recovery Manager (RMAN) to restore the lost redo log member.

RMAN can restore archived redo logs and datafiles from backup, but it cannot restore or recreate individual online redo log member files from a standard backup set.

FYou would need to restore the missing log file by copying one of the remaining files from the sameCorrect

In a multiplexed redo log setup, Oracle writes simultaneously to every member of a group, making all members byte-for-byte identical. Because the lost member belongs to a non-current group, no active writes are occurring to it, so copying any intact surviving member from the same group to the missing file location fully restores the data. After the copy, the database can be informed of the updated member path using ALTER DATABASE if needed.

Concept tested: Recovery of multiplexed redo log member loss

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-the-redo-log.html

Topics

#redo log multiplexing#log member recovery#redo log groups#non-current group

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice