Re: Oracle Recovery from directories

pdsgomes_at_gmail.com wrote:
> 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

How were the backups taken? With RMAN?

If you can log into your 9.2.0.1 I'd suggest the possibility of using transportable tablespaces.

-- 
Daniel Morgan
Puget Sound Oracle Users Group