Hi All, As we know when we issue a COMMIT the log buffer content is flushed to the online redo log file before the "Commit complete" status is returned to the user. Please correct me if I am wrong. I have the following scenario... SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- /u04/oradata/BIDWDB01/redo03.log /u04/oradata/BIDWDB01/redo02.log /u04/oradata/BIDWDB01/redo01.log SQL> !rm /u04/oradata/BIDWDB01/redo01.log SQL> !rm /u04/oradata/BIDWDB01/redo02.log SQL> !rm /u04/oradata/BIDWDB01/redo03.log SQL> connect scott/oracle Connected. SQL> update emp set ename=ename; 14 rows updated. SQL> commit; Commit complete. SQL> commit; Commit complete. SQL> conn / as sysdba Connected. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 4479516672 bytes Fixed Size 1984504 bytes Variable Size 905975816 bytes Database Buffers 3556769792 bytes Redo Buffers 14786560 bytes Database mounted. ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u04/oradata/BIDWDB01/redo01.log' ----------------------- My question is even after deleting all the online redo log files how did Oracle returned the Commit complete status to the user? What happened to the log buffer data flush? I am using 10.2.0.2 on Solaris 9 (64-bit) Regards, Deepak