Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: can't restore/recover
Try
alter database open reset logs;
Shutdown immediate, copy, restore should works if you get all files; datafiles, controlfiles, redologs.
Success,
Johnny
Michael E. Moores wrote:
>
> i ran "shutdown immediate", then copied all files to another area. then i
> simply copied them back in. upon startup i got a message saying media
> recovery was required on system.dbf. I ran "recover datafile
> system.dbf". Then startup told me that another datafile needed recovery.
> SO i ran recover database, and it ran okay. then startup told me
> ORA-00322, log name of thread num is not current copy .
>
> can anyone help???
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Mon Dec 08 1997 - 00:00:00 CST