Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bad corrupted block

Status
Not open for further replies.

1018DADA

IS-IT--Management
Sep 20, 2005
42
US
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 ?
 
Dada,

Please tell us more about your situation:

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?

Looking forward to your responses.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[ Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.
 
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)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top