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 > -- //www.freelists.org/webpage/oracle-l