Oracle utilities reporting bad block (corrupted block)on the Disk, i cannot find any errors related to that or other in Windows 2000 server inviroment, the server is P-DL380, Raid 5.
Oracle 8.
any suggestions ?
What fall-back contingencies do you have? Are your data backed up either with exports or with database backups?
Is your database in ARCHIVELOG mode?
How important are the data that reside in the object with the corrupted block?...If the data are lost, can someone easily recreate/re-enter the data?
How much data (rows/volume) will be lost if you cannot recover the data?
Does the error message tell you what block number is corrupted? Can you access rows that are physically prior to the corrupted block? How many rows are prior to the corruption? How many rows total reside in the file?
Not a oracle admin myself, i have forwarded the question to the team, from what i do know, the oracle is saying the write failure to the disk\hardware might have caused bad block
( Raid or data correption-dont know)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.