Why AUL/MyDUL?
Oracle DUL is the last solution for recovery when no other method left, for example when no backup and system tablespace data file is corrupted. It's an Oracle internal use only utility which could direct read rows from data file without Oracle environment. However it's very hard to get a legal copy of this utility and you may not be able to afford the expencive cost of asking Oracle DUL recovery service. Then I decide to write a another tool to implement almost the same feature.
AUL/MyDUL is just a personal software wrote for fun. No gurantee of 100% correction in recovery, you can only ask for it when no official way to recover your database. DBA should not take this utility into account when thinking of backup & recovery strategy. Carefully design and test your backup strategy, if you hit any problem with your database, check whether you have backup first, then contact Oracle for official support, of cause, you could take a try on AUL/MyDUL finally.
Version
The latest version is 3.1.9, Download now.
Register Code: CDB9-A598-A744-7E3A
AUL : AnySQL UnLoader(MyDUL) for Oracle 8/8i/9i/10g, release 3.1.9
(C) Copyright Lou Fangxin 2005-2006 (AnySQL.net), all rights reserved.
AUL>
Features Supported
- Oracle 7 does not supported, 8/8i/9i/10g are supported.
- Table/Cluster/IOT are supported.
- Data type fully supported
- NUMBER
- DATE
- CHAR
- VARCHAR2
- RAW
- LONG
- LONG RAW
- BINARY_FLOAT
- BINARY_DOUBLE
- TIMESTAMP
- TIMESTAMP WITH TIME ZONE
- Data can be extracted to SQL Loader flat file, or Oracle 8.1.7 compatible DMP file, multiple dmp file not supported.
- Wrote in standard C language, currently only test compile on Windows (VC6), Linux (gcc), Solaris (gcc).
- Cross platform recovery support, for example: recover rows for Solaris data file under Windows XP.
- CLOB/BLOB partially supported, BFILE not supported.
- Inline LOB supported.
- Out line LOB can only read first 12 block, CHUNK size not supported.
- DISABLE STORAGE IN ROW LOB not supported
- LOB can be extract to flat file or seperate flat file or DMP format
- CLOB unicode can be converted to GBK/UTF8.
- 10g BIGFILE tablespace not supported.
Service & Licence
AUL/MyDUL is not sellable, I could provide recovery service for you.
The demo licence is free, but it can only open 4 files and can only read the first 512M of each openned file. If you want to remove the limit, you need to ask me for a valid licence code, the licence code can only be used once, every time you run AUL/MyDUL, it will generate a dynamic register code, licence code is calculated from the register code, so new licence code is required for every run. With the dynamic licence model, you could perform recovery locally without remote login requirement.
I have successfully provided service for customers from China, Germany, Hongkong etc. Data volumn varis from 1G to 70G.
What could be recovered?
1, Lost system tablespace.
2, System tablespace corrupted.
3, Tablespace dropped but data files still exist.
4, Table dropped is possible when no new object reuse the space of the dropped table.
5, Table truncated with reuse storage option.
6, Table truncated without reuse storage option is possible,when no new object reuse the space freed by the truncation.