【Oracle数据库恢复】ORA-00600[25027]错误解析-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

【Oracle数据库恢复】ORA-00600[25027]错误解析

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:36 PM

oraclerecoverdatabase

ORA-00600[25027]错误的触发原因是ORACLE检测到一个无效的表空间号TSN Tablespace Number或者相对文件号Relative File Number。该ORA-00600[25027]的2个变量各代表： arg[a] Tablespace Number表空间号 arg[b] 十进制的相对数据块号Relative Data Block Add

ORA-00600[25027]错误的触发原因是ORACLE检测到一个无效的表空间号TSN Tablespace Number或者相对文件号Relative File Number。

该ORA-00600[25027]的2个变量各代表：

arg[a] Tablespace Number表空间号

arg[b] 十进制的相对数据块号Relative Data Block Address (RDBA)

该ORA-00600[25027]错误相关的模块为Kernel File management Tablespace component，其影响为可能的物理块损坏。

当该错误触发后如果 arg[b] 即RDBA为0，则该错误可能由于索引问题引起。

可以使用如下查询来获得有问题的索引：

 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;

如果上面的查询返回了数据行，则建议用户进一步检查查询所获得的对象，并考虑drop这些对象来绕过错误。

进一步可以对trace文件中指向的表做一个analyze table validate structure cascade，来进一步确认该问题。

与ORA-00600[25027]相关的一些BUG列表如下：

?如果自己搞不定可以找ASKMACLEAN专业ORACLE数据库修复团队成员帮您恢复!

