Multiple choice technology databases

In your DB -multiplexed online redo log files,one of the members in a group is lost due to media failure? You wud..

  1. import the database from the last export

  2. restore all the members in the group from the last backup

  3. drop the lost member from the database and then add a new member to the group

  4. restore all the database files from the backup and then perform a complete recovery

  5. restore all the database files from the backup and then perform an incomplete recovery
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In multiplexed redo log groups, each member is a copy. Losing one member doesn't cause data loss since other members have identical content. The correct action is to drop the damaged member from the group and add a new one - Oracle continues operating using the remaining good members. Options A, B, D, E are overreactions - full restore/import/incomplete recovery are unnecessary when you have redundant copies.

Keep practicing — related questions