Re: Is it possible to add existing datafiles to an oracle database?
Date: Fri, 2 May 2008 13:49:53 +0800
Message-ID: <804dabb00805012249h7229957pc3a0002efb79060a@mail.gmail.com>
On 4/25/08, Srinivas Chintamani <srinivas.chintamani_at_gmail.com> wrote:
> Hi,
> 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 ....
>
> --
> Regards,
> 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:
http://www.ora600.nl/pricing.htm
Or a few others as listed here:
http://www.anysql.net/tools/eight_dul_like_tools.html:
- Bernard's Data UnLoader
- DUDE/jDUL
- AnySQL UnLoader (AUL)
- Oracle Salvage
- OracleRecovery
- Recovery for Oracle
- MyDUL
- CLOUT
-- Regards, Peter Teoh -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 02 2008 - 00:49:53 CDT