Unanswered: ORA-01113: file 8 needs media recovery
in our oracle server there is 2 harddisk.second hard disk include dbf file and we copied these files to another(third) harddisk because sometimes we take harddisk error but we didnt backup database.and last, hard disk crashed ,now we use other hdd(third) instead of second hdd.but when i start service from command prompt i take an error like
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORACLE\ORADATA\TESTDB\ABOD01.DBF'
previous path and new path is same and file (ABOD01.DBF) on this path.
i began to work oracle for two weeks,how can i solve this problem,
I hope you are working in archivelog mode.
Connect to oracle as sysdba and enter:
select log_mode from v$database;
if you get ARCHIVELOG as result continue with the next line.
alter database recover automatic database;
if you are not in archivelogmode it could be a little bit more difficult and you may have loose some of your data.