redo is not consistent

Posted by Arsalan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/redo-is-not-consistent-tp8551.html


Hello Arslan
have a nice day,

Oracle 11.2
os window 2012

After database abnormally down due to electricity, when i try to open database i face below problem



startup
database mounted.
ORA-01172:recovery of thread 1 stuck at block 1974713 of file 7
ORA-01151:use media recovery to recover block,restore backup if needs

Then I Did.

shut immediate;

startup mount;

recover database;

ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [7], [2363530], [31723658], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 7, block# 2363530, file offset is 2182168576 bytes)
ORA-10564: tablespace IRD_DATA_LARGE
ORA-01110: data file 7: 'D:\APP\ADMINISTRATOR\ORADATA\AFGPROD\IRD_DATA_LARGE01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 542394

Please guide me

Thanks