HPE Community
Operating System - HP-UX
1753962 Members
7249 Online
108811 Solutions
New Discussion юеВ

Re: I/O error

 
TwoProc
Honored Contributor

тАО04-11-2005 03:28 AM

тАО04-11-2005 03:28 AM

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
0 Kudos
Yogeeraj_1
Honored Contributor

тАО04-11-2005 04:09 PM

тАО04-11-2005 04:09 PM

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)
0 Kudos
shankar_3
Advisor

тАО04-19-2005 04:05 AM

тАО04-19-2005 04:05 AM

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
0 Kudos
shankar_3
Advisor

тАО04-19-2005 04:06 AM

тАО04-19-2005 04:06 AM

Re: I/O error

I am closing my thread
0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.