ORA-00600Kcfrbd_3 appears in the query DBA_EXTENTS work und

Source: Internet
Author: User
This article summarizes the ORA-00600Kcfrbd_3 appears in the query DBA_EXTENTS solution, encountered such problems can look at friends.

This article summarizes the ORA-00600 Kcfrbd_3 appear in the query DBA_EXTENTS solution, encountered such problems of friends can look.

This article summarizes the ORA-00600 Kcfrbd_3 appear in the query DBA_EXTENTS solution, encountered such problems of friends can look.

In some cases, when querying the database's dba_extents dictionary table, you may encounter the ORA-600 kcfrbd_3 error, which is caused by file size and control file mismatch, the trigger may be caused by a database write exception, which can be eliminated by recreating the control file.
However, if the information in the data file header is incorrect and does not match the data file itself, you must modify the file size information in the data file header to solve the problem.


This issue is extremely rare. The following reference information is recorded in MOS Note 601798.1:

The Code is as follows:


Oracle reports the ORA-00600: [kcfrbd_3] on a particle query.
The same exception is encountered if you try to select DBA_EXTENTS using a FILE #/BLOCK #.


The following are the main parameters of the 600 error:

The Code is as follows:

Ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcfrbd_3], [13], [64011], [1], [64000], [64000], [], []


Arg [a] File number
Arg [B] Block number
Arg [c] Nro of blocks
Arg [d] Logical File Size
Arg [e] File Size


The first parameter is the file number. The following 13 is the file number:

The Code is as follows:

SELECT segment_name, segment_type, owner, tablespace_name
FROM sys. dba_extents
WHERE file_id = 13
AND 64011 BETWEEN block_id and block_id + blocks-1;


ERROR at line 2:
ORA-00600: internal error code, arguments: [kcfrbd_3], [13], [66499], [1], [64000], [64000], [], []
Cause


There is a temporary uption on the extent allocation table to tablespace that


The file #13 belongs.
For example, in this case,


Datafile #13 is + DATA/ORCL/datafile/mgmt_tablespace.340.655388135
(FOB) flags = 512 fib = 0x1629c8f68 incno = 0 pending I/o cnt = 0


Fname = + DATA/ORCL/datafile/mgmt_tablespace.340.655388135


Fno = 13 lblksz = 8192 fsiz = 64000
We are trying to access the block 64011 that is beyond the number of blocks 6400.


In the simplest case, you can use the resize file to remove it.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.