Re: Restore Oracle Datafile

You might be able to restore if you 1) know the physical structure of your database and 2) have another database to create a control on. Go to your second database, a system that you can bring up. From there, issue the command "ALTER DATABASE BACKUP CONTROL FILE TO TRACE". This will produce a trace file in the USER_DUMP_DEST. You can use this trace file as a template. The trace file has the physical structure information of that database that is running. Edit the trace file with the physical information of the database that you are trying to recover. When that is done, you can run the script you've created with this edited trace file. That should rebuild your control file and from there you may be able to recover.

HTH,
Brian

mark_rupert_at_protelinc.com wrote:
>
> Is there a way to restore an Oracle datafile without the control
> files? I have a Personal Oracle database on a system that went belly
> up. I was able to backup the datafile only and would like to put that
> on a system that I have reinstalled the Operating System and Oracle
> on. We have been trying to use the restore command but as of yet have
> not had success.
>
> Is this possible?
>
> Mark A. Rupert
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================