Re: Is it possible to add existing datafiles to an oracle database?
Date: Fri, 2 May 2008 13:49:53 +0800
On 4/25/08, Srinivas Chintamani <srinivas.chintamani_at_gmail.com> wrote:
> I ended up with a crashed Oracle db, which refuses to start. I have all the
> datafiles for this database and was wondering if it is possible to somehow
> "Load / Import" the data in these datafiles into another working database.
> If yes, it will save me quite a lot of re-work. Can somebody help me on
> this please ....
> Srinivas Chintamani
As suggested by someone else on this list, Oracle has a tool called DUL, to extract the data from the datafiles without Oracle starting up. Alternatively, there are 3rd party tools like:
Or a few others as listed here:
- Bernard's Data UnLoader
- AnySQL UnLoader (AUL)
- Oracle Salvage
- Recovery for Oracle
-- Regards, Peter Teoh -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 02 2008 - 00:49:53 CDT