| Corrupted data block [message #62496] |
Sat, 24 July 2004 00:15  |
Jitendra Agrawal
Messages: 71
Registered: December 2003
|
Member |
|
|
Hi,
I am getting this error in alert file :
Completed: ALTER DATABASE OPEN
***
Corrupt block relative dba: 0x02400b72 (file 9, block 2930)
Fractured block found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x02400b72
last change scn: 0x0000.00ac705d seq: 0x1 flg: 0x06
consistency value in tail: 0x6e8f0601
check value in block header: 0x52be, computed block checksum: 0x1ed2
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x02400b72 (file 9, block 2930) found same corrupted data
------------
I also get following error in my application :
ORA-01578: ORACLE data block corrup
ted (file # 9, block # 2928)
ORA-01110: data file 9: '/home/oracle/product/9.0.1/oradata/stpora/stp_01.dbf'
------------
I have tried to find the table in this block.
SELECT segment_type, segment_name
FROM dba_extents
WHERE file_id = 1
AND block_id < 2928
AND block_id + blocks >= 2928;
SEGMENT_TYPE
------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
TABLE
CALL_HISTORY
Apprantley I can drop and recreate this table without harm. Will this solve my problem? or Do I have to recreate database and import the whole database?
Thanks in advance,
Jitendra Agrawal.
|
|
|
|
| Re: Corrupted data block [message #62502 is a reply to message #62496] |
Sun, 25 July 2004 12:11  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
If I were you, I would at least re-create the tablespace. You may want to try to export/backup the tables before doing anything drastic. Also, ask your O/S team to scan the disks for errors before using the same disks.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
