Re: Missing datafiles

  • From: Kanwar Plaha <kanwar.plaha@xxxxxx>
  • To: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
  • Date: Fri, 29 Jun 2007 08:18:10 +1000

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


Other related posts: