Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restore database only having DBF and CTL files [Windows] [11.2.0]

ZjelJul 1 2014 — edited Jul 1 2014

Hi all,

Got a bit of a situation here. A development database (11.2.0) on a Windows 2008 server went down yesterday.

Something went horribly wrong with with the hardware, so we can't boot the machine.

I removed the hard disk and attached it to another windows machine. I was lucky and could recover all the files on the disk.

Is there a way I can recover this database? I read some fora where people are telling you can simply re-create a new database, and then replace the DBF files.

Tried that, worked quite good, control files were attached. But when I tried to connect with any user, I got this beauty of an error:

ORA-12432: LBAC error: zllessesinit:OCIStmtExecute (yes that's English :-) ).

Does anyone has some tips on this? Doesn't have to be a fix for the error above. I just want to get that DB up and running on a VM so I can expdp some data out of it.

As you might have figured out, the original database wasn't shut down properly, since the entire machine just crashed. If I can't recover it all, that's not an issue.

I'm quite new to the DBA-part of Oracle, so sorry if this is a silly question.

If not clear and more info needed, shoot! ;-)

This post has been answered by Zjel on Jul 1 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2014
Added on Jul 1 2014
3 comments
636 views