REDO LOG BUFFER DOUBT
845641Aug 5 2011 — edited Aug 7 2011Hi EXPERTS,
Im on 11G R2, RHEL 5 my question that when data is modified in database buffer cache how immediately it is copied to redo log buffer. I mean which process copies it. I read it in oracle documentation that when waiting for event [ log file switch (private strand flush incomplete) ] LGWR waits for DBWR to complete flushing redo from IMU buffers into the redo log buffer; when DBWR is complete LGWR can then finish writing the current log, and then switch log files.