Oracle ORA-00600 [25027] ORA-600 [25027]

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]

Format: ORA-600 [25027] [a] [b]

VERSIONS:
versions 9.2 and above
DESCRIPTION:
An invalid Tablespace Number (TSN) and/or Relative File Number (RFN) has been found

ARGUMENTS:
Arg [a] Tablespace Number (TSN)
Arg [b] Decimal Relative Data Block Address (RDBA)

FUNCTIONALITY:
Kernel File management Tablespace component
IMPACT:
PROCESS FAILURE
POSSIBLE PHYSICAL CORRUPTION

SUGGESTIONS:

1. If the Arg [b] (the RDBA) is 0 (zero), then this could be due to fake indexes.

The following query will list fake indexes:

select do.owner,do.object_name, do.object_type,sysind.flags
from dba_objects do, sys.ind$ sysind
where do.object_id = sysind.obj#
and bitand(sysind.flags,4096)=4096;

If the above query returns any rows, check the objects involved and consider dropping them as they can cause this error.

Run analyze table validate structure on the table referenced in the Current SQL statement in
the related trace file.

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:
Known Bugs