Re: Help ORA-1113 datafile needs media recovey

Without archivelog the only thing you can do is restore the backup, alter open resetlogs
and loose everything that happened after backup. All the options you describe would have been available if you would have ran in archivelog.

Sorry,

--
Sybrand Bakker, Oracle DBA
Peter Laursen < ptl_at_edbgruppen.dk> wrote in message news:01bf68d3$c3d3a980$2c289a0a_at_apollo...
> 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 - 09:16:09 CST