NB	Bug	Fixed	Description
14010183	11.2.0.3.BP22, 11.2.0.4.BP03, 12.1.0.2, 12.2.0.0	ORA-600 [ktspfundo:objdchk_kcbgcur_3] in SMON after failed temp segment merge load
13503554	11.2.0.4, 12.2.0.0	Various ORA-600 errors crashing the apply process in a downstreams environment
13785716	11.2.0.4, 12.1.0.1	Intermittent ORA-600 [25027] during upgrade from 10.2 to 11.2
11661824	11.2.0.1.BP09	Assorted Dumps by SQL*LOADER using DIRECT and PARALLEL after exadata bp8 is applied
10067246	12.2.0.0	ORA-600 [25027] ORA-7445 [kauxs_do_dml_cooperation] by CREATE INDEX ONLINE
14138130	11.2.0.3.5, 11.2.0.3.BP13, 11.2.0.4, 12.1.0.1	SGA memory corruption / ORA-7445 when modifying uncompressed blocks of an HCC-compressed segment
13330018	11.2.0.4, 12.1.0.1	ora-600 [ktspfmb_add1], [4294959240] occurred, then cannot recover with ora-600[25027]
13103913	11.2.0.2.BP15, 11.2.0.3.3, 11.2.0.3.BP03, 11.2.0.4, 12.1.0.1	ORA-600 [25027] [ts#] [1] or false ORA-1 during dml while index is being rebuilt online
10394825	11.2.0.3, 12.1.0.1	ORA-600[25027] [..] [0] inserting to ASSM segment
10329146	11.2.0.1.BP10, 11.2.0.2.2, 11.2.0.2.BP03, 11.2.0.2.GIBUNDLE02, 11.2.0.2.GIPSU02, 11.2.0.3, 12.1.0.1	Lost write in ASM with multiple DBWs and a disk is offlined and then onlined
+	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
+	9399991	11.1.0.7.5, 11.2.0.1.3, 11.2.0.1.BP04, 11.2.0.2, 12.1.0.1	Assorted Internal Errors and Dumps (mostly under kkpa/kcb) from SQL against partitioned tables
*	9145541	11.1.0.7.4, 11.2.0.1.2, 11.2.0.2, 12.1.0.1	OERI[25027]/OERI[4097]/OERI[4000]/ORA-1555 in plugged datafile after CREATE CONTROLFILE in 11g
8837919	11.2.0.2, 12.1.0.1	DBV / RMAN enhanced to detect ASSM blocks with ktbfbseg but not ktbfexthd flag set as in Bug 8803762
8803762	11.1.0.7.6, 11.2.0.1.2, 11.2.0.1.BP06, 11.2.0.2, 12.1.0.1	ORA-600[kdsgrp1], ORA-600[25027] or wrong results on 11g database upgrade from 9i
8716064	11.2.0.2, 12.1.0.1	Analyze Table Validate Structure fails on ADG standby with several errors
+	8597106	11.2.0.1.BP06, 11.2.0.2, 12.1.0.1	Lost Write in ASM when normal redundancy is used
7251049	11.2.0.1.BP08, 11.2.0.2, 12.1.0.1	Corruption in bitmap index introduced when using transportable tablespaces
8437213	10.2.0.4.3, 10.2.0.5, 11.1.0.7.7, 11.2.0.1	ASSM first level bitmap block corruption
8356966	11.2.0.1	ORA-7445 [kdr9ir2rst] by DBMS_ADVISOR or false ORA-1498 by ANALYZE on COMPRESS table
*	8198906	10.2.0.5, 11.2.0.1	OERI [kddummy_blkchk] / OERI [5467] for an aborted transaction of allocating extents
*	7263842	10.2.0.4.2, 10.2.0.5, 11.1.0.7.1, 11.2.0.1	ORA-955 during CTAS / OERI [ktsircinfo_num1] / dictionary inconsistency for PARTITIONED Tables
6666915	10.2.0.5, 11.1.0.7, 11.2.0.1	OERI[25027] / dictionary corruption from concurrent partition DDL
6025993	10.2.0.5, 11.1.0.6	ORA-600 [25027] in flashback archiving queries
4925342	9.2.0.8, 10.2.0.3, 11.1.0.6	OERI [25027] / OERI [25012] on IOT analyze estimate statistics
*	7190270	10.2.0.4.1, 10.2.0.5	Various ORA-600 errors / dictionary inconsistency from CTAS / DROP
4310371	9.2.0.8, 10.2.0.2	OERI [25027] from concurrent startup / shutdown in RAC
4177651	10.2.0.1	Row migration within a MERGE may OERI[25027]
4020195	10.1.0.5, 10.2.0.1	OERI 25027 can occur in RAC accessing transported tablespace
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
3963135	10.1.0.5, 10.2.0.1	OERI[kcbgcur_3] / OERI:25027 during bitmap index updates
3829900	10.1.0.4, 10.2.0.1	OERI[25027] possible accessing index in 10g
2942185	9.2.0.6, 10.1.0.4, 10.2.0.1	Corruption occurs on direct path load into IOT with ADDED columns
3085057	10.1.0.2	ORA-600: [25027] from ALTER TABLE .. SHRINK SPACE CASCADE
2926182	9.2.0.5, 10.1.0.2	OERI[25027] / ORA-22922 accessing LOB columns in IOT in AFTER UPDATE trigger

【ORACLE数据库恢复】ORA-00600[KCLCHKBLK]
【Oracle数据恢复】ORA-00600[4000]错误解析
【Oracle数据恢复】ORA-00600[3020]错误解析
【Oracle数据恢复】ORA-00600[kdBlkCheckError]错误解析
【Oracle数据恢复】ORA-600 [kcbgcur_9]错误解析
【Oracle数据恢复】ORA-00600[2662]错误解析
【Oracle数据恢复】ORA-600[4511]错误解析
Oracle内部错误:ORA-00600[25012]一例
How to trigger ORA-00600,ORA-7445 by manual
Oracle内部错误:ORA-00600:[6033]一例

原文地址：【Oracle数据库恢复】ORA-00600[25027]错误解析, 感谢原作者分享。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

MySQL: String Data Types and ENUMs?May 13, 2025 am 12:05 AM

MySQloffersechar, Varchar, text, Anddenumforstringdata.usecharforfixed-Lengthstrings, VarcharerForvariable-Length, text forlarger text, AndenumforenforcingdataAntegritywithaetofvalues.

MySQL BLOB: how to optimize BLOBs requestsMay 13, 2025 am 12:03 AM

Optimizing MySQLBLOB requests can be done through the following strategies: 1. Reduce the frequency of BLOB query, use independent requests or delay loading; 2. Select the appropriate BLOB type (such as TINYBLOB); 3. Separate the BLOB data into separate tables; 4. Compress the BLOB data at the application layer; 5. Index the BLOB metadata. These methods can effectively improve performance by combining monitoring, caching and data sharding in actual applications.

Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AM

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AM

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AM

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks agoByDDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

How to fix KB5055612 fails to install in Windows 10?

3 weeks agoByDDD

Nordhold: Fusion System, Explained

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

WebStorm Mac version

Useful JavaScript development tools

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),