Troubleshooting of corrupted logfile files (ORA-00327)

Logfile file corruption issue handling (ORA-00327), view the specific content of the error, should be the redo file + DATAtyolaponlinelogredo31a corrupt.

Logfile file corruption issue handling (ORA-00327), view error details, should be the redo file + DATA/tyolap/onlinelog/redo31a corrupt.

1, database log error ORA-00327, pay attention to the garbled here

Check the error details. The redo file + DATA/tyolap/onlinelog/redo31a is damaged.

2. Further Check the trc file. The specific reason is not clear, but the log file is damaged.

DE: Problem Key 'ora 313 'was flood controlled (0x1) (no incident)
ORA-00313 :?????? 31 (???? 3 )?????
ORA-00313 :?????? 31 (???? 3 )?????
DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- Start dde Actions Dump -----
Executing SYNC actions
----- Start dde Action: 'db _ STRUCTURE_INTEGRITY_CHECK '(Async )-----
DDE Action 'db _ STRUCTURE_INTEGRITY_CHECK 'was flood controlled
----- End dde Action: 'db _ STRUCTURE_INTEGRITY_CHECK '(flood controlled, 5 csec )-----
Executing ASYNC actions
----- End dde Actions Dump (total 0 csec )-----

3. Check the status of the redo file. The status is INVALID, the other is stale, and the system is still running normally.

4. log files are damaged. The simplest way is to recreate the log files online.

5. The system returns to normal, but the cause of Log File Corruption is not clear yet.