| Corrupt block relative dba: 0x02400608 (file 9, block 1544) [message #146496] |
Thu, 10 November 2005 17:11  |
vsharmac
Messages: 16
Registered: July 2005
|
Junior Member |
|
|
Iam working on 9i database with forms 6i. The production database is up but while downloading
certain data it hangs.
I have got the following information from the alert log file
I have a corrupt data block in my database.
***
Corrupt block relative dba: 0x02400608 (file 9, block 1544)
Fractured block found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x02400608
last change scn: 0x0000.01345899 seq: 0x1 flg: 0x06
consistency value in tail: 0x30363636
check value in block header: 0xa7c, computed block checksum: 0x163e
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x02400608 (file 9, block 1544) found same corrupted data
Fri Oct 07 15:11:10 2005
Errors in file c:\oracle\admin\fdl2\udump\fdl2_ora_4028.trc:
Fri Oct 07 15:11:10 2005
Errors in file c:\oracle\admin\fdl2\udump\fdl2_ora_3772.trc:
Fri Oct 07 15:11:14 2005
Errors in file c:\oracle\admin\fdl2\udump\fdl2_ora_3904.trc:
Fri Oct 07 18:10:25 2005
Thread 1 advanced to log sequence 104
Current log# 1 seq# 104 mem# 0: D:\ORACLE\ORADATA\FDL2\REDO01.LOG
However i did these and got the name of the Tablespace name and Table name
wich is corrupt.(The file is 9 and block 1544)
select tablespace_name, segment_type, owner, segment_name from dba_extents
where file_id = 9
and 1544 between block_id and block_id + blocks - 1;
TABLESPACE_NAME SEGMENT_TYPE OWNER SEGMENT_NAME
USERS TABLE FDL ADDRESS
1 row selected.
SELECT owner, index_name, index_type
FROM dba_indexes
WHERE table_owner='FDL'
AND table_name='ADDRESS'
;
OWNER INDEX_NAME INDEX_TYPE
------------------------------ ------------------------------ ---------------------------
FDL ADDR_PK NORMAL
FDL IDX_ADDR_SPCE NORMAL
FDL IDX_ADDR_YP NORMAL
FDL IDX_ADDR_YP2 NORMAL
FDL ADDR_TYPE_IDX NORMAL
5 rows selected.
SELECT owner, constraint_name, constraint_type, table_name
FROM dba_constraints
WHERE owner='FDL'
AND table_name='ADDRESS'
AND constraint_type='P'
;
OWNER CONSTRAINT_NAME C TABLE_NAME
------------------------------ ------------------------------ - ------------------------------
FDL ADDR_PK P ADDRESS
1 row selected.
SELECT owner, constraint_name, constraint_type, table_name
FROM dba_constraints
WHERE r_owner='FDL'
AND r_constraint_name='ADDR_PK'
;
no rows selected
I have a understanding that the logical part is working properly but there is a problem
in the phyiscal component of the datafile
I want to create a new tablespace and move the table 'ADDRESS' which is located on 'USERS'(tablespace)
to the new tablespace.
How could i move these.Pliz give me the codes.Any other comments will be appreciated.
Thanks,
Vikash
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
other wise you will end up with crash database.