Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: can't restore/recover

Re: HELP: can't restore/recover

From: Johnny Verhoeven <Johnny.Verhoeven_at_club.innet.be>
Date: 1997/12/08
Message-ID: <348B2F8F.53BC@club.innet.be>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US