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: Oracle recovery problem ???????????????????????????????????????????????????????????????????

Re: Oracle recovery problem ???????????????????????????????????????????????????????????????????

From: jojo <jojo_at_solitude.com>
Date: 1998/03/06
Message-ID: <35005530.555E@solitude.com>#1/1

John P. Higgins wrote:
>
> Your actual problem is that you restored the old *.ctl files !
>
> Oracle uses the *.ctl files to know wat SCN is current. The recovery
> (roll forward from the logs) ends when it reaches current.
>
> If you used the current *.ctl files, you would get what you wanted.
>
> The other method available uses the old *.ctl files, but you must inform
> Oracle that the *.ctl files are old:
>

  I concur with John... You have over written the SCN on the control file when you restored the old one . Received on Fri Mar 06 1998 - 00:00:00 CST

Original text of this message

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