Re: redo is not consistent

Posted by Arsalan on Aug 04, 2020; 11:08am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/redo-is-not-consistent-tp8551p8553.html


Sir,

After physical server restart then i try to open database then i face new error

SQL> startup
ORACLE instance started.

Total System Global Area 1.3370E+10 bytes
Fixed Size                  2405640 bytes
Variable Size            2051017464 bytes
Database Buffers         1.1312E+10 bytes
Redo Buffers                5033984 bytes
Database mounted.
ORA-00742: Log read detects lost write in thread %d sequence %d block %d
ORA-00312: online log 2 thread 1: 'E:\RECOVERY_AREA\REDO_DATA_2\REDO02.LOG'