DEVFYI - Developer Resource - FYI

What is meant by Redo Log file mirroring ? How it can be achieved?

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

310. What is meant by Redo Log file mirroring ? How it can be achieved?

Process of having a copy of redo log files is called mirroring. This can be achieved by creating group of log files together, so that LGWR will automatically writes them to all the members of the current on-line redo log group. If any one group fails then database automatically switch over to next group. It degrades performance.

(Continued on next question...)

Other Interview Questions