Home » RDBMS Server » Backup & Recovery » Recovering from different datafiles
Recovering from different datafiles [message #166424] Thu, 06 April 2006 04:42 Go to next message
RobyRob
Messages: 1
Registered: April 2006
Junior Member
We recently had a disaster scenario. Someone deleted the entire Oracle installation including the backup, all with Linux rm command.

We saved the files with some undelete utility (reiserfsck --rebuild-tree). Unfortunately some files are missing or are corrupt.

I have all the datafiles, but:
- some of them are 1 day old
- some of them are 2 days old
- two are even 1 month old (SYSTEM and UNDO; basically we have an entire valid backup from 1 month, but that's too old)

Is there any way to put these files together so Oracle will work?

Is there any tool (except Oracle's DUL) that can extract data from a dbf file into text, CSV, XML, SQL,... anything?

The data is extremely important so any help from you Oracle experts would be appreciated.

Thanks you very much in advance.

Report message to a moderator

Re: Recovering from different datafiles [message #166888 is a reply to message #166424] Mon, 10 April 2006 02:59 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
I think you cannot if you don't have archvied logs. There is a tiny hope to recover it even if you have archived logs.

But you'd better ask oracle for suggestions in this case.

I believe Oracle's DUL could do that.

Alex zeng | Skype me: hans9zeng

[Updated on: Mon, 10 April 2006 03:00]

Report message to a moderator

Previous Topic: Export and import with cluster information.
Next Topic: The problem of opening the database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 02:02:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.