Re: Help ORA-1113 datafile needs media recovey

Peter Laursen escribió:
> Alert.log says Ora-1113 a file needs media recovery - the instance fail=
s to
> come up. The services are running.
> =

> I have a total cold backup from last night, but i would prefer not to u=
se
> it.

I'm afraid you'll have to user your cold backup. =

> How do i identify which files are corrupt?

Try:
 select name from v$datafile a, v$recover_file b    where a.file# = b.file#;
  =

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

 First of all, you need to work in archivelog mode. :-( Then, you must recover file from an old backup and with the archived redo=  logs
since your last backup.
Then in the server manager type:

recover datafile '<your file_name';

But this way won't work for you unless... Well, I'm not sure (may be some=  oracle
expert can advise us) but if you're lucky enough (very, very,... lucky) a= nd
there haven't been a lot of transactions may be the information needed to=

recover the datafile is still in the online redo logs (not overwritten) a= nd the
recover datafile will work for you. But it is a ver remote possibility (a= nd not
sure 100% it would work even thoug all information were in the online log= s).

Regards.
-- =

Julio Negueruela

'Hay algunas cosas que son tan serias =

que solo puedes bromear con ellas.' (Bohr) Received on Thu Jan 27 2000 - 09:41:12 CST