Database Administration (MOSC)

MOSC Banner

block corrupt question

edited Sep 30, 2009 9:53AM in Database Administration (MOSC) 5 commentsAnswered
our database 9205 , in windows 

1.block corrupt

file 21 block 63021
***
Corrupt block relative dba: 0x0540f62d (file 21, block 63021)
Fractured block found during preparing block for write
Data in bad block -
 type: 6 format: 2 rdba: 0x0540f62d
 last change scn: 0x0000.805b460b seq: 0x1 flg: 0x02
 consistency value in tail: 0x78070101
 check value in block header: 0x0, block checksum disabled
 spare1: 0x0, spare2: 0x0, spare3: 0x0
***


what happen?

our customer tried to update/delete a record (phonenumber=76) from t_customize  - every time oracle responses ORA-08102: index key not found, obj# 28919,
ORA-08102: index key not found, obj# 28919

so they use select * from t_customize wherer phonenumber=76, can fetch a row(result is 7'6 in phonenumber ,seem data storage is a bad data.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center