If you cannot recover data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help.
Parnassusdata Software Database Recovery Team
Service Hotline: +86 13764045638 E-mail: [email protected]
ERROR:
Format: ORA-600 [qertbfetchbyrowid]
VERSIONS: versions 10.1 and above SUGGESTIONS: If the Known Issues section below does not help in terms of identifying a solution, please submit the trace files and alert.log to Oracle Support Services for further analysis. Known Issues:
You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:
| NB | Prob | Bug | Fixed | Description |
| II | 12821418 | 11.2.0.3.8, 11.2.0.3.BP18, 11.2.0.4, 12.1.0.1 | Direct NFS appears to be sending zero length windows to storage device. It may also cause Lost Writes | |
| III | 10633840 | 11.2.0.2.7, 11.2.0.2.BP17, 11.2.0.3, 12.1.0.1 | ORA-1502 on insert statement on INTERVAL partitioned table. ORA-8102 / ORA-1499 Index inconsistency | |
| II | 10245259 | 11.2.0.2.BP03, 11.2.0.3, 12.1.0.1 | PARALLEL INSERT with +NOAPPEND hint or if PARALLEL INSERT plan is executed in SERIAL corrupts index and causes wrong results | |
| + | II | 10209232 | 11.1.0.7.7, 11.2.0.1.BP08, 11.2.0.2.1, 11.2.0.2.BP02, 11.2.0.2.GIBUNDLE01, 11.2.0.3, 12.1.0.1 | ORA-1578 / ORA-600 [3020] Corruption. Misplaced Blocks and Lost Write in ASM |
| + | II | 9734539 | 11.2.0.2, 12.1.0.1 | ORA-8102 / ORA-1499 corrupt index after update/merge using QUERY REWRITE |
| + | III | 9469117 | 10.2.0.5.4, 11.2.0.1.BP04, 11.2.0.2, 12.1.0.1 | Corrupt index after PDML executed in serial. Wrong results. OERI[kdsgrp1]/ORA-1499 by analyze |
| + | II | 9231605 | 11.1.0.7.4, 11.2.0.1.3, 11.2.0.1.BP02, 11.2.0.2, 12.1.0.1 | Block corruption with missing row on a compressed table after DELETE |
| + | II | 8951812 | 11.2.0.2, 12.1.0.1 | Corrupt index by rebuild online. Possible OERI [kddummy_blkchk] by SMON |
| E | II | 8720802 | 10.2.0.5, 11.2.0.1.BP07, 11.2.0.2, 12.1.0.1 | Add check for row piece pointing to itself (db_block_checking,dbv,rman,analyze) |
| P | II | 8635179 | 10.2.0.5, 11.2.0.2, 12.1.0.1 | Solaris: directio may be disabled for RAC file access. Corruption / Lost Write |
| + | II | 8597106 | 11.2.0.1.BP06, 11.2.0.2, 12.1.0.1 | Lost Write in ASM when normal redundancy is used |
| + | II | 8546356 | 10.2.0.5.1, 11.2.0.1.3, 11.2.0.1.BP07, 11.2.0.2, 12.1.0.1 | ORA-8102/ORA-1499/OERI[kdsgrp1] Composite Partitioned Index corruption after rebuild ONLINE in RAC |
| II | 7710827 | 11.2.0.2, 12.1.0.1 | Index rebuild or Merge partition causes wrong results in concurrent reads instead of ORA-8103 | |
| II | 7705591 | 10.2.0.5, 11.2.0.1.1, 11.2.0.1.BP04, 11.2.0.2, 12.1.0.1 | Corruption with self-referenced row in MSSM tablespace. Wrong Results / OERI[6749] / ORA-8102 | |
| I | 8588540 | 11.1.0.7.2, 11.2.0.1 | Corruption / ORA-8102 in RAC with loopback DB links between instances | |
| + | III | 7329252 | 10.2.0.4.4, 10.2.0.5, 11.1.0.7.5, 11.2.0.1 | ORA-8102/ORA-1499/OERI[kdsgrp1] Index corruption after rebuild index ONLINE |
| II | 6791996 | 11.2.0.1 | ORA-600 errors for a DELETE with self referencing FK constraint and BITMAP index | |
| III | 6404058 | 10.2.0.5, 11.1.0.7, 11.2.0.1 | OERI:12700 OERI:kdsgrp1 OERI:qertbFetchByRowID wrong results from CR rollback of split index leaf | |
| II | 6772911 | 10.2.0.5, 11.1.0.7.3 | OERI[12700] OERI[qertbFetchByRowID] OERI[kdsgrp1] due to bad CR rollback of INDEX block | |
| – | 5621677 | 10.2.0.4, 11.1.0.6 | Logical corruption with PARALLEL update | |
| II | 4883635 | 10.2.0.4, 11.1.0.6 | MERGE (with DELETE) can produce wrong results or Logical corruption in chained rows | |
| – | 4258825 | 10.1.0.5, 10.2.0.1 | R-TREE index may get corruptioned (may contain orphan ROWIDs) | |
| – | 4000840 | 9.2.0.7, 10.1.0.4, 10.2.0.1 | Update of a row with more than 255 columns can cause block corruption |
qertbfetchbyrowid qertbfetchbyrowid qertbfetchbyrowid qertbfetchbyrowid qertbfetchbyrowid qertbfetchbyrowid
qertbfetchbyrowid qertbfetchbyrowid qertbfetchbyrowid qertbfetchbyrowid qertbfetchbyrowid qertbfetchbyrowid
Leave a Reply