| Corrupt Block [message #72630] |
Fri, 08 August 2003 09:50  |
Hail
Messages: 4
Registered: November 2002
|
Junior Member |
|
|
|
The server is a Dell Server, Windows 2000, SP3, Oracle 8.17. I export the database twice a day. Once a month I drop the data and re-import. The export & re-import are clean. Two hours later the backup routine runs. I have at least one corrupt block. The Event Viewer on the server is clean. Do I have a physical drive problem or a RAID Controller problem. How can I isolate the problem?
|
|
|
|
| Re: Corrupt Block [message #72643 is a reply to message #72630] |
Wed, 13 August 2003 12:57  |
Satish Shrikhande
Messages: 167
Registered: October 2001
|
Senior Member |
|
|
Check for the object which has corrupt block .
if it is a index drop and create it
enter your file and block number which is corrupt .
if it is a table then import it , drop it and export it .
SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = <AFN>
and <BL> between block_id AND block_id + blocks - 1
|
|
|
|
| Re: Corrupt Block [message #72652 is a reply to message #72643] |
Sun, 17 August 2003 10:48 |
Hail
Messages: 4
Registered: November 2002
|
Junior Member |
|
|
|
I know how to fix the problem. What I don't know is what's causing the problem. I ran Dell diagnostic tools over the weekend. The drives and controllers are healthy. Why would an export/import cause data corruption?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
