Re: Missing datafiles

Hi Pat,
Yeah that's exactly what I have done in other situations. I am definitely going to try it.

I will post the result regardless of the outcome.

Cheers,
Kanwar

On Fri, 29 Jun 2007 08:11:41 am Elliott, Patrick wrote:
>
> I am skeptical if you will be able to apply any redo log information
> after the resetlogs command that you had to issue to get the database
> up. The SCN numbers on the online data files will be higher than the
> SCN's in the old ones, also.
>
> You might be able to get it to work by recreating the controlfile and
> then issuing the "recover database until cancel using backup
> controlfile" command.
> When it prompts for log files, go ahead and give it a full path name to
> the current online redo logs one at a time. Be sure to put the missing
> data files in the exact same positions that they were before in the
> create controlfile statement. Don't just add them to the end.
>
> Be sure and save the current controlfiles just to be safe in case it
> doesn't work.
>
>
> Pat
>

--
http://www.freelists.org/webpage/oracle-l