Pessoal, Alguém sabe porque o erro abaixo aconteceu?
Obs: resolvi o problema com o problema fazendo uma recuperação, mas tenho medo deste erro voltar a acontecer. S.O Linux gi-ora-03 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17 EDT 2006 i686 i686 i386 GNU/Linux Oracle Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod Segue log de alerta Sun Aug 2 00:26:13 2009 Thread 1 cannot allocate new log, sequence 734 Private strand flush not complete Current log# 2 seq# 733 mem# 0: /u02/oradata/prod02/redo/redoB02.rdo Current log# 2 seq# 733 mem# 1: /u02/oradata/prod02/redo/redoA02.rdo Sun Aug 2 00:26:13 2009 Thread 1 advanced to log sequence 734 (LGWR switch) Current log# 4 seq# 734 mem# 0: /u02/oradata/prod02/redo/redoA04.rdo Current log# 4 seq# 734 mem# 1: /u02/oradata/prod02/redo/redoB04.rdo Sun Aug 2 00:51:06 2009 Thread 1 cannot allocate new log, sequence 735 Private strand flush not complete Current log# 4 seq# 734 mem# 0: /u02/oradata/prod02/redo/redoA04.rdo Current log# 4 seq# 734 mem# 1: /u02/oradata/prod02/redo/redoB04.rdo Sun Aug 2 00:51:08 2009 Thread 1 advanced to log sequence 735 (LGWR switch) Current log# 3 seq# 735 mem# 0: /u02/oradata/prod02/redo/redoA03.rdo Current log# 3 seq# 735 mem# 1: /u02/oradata/prod02/redo/redoB03.rdo Sun Aug 2 04:35:31 2009 Errors in file /u01/app/oracle/admin/prod02/bdump/prod02_lgwr_20790.trc: ORA-00345: redo log write error block 29819 count 2 ORA-00312: online log 3 thread 1: '/u02/oradata/prod02/redo/redoA03.rdo' ORA-27072: File I/O error Linux Error: 5: Input/output error Additional information: 4 Additional information: 29819 Additional information: -1 ORA-00345: redo log write error block 29819 count 2 ORA-00312: online log 3 thread 1: '/u02/oradata/prod02/redo/redoB03.rdo' ORA-27072: File I/O error Linux Error: 5: Input/output error Additional information: 4 Additional information: 29819 Additional information: -1 Sun Aug 2 04:35:40 2009 Errors in file /u01/app/oracle/admin/prod02/bdump/prod02_lgwr_20790.trc: ORA-00340: IO error processing online log 3 of thread 1 ORA-00345: redo log write error block 29819 count 2 ORA-00312: online log 3 thread 1: '/u02/oradata/prod02/redo/redoA03.rdo' ORA-27072: File I/O error Linux Error: 5: Input/output error Additional information: 4 Additional information: 29819 Additional information: -1 ORA-00345: redo log write error block 29819 count 2 ORA-00312: online log 3 thread 1: '/u02/oradata/prod02/redo/redoB03.rdo' ORA-27072: File I/O error Linux Error: 5: Input/output error Additional information: 4 Additional information: 29819 Additional information: -1 Sun Aug 2 04:35:40 2009 LGWR: terminating instance due to error 340 Instance terminated by LGWR, pid = 20790 Atenciosamente, Dalton ________________________________ A Informação Confidencial deverá ser utilizada única e exclusivamente no âmbito da relação com a Glauco Informática e não poderá ser repassada, reproduzida de qualquer outra forma, e nem revelada a terceiros. La información confidencial se utilizará única y exclusivamente en relación con Glauco Informática, y no se puede pasar, reproduce en modo alguno, ni revelada a terceros. The Confidential Information will be used solely and exclusively in relation to the Glauco Informatica and not be passed, reproduced in any way, nor disclosed to third parties. [As partes desta mensagem que não continham texto foram removidas]
