Hard Disk has bad block.

[Former Member]

Hi Experts,

I have seen the bad block error entry in event viewer on Server.

Server configuration as follows...

Windows server 2008 R2.

ECC 6.0

IBM DB2 9.7

Its a development system.

We have faced same issue on same server 4 months ago, that time I have recovered that bad sector via CHKDSK /f /r command and then after that recover the database, so after that there is no any error entry in event viewer about bad block and etc.

But today again same error occurs, please suggest me how should I proceed now?

Regards,

Sahani.

[Former Member]

Dear experts,

Any suggestions.....

Regards.

Sahani.

[Sriram2009]

Hi Amit

1. Are you using the SAN Storage?

2. If possible to bring same amount of Disk space, which you are having bad block disk?

3. Could you share the details about you disk space & free space?

Regards

Sriram

[Former Member]

Hi Sriram,

1. No we are not using SAN storage.

2. Sure I will bring same amount of DISK which is same as old one but Can we restore the database on another server which have different SAP SID and DB SID ?

3. 45% space is free on current working HDD.

Regards.

Sahani.

[Sriram2009]

Hi

Kindly follow the steps

1. Start with full system backup

2. Create the same amount of disk space on same server.

  2.1 Do the Disk mirroring from the bad block to new disk once the disk are sync

  2.2  Remove the disk mirroring 

3. Remove the bad block disk

Regards

Sriram

[former_member188883]

Hi Amit,

Do you have Disk RAID configuration done ? If yes , replace the faulty disk with new one.

RAID configuration will take care of synchronization of data across disks

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Deepak,

Thanks for your inputs.

No we dont have configured the RAID.

[Former Member]

Hi Amit,

try to run CHKDSK again and see if it resolve the issue. Check for software which can remove / repair bad sectors.

Regards,
Deepanshu sharma    

[Former Member]

Hi Deepanshu,

Sure I will try to run the chkdsk and the process which I have performed 4 months before.

But I am thinking about what if same error occurs again after few days.

So What precautions should I take, because we have not configured the RAID, We have recent backups, but what if disk fail in future.

Please guide me.

Regards.

Sahani.

[Former Member]

Hi Amit,

There are different solution for your query.

1. RUN checkdsk and see if it resolves the issue continue with current server.

2. Take a backup and and perform restore on another server.

3. Try changing the disk if you can with help of server team.

4. Try to perform migration to a new server and see.

I'm assuming you should / would be taking backup everyday / week which should give a hope to restore in case of failure.

Perform the restore process a dry run kind of thing.

Hope it gives you some options.

Regards,

Deepanshu Sharma

[Former Member]

Dear Deepanshu,

Thanks for your suggestions.

1. Sure.

2. Can we restore the database on another server which have different SAP SID and DB SID ?

3. Suppose I have to replace the old hard disk with new one, so what steps i have to do?

I mean firstly I have to install the EHP5 ECC 6.0 same as my previous server versions i.e. patch level, sap SID, Database version and patches, DB SID, and after that restore the database with the help of backup file of previous server. is it so?

Yes we are taking backup on weekly basis for Development server.

Regards.

Sahani.