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?
A.
SMON would automatically restore the lost file.
B.
You would need to restore the whole database from the last backup.
C.
You would need to restore the file from the last full database backup.
D.
You would need to use flashback technology to restore the lost redo log member.
E.
You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
F.
You would need to restore the missing log file by copying one of the remaining files from the same
group.
multiplex :
of, relating to, or using equipment permitting the simultaneous transmission of two or more trains of signals or messages over a single channel.
Copy one of the remaining files to restore the missing member.
NOTE: To multiplex your redo log, you must add members to each redo log group. This example will add one member to each redo log group.