1 2 Previous Next 19 Replies Latest reply on Aug 14, 2009 7:26 AM by user00726 Go to original post
      • 16. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867],
        716907
        hi can u post me this output connecting as DBA

        SQL > select * from v$database_block_corruption;
        • 17. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867],
          user00726
          Around 65 rows are corrupted
          SQL> select * from v$database_block_corruption;
          
               FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
          ---------- ---------- ---------- ------------------ ---------
                   4      30601          1         1969161846 LOGICAL
                   4      30890          1         1969159472 LOGICAL
                   4      31710          1         1966225341 LOGICAL
                   4      31726          1         1964949467 LOGICAL
                   4      32135          1         1964917037 LOGICAL
                   4      32407          1         1966847173 LOGICAL
                   4      32748          1         1966521267 LOGICAL
                   4      32931          1         1963862106 LOGICAL
                   4      32938          1         1966518269 LOGICAL
                   4      33114          1         1965956124 LOGICAL
                   4      33189          1         1965098829 LOGICAL
          
               FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
          ---------- ---------- ---------- ------------------ ---------
                   4      33203          1         1964966768 LOGICAL
                   4      33223          1         1967401645 LOGICAL
                   4      33237          1         1965336113 LOGICAL
                   4      33283          1         1963781769 LOGICAL
                   4      33350          1         1965174401 LOGICAL
                   4      33380          1         1964399958 LOGICAL
                   4     193009          1         1965834937 LOGICAL
                   4     193036          1         1966531938 LOGICAL
                   4     193038          1         1965790605 LOGICAL
                   4     193069          1         1966677048 LOGICAL
                   4     193075          1         1966221560 LOGICAL
          
               FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
          ---------- ---------- ---------- ------------------ ---------
                   4     193083          1         1966606417 LOGICAL
                   4     193093          1         1966222095 LOGICAL
                   4     193109          1         1966291361 LOGICAL
                   4     193117          1         1967275356 LOGICAL
                   4     193180          1         1968524127 LOGICAL
                   4     193342          1         1968943229 LOGICAL
                   4     193373          1         1969751527 LOGICAL
                   4     193401          1         1969170245 LOGICAL
                   4     193428          1         1969595748 LOGICAL
                   4     193430          1         1969590748 LOGICAL
                   4     193439          1         1969637879 LOGICAL
          
               FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
          ---------- ---------- ---------- ------------------ ---------
                   4     193444          1         1969596284 LOGICAL
                   4     193452          1         1969587389 LOGICAL
                   4     193454          1         1969609761 LOGICAL
                   4     193460          1         1969587690 LOGICAL
                   4     193486          1         1969625668 LOGICAL
                   4     193559          1         1969294359 LOGICAL
                   4     193575          1         1969297628 LOGICAL
                   4     193589          1         1969587992 LOGICAL
                   4     193605          1         1969588914 LOGICAL
                   4     193618          2         1969435891 LOGICAL
                   4     193621          1         1969589382 LOGICAL
          
               FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
          ---------- ---------- ---------- ------------------ ---------
                   4     193634          2         1969454341 LOGICAL
                   4     193637          1         1969589495 LOGICAL
                   4     193651          1         1970211950 LOGICAL
                   4     193653          1         1969589856 LOGICAL
                   4     193667          1         1970213014 LOGICAL
                   4     193669          1         1969590323 LOGICAL
                   4     193690          1         1970018306 LOGICAL
                   4     193710          1         1970185157 LOGICAL
                   4     193747          1         1969904789 LOGICAL
                   4     193780          1         1969752225 LOGICAL
                   4     193814          1         1970055557 LOGICAL
          
               FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
          ---------- ---------- ---------- ------------------ ---------
                   4     193886          1         1970201316 LOGICAL
                   4     193903          1         1970190853 LOGICAL
                   4     193908          1         1969882310 LOGICAL
                   4     196533          1         1970284195 LOGICAL
                   4     196549          1         1970285719 LOGICAL
                   4     196575          1         1970295085 LOGICAL
                   4     196591          1         1970298528 LOGICAL
                   4     196607          1         1970300912 LOGICAL
                   4     196639          1         1970305683 LOGICAL
                   4     196655          1         1970309051 LOGICAL
          
          65 rows selected.
          
          SQL>
          When i try to create a new table using CTAS there is around difference of 3500 rows
          SQL> create table OM_STUDENT_HEAD_TEST as seelct * from OM_STUDENT_HEAD;
          
          SQL> select count(*) from om_student_head;
          
            COUNT(*)
          ----------
             1991354
          
          SQL> select  count(*) from OM_STUDENT_HEAD_TEST
            2  ;
          
            COUNT(*)
          ----------
             1987559
          Now, wat should be the next step...
          • 18. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867],
            user00726
            Even through RMAN i am not able to reccover the corrupt blocks
            RMAN> blockrecover datafile 4 block 193651 from TAG "TAG20090811T161049";
            
            Starting blockrecover at 13-AUG-09
            using channel ORA_DISK_1
            
            
            channel ORA_DISK_1: restoring block(s)
            channel ORA_DISK_1: specifying block(s) to restore from backup set
            restoring blocks of datafile 00004
            channel ORA_DISK_1: restored block(s) from backup piece 1
            piece handle=/u01/rman/ICAI_S_66_P_1_T_694628371 tag=TAG20090811T161049 params=N
            ULL
            channel ORA_DISK_1: block restore complete
            
            
            
            
            
            starting media recovery
            some blocks not recovered: See trace file for details
            media recovery complete
            
            Finished blockrecover at 13-AUG-09
            Actaully it was asking for ealier backupset piece that i am not having so i have to specify thew latest backup piece and still the problem is there...

            In alert log file
            Errors in file /u01/app/oracle/admin/icai/udump/icai_ora_20199.trc:
            ORA-00600: internal error code, arguments: [12333], [253], [1], [253], [], [], [
            ], []
            corrupt block 517395 found during reading backup piece,file=/u01/rman/ICAI_S_66_
            P_1_T_694628371, corr_type=-3
            Reread of blocknum=517395, file=/u01/rman/ICAI_S_66_P_1_T_694628371. found diffe
            rent data
            Thu Aug 13 15:46:05 2009
            Errors in file /u01/app/oracle/admin/icai/udump/icai_ora_21586.trc:
            ORA-00600: internal error code, arguments: [12700], [34135], [16970867], [14], [
            15807313], [25], [], []
            Thu Aug 13 15:46:58 2009
            Errors in file /u01/app/oracle/admin/icai/udump/icai_ora_21498.trc:
            ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], [
            ]
            Thu Aug 13 15:48:07 2009
            1 2 Previous Next