Re: Urgent -Formated windows and need to restore

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 10 Aug 2005 17:55:11 +0200
Message-ID: <ddd810$eag$1@news.BelWue.DE>

Ach C via DBMonster.com wrote:
> Hi all,
> My windows has formatted and now I have only my oracle useless files.My last
> backup is about 1 week old so I want to restore datafiles without using that
> backup and just by datafiles and controlfiles and ...
> Do you know how is it possible? Can I install new oracle and create a
> tablespace with using old datafiles?
> PS: I was in archivedlog mode.
> -Thanks
>
>

If you have your oracle files, how can they be useless? If prior to the formatting you did a clean shutdown of the database and you have *all* pfile/spfile, controlfiles, datafiles, archived log and redolog files, you just reinstall windows, oracle and use oradim to recreate the service. But this will only work if you know what is needed at which stage, how oracle searches for pfile etc.

All this information can be found in the documentation and if you google around. But you have a backup, so use it. If you don't want to do that, I leave the above as a learning exercise to you.

Regards
Holger Received on Wed Aug 10 2005 - 10:55:11 CDT