Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import oradata files
Giulio Ferro wrote:
> An old 8.1 server crashed and no backup was avaialble.
> I managed to salvage from the hard disk the oracle directories,
> and specifically the oradata directory. Since I had to set up an
> other server I tried to install oracle 8.1 in a new machine and
> import the old data.
>
> In order to do this I created a database with the assistant which had
> the same name of the old database, then I copied the files in the old
> oradata into the new oradata.
>
> It didn't work. I tried to run the migration utility but it complained
> about different version of control files, and when I tried to open it
> I couldn't.
You can't just copy the files over and expect it to work. You have a salvage job in front of you and it's not going to be easy. I'd suggest stopping right where you are and enlisting seasoned professional help. You *may* be able to salvage your data. But the more you fiddle with it, the more likely you'll dig yourself in deeper.
> Can someone please tell me what I did wrong
You said it yourself: "server crashed and no backup was avaialble"
> what is the correct procedure to do this?
Make regular backups.
BTW, the proceedure you're describing is Restore/Recover, which is different than import. If you have a valid export file lying around (look for a largish file with a name something like "exp.dmp") you can use the import tool to put that data into your newly created database.
//Walt Received on Tue Feb 07 2006 - 14:43:18 CST