Help ORA-1113 datafile needs media recovey

Hi

System:
Oracle 8.0.5 on NT 4, not in archivelog mode, one instance on the box

Alert.log says Ora-1113 a file needs media recovery - the instance fails to come up. The services are running.

I have a total cold backup from last night, but i would prefer not to use it.

How do i identify which files are corrupt? How do i do the media recovery? What steps? Do I have to copy all files from the cold backup back and restart the the instance or can i make some recovery on a single corrupt file?

Thanks
Peter Laursen Received on Thu Jan 27 2000 - 08:51:49 CST