Oracle Recovery from directories

From: <pdsgomes_at_gmail.com>
Date: 2 Oct 2006 03:13:45 -0700
Message-ID: <1159784025.877944.181910@h48g2000cwc.googlegroups.com>

Hi All,

First, i say sorry for my poor english, imfrom portugal :)

Well my problem is that i was running SuSE Linux 8.0 with Oracle 9.2.0.1, and sudenly, because of the electricity, the system disk crashed up and now, i just have the secondary disk, this one healthy, with the oracle directories and the entire database.

At present i have a new machine with SuSE 9.1 and Oracle 9.2.0.4 installed, and the question is. how can i recover the database that is on directories into the new server with a new Oracle version.

I just what to recover a user from the old database, and its very important for me, normaly my backups were simple (ex. exp xxx/xxx_at_orcl1 file=xxx.dmp owner=xxx) i i had my backup done, but it passes 3 months that i was not making backups, now the only way is to recover that user from the directories.

I apreciated every help that u guys can get me.

Thanks a let Received on Mon Oct 02 2006 - 05:13:45 CDT