Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Redo is inconsistent with data block

704257Oct 14 2012 — edited Oct 15 2012
Hi ,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2012
Added on Oct 14 2012
17 comments
1,082 views