OraFAQ Forum: Backup & Recovery » Restore from control files

Home » RDBMS Server » Backup & Recovery » Restore from control files (Oracle 11G r2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restore from control files [message #543267]

Mon, 13 February 2012 19:18

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

Report message to a moderator

Re: Restore from control files [message #543268 is a reply to message #543267]

Mon, 13 February 2012 19:29

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Restore from control files [message #543269 is a reply to message #543268]

Mon, 13 February 2012 19:43

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!

Report message to a moderator

Re: Restore from control files [message #543270 is a reply to message #543269]

Mon, 13 February 2012 19:49

BlackSwan
Messages: 26766
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 06:17:54 CDT 2025