ORA-16038/ORA-00742: Log read detects lost write in thread

ORA-16038/ORA-00742: Log read detects lost write in thread
A friend encounters a "Write loss" error in the redo log of the Oracle database, causing the database to fail to be started.

The logs are as follows: redo log 5 cannot be archived and "Write loss" is detected ". Eventually, Oracle goes down.
Errors in file/u01/app/oracle/diag/rdbmsdbcontrol/GZDBCONTROL/trace/GZDBCONTROL_ora_32198.trc:
The ORA-16038: log 5 sequence #23 cannot be archived
ORA-00742: Log read detects lost write in thread % d sequence % d block % d
ORA-00312: online log 5 thread 1: '/u01/app/oracle/fast_recovery_area/GZDBCONTROL/onlinelog/o1_mf_5_d61ctj3y _. Log'
USER (ospid: 32198): terminating the instance due to error 16038
System state dump requested by (instance = 1, osid = 32198), summary = [abnormal instance termination].
System State dumped to trace file/u01/app/oracle/diag/rdbmsdbcontrol/GZDBCONTROL/trace/GZDBCONTROL_diag_32167_20161227110109.trc
Dumping diagnostic data in directory = [cdmp_20161227110109], requested by (instance = 1, osid = 32198), summary = [abnormal instance termination].

Cause:
These three cleanups may cause "Write loss": Operating System, storage system, and Oracle internal errors.

Solution:
Use dump to determine whether "Write loss" has actually occurred ".
SQL> alter system dump logfile '/u01/app/oracle/fast_recovery_area/GZDBCONTROL/onlinelog/o1_mf_5_d61ctj3y _. log' validate;

ERROR at line 1:
ORA-00742: Log read detects lost write in thread % d sequence % d block % d
ORA-00334: archived log:
'/U01/app/oracle/fast_recovery_area/GZDBCONTROL/onlinelog/o1_mf_5_d61ctj3y _. Log'

From the above dump results, it is confirmed that "Write loss" is cleared, and the problematic redo logfile is cleared to restore normal archiving.

SQL> alter database clear unarchived logfile group 5;

Follow these steps to enable the Oracle database of a friend.
Finally, do not forget to make a full backup.

Refer:
Database Crashe with ORA-16038/ORA-742 Errors (Document ID 2064718.1)
Http://docs.oracle.com/cd/E11882_01/server.112/e17766/e0.htm

Reprinted Please note:
Cross screw
QQ: 463725310
Site: www.dbhelp.net (for more updates, please visit)
Http://blog.chinaunix.net/uid/23284114.html
E-MAIL: houora # gmail.com (# Replace it @)