Redo is inconsistent with data block
704257Oct 14 2012 — edited Oct 15 2012Hi ,
My database running on oracle10g noarchive mode.
Now I am facing following problem . pls help me ASAP.
Advanced thanx.
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250452 bytes
Variable Size 88083308 bytes
Database Buffers 520093696 bytes
Redo Buffers 2940928 bytes
Database mounted.
SQL> recover database
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [7], [138042], [29498170],
[], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 7, block# 138042)
ORA-10564: tablespace ADP_DATA
ORA-01110: data file 7: 'D:\DATAFILES\ADP_DAT01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 101140