Re: I/O error

 
TwoProc
Honored Contributor

Re: I/O error

See if your file is bad from a disk perspective...

dd \
if=/oradata/u005/ACCDW/ACCDW_gcldm_idx_04.dbf \
of=/dev/null bs=64K

(that's one command above).

If the above fails complaining about a read error - then its a disk error.

Otherwise you may have bad data in your database blocks. Have you any recent RMAN backups (hot or cold)? If you have bad data blocks it would probably have been detected in the backup.


We are the people our parents warned us about --Jimmy Buffett
Yogeeraj_1
Honored Contributor

Re: I/O error

hi,

Make sure your backups are all ok. You will have to recover your database. Hopefully, if you have your full backup and all the archived redologs you can get close to your last transactions...

good luck

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
shankar_3
Advisor

Re: I/O error

Hi Folks,

Thanks for valuable points ..

Customer did the hardware upgrade.

According to that swap increased.

Kernel reconfigured.

DB recreated..

Going well.

No hard disk problem found..

Bye
shankar_3
Advisor

Re: I/O error

I am closing my thread