Home » RDBMS Server » Backup & Recovery » Restore from control files (Oracle 11G r2)
Restore from control files [message #543267] Mon, 13 February 2012 19:18 Go to next message
Supial
Messages: 2
Registered: February 2012
Location: Canada
Junior Member
Greetings,
I had a database on an old P4 running but the motherboard got fried. I was able to recover all the data files (.ctl and *.dbf) plus the redo logs (.log). There is no export or backup taken - I have old ones, but I need to recover the latest which only existed in the data files.

I now have Oracle installed on a new P5 machine and was wondering if it is possible to use these data files in the new database? If so, how do I go by restoring the data files?

Both the P4 and P5 where running Red Hat Linux.

Thanks,
Marcel
Re: Restore from control files [message #543268 is a reply to message #543267] Mon, 13 February 2012 19:29 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

The new system needs the EXACT same version (to 4 decimal places) of Oracle software installed on it as the old system
Re: Restore from control files [message #543269 is a reply to message #543268] Mon, 13 February 2012 19:43 Go to previous messageGo to next message
Supial
Messages: 2
Registered: February 2012
Location: Canada
Junior Member
My appologies for not including the version.
I'm using 11.2.0.1.

You should also note that on the P4, is was x86 and now on the P5 it's 64bit.

Cheers!
Re: Restore from control files [message #543270 is a reply to message #543269] Mon, 13 February 2012 19:49 Go to previous message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
If EVERYTHING on the new system is 100% identical to the old system,
all you need to is STARTUP the database as it existed on the old system;
because the files will not know or care that they now reside on new hardware.

[Updated on: Mon, 13 February 2012 19:53]

Report message to a moderator

Previous Topic: Archivelog backup
Next Topic: why the table does not exists?
Goto Forum:
  


Current Time: Tue Oct 23 03:29:30 CDT 2018