LOB Segment Corruption. ROWID found. Further help is required
Hi All,
Block corruption in LOB Segment is found in our system. ORA-1578 was reported without ORA-26040. I am managed to get ROWID and Primary Key of the corrupted segment. I have same non-corrupted image saved in another database, but it is 10gR2 and storage architecture is entirely different. I want to remove block corruption and then insert non-corrupted image in this column from 10gR2 database. I want to get help regarding sequence of steps so that job can be done further, how can I move the LOB Segment to new partition with following structure.?
Database: Oracle 11.2.0.3.0
OS: RHEL 5.3
Table where corruption occurred contains 43 million images (BLOB store as BasicFile), Hash Partitioned and tablespace is BigFile 8K Blocksize.
Block corruption in LOB Segment is found in our system. ORA-1578 was reported without ORA-26040. I am managed to get ROWID and Primary Key of the corrupted segment. I have same non-corrupted image saved in another database, but it is 10gR2 and storage architecture is entirely different. I want to remove block corruption and then insert non-corrupted image in this column from 10gR2 database. I want to get help regarding sequence of steps so that job can be done further, how can I move the LOB Segment to new partition with following structure.?
Database: Oracle 11.2.0.3.0
OS: RHEL 5.3
Table where corruption occurred contains 43 million images (BLOB store as BasicFile), Hash Partitioned and tablespace is BigFile 8K Blocksize.
0