6 Replies Latest reply: Feb 28, 2012 3:26 PM by Saugat Chatterjee RSS

    ORA-10567: Redo is inconsistent with data block (file# 2, block# 73)

    102430
      SQL> spool c:\stdb.txt
      SQL> startup nomount PFILE='E:\oracle\admin\fno\pfile\init.ora';
      ORACLE instance started.

      Total System Global Area 730931140 bytes
      Fixed Size 454596 bytes
      Variable Size 285212672 bytes
      Database Buffers 444596224 bytes
      Redo Buffers 667648 bytes
      SQL> ALTER DATABASE MOUNT STANDBY DATABASE;

      Database altered.

      SQL> RECOVER STANDBY DATABASE;
      ORA-00279: change 7990686470 generated at 04/01/2006 15:53:57 needed for threa 1

      ORA-00289: suggestion : F:\ORACLE\ORADATA\FNO\ARCH\LOG_17032.ARC
      ORA-00280: change 7990686470 for thread 1 is in sequence #7032


      Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
      AUTO
      ORA-00283: recovery session canceled due to errors
      ORA-00600: internal error code, arguments: [3020], [8388681], [1],

      [7032],
      [137367], [16], [], []
      ORA-10567: Redo is inconsistent with data block (file# 2, block# 73)
      ORA-10564: tablespace UNDOTBS1
      ORA-01110: data file 2: 'G:\ORACLE\ORADATA\FNO\UNDOTBS01.DBF'
      ORA-10560: block type 'KTU SMU HEADER BLOCK'


      ORA-01112: media recovery not started


      Please help if anybody nows solution for this.

      Regds,
      Ramesh
      e-mail to : rameshgiri27@yahoo.com
      Mobile NO: +91 080 9341018616