Hello,
Database is 11.2.0.2.0 in Linux x86_64
sqlplus> startup
ORACLE instance started.
Total System Global Area 8551575552 bytes
Fixed Size 2243608 bytes
Variable Size 1459618792 bytes
Database Buffers 7079985152 bytes
Redo Buffers 9728000 bytes
Database mounted.
ORA-01115: IO error reading block from file 117 (block # 1)
ORA-01110: data file 117: '/db2/oradata/data/db7_perf/MF_AGING_RPT_2008_01.DBF'
ORA-27072: File I/O error
Linux-x86_64 Error: 5: Input/output error
Additional information: 4
Additional information: 1
Additional information: -1
Please note:
We don't have RMAN backup, it is a legacy database.
System administrator seems like has difficulty to get that file repaired from OS level.
By far, the solution seems like:
1. shutdown database
2. cp the corrupted file to a new location
3. start database mount
4. rename the file like "alter database rename file xxx to newnamexxx;"
5. recover datafile "newnamexx" ;
6. bring the new datafile online
but, as to step 2,
$ cp /db2/oradata/data/db7_perf/MF_AGING_RPT_2008_01.DBF /db3/oradata/data/db7_perf
cp: reading `/db2/oradata/data/db7_perf/MF_AGING_RPT_2008_01.DBF': Input/output error == > I stuck here!!!
By the way, I don't have rman backup and database in noarchivelog mode. so I don't think step 5 will work.
Any other solution? (for example, something like drop that datafile ... but it has data inside, can be dropped... how to make the database open with even something missing)
Thank you very much!!!