DBA Tools

Fixed AUL license is available now for you

    It has been 5 years since I released the first version of AUL utility, and I have helped lots of customers to get their data back from corrupted database, such as lost system tablespace, table dropped or truncated....

Posted on January 27, 2010 1:21 PM

Save the customer's data, resue the world.

    It has been four years since AUL help it's first customer from Hongkong to get the data back. In the last four years, AUL does help a lot of custoemrs in disaster data recovery situation without valid backup....

Posted on April 29, 2009 10:14 AM

AUL/MyDUL vs. Oracle DUL, which is better?

    This year I got few cases that Oracle DUL cannot recover the data well for you, while AUL/MyDUL can do it well. In the following cases, you should choose AUL/MyDUL as the recovery tool.     CLOB data...

Posted on October 4, 2008 9:00 AM

Recover the table's index structure information.

    AUL just focus on the data recovery, it does not generate the SQL of creating the indexes, but we can recover them. Just recover some kernel table's data and load them into new database, then run query to...

Posted on March 20, 2008 2:42 PM

Recover the Oracle stored procedures' source code.

    AUL just focus on the data recovery, it does not generate the source code of the stored procedures, but we can recover them. Just recover some kernel table's data and load them into new database, then run query...

Posted on March 20, 2008 2:34 PM

How many lines in AUL/MyDUL's source code?

    I have been writing and maintaining AUL/MyDUL software for three years. Just wondering how much lines of C code I have wrote and did a count, strangely there are less lines than I have expected (10000 lines).  ...

Posted on November 20, 2007 6:54 PM

AUL/MyDUL data recovery service models

    I provide Oracle data recovery service by internet. When I say data recovery, always means cases without valid backup available, and have to use AUL/MyDUL to read data directly from existing data files. There are four types of...

Posted on November 19, 2007 9:09 PM

More robust DMP format support in AUL version 5

    I rewrote severl key functions in AUL to add the compress table support, but I found that the DMP format support is more robust in AUL 5. When I use the latest AUL 4 to unload table "SYS.IND$"...

Posted on November 8, 2007 7:38 PM

AUL 5 Beta version launched, all features under testing.

    Oracle compress can save a lot of storage for us, so I believe that more and more companys will start to use it. I spent few days free time on it, and add the compress feature support in...

Posted on November 2, 2007 5:58 PM

Source code of Oracle AUL/MyDUL, wroten in Java, but not jDUL copy

    Few days ago, somebody (they wrote a MYjDUL utility) post a message on a public forum said that AUL/MyDUL is copied from jDUL open source project. This is not true, when I started to write AUL/MyDUL utility in...

Posted on October 31, 2007 5:48 PM

Using AUL/MyDUL in a 2TB Oracle database recovery

    Someone got a 2TB Oracle database corrupted due to some trouble (few corrupted blocks) in the system tablespace. It's a data warehouse database, so running in no archive log mode, and the last backup was taken one months...

Posted on October 18, 2007 12:18 AM

The payment of AUL Oracle data recovery service.

    I provide Oracle data recovery service for you, it's not free, so you will be charged, we need get an agreement on the charge first. How much you will be charged? I am not selling a product or...

Posted on October 11, 2007 5:57 PM

How AUL support the partition table's CLOB/BLOB recovery?

    When you prepare to do recovery of partitioned table with LOB columns with AUL4, you must modify the LOB index's partition name first in "AULOBJ.TXT". I have thought that the LOB index have the same partition name with...

Posted on October 11, 2007 5:17 PM

How AUL support different Oracle CLOB/BLOB chunk size?

    All the blocks of a chunk must be continual with a single extent, because you cannot specify a chunk size larger than the next extent size. Based on this rule, I add different chunk size support to AUL...

Posted on October 11, 2007 5:13 PM

How much files can be stored in one directory?

    How many files can be stored in on directory? I don't know the answer. But when one directory have a lot of files, it will be very hard to operate, and may slow down the file access speed....

Posted on October 10, 2007 3:08 PM

Some LOB recovery related options in AUL/MyDUL utility.

    AUL version 4 support LOB data type, including inline LOB, in row LOB and out of row LOB. I need to introduce few new options of AUL, the following two are only related to CLOB data type:  ...

Posted on October 10, 2007 3:04 PM

How to recover Oracle data when losting system tablespace?

    All the table structure informations are stored in system tablespace, in the user data tablespace, there are only a data object id and the rows you wanted. So we could scan all the data files and recover all...

Posted on October 9, 2007 7:57 PM

Write Windows batch script to load the data for AUL (MyDUL)

    When recovery with AUL (MyDUL) in text mode (default mode), it will generate three files for each table (Recovery Example), then we need to execute the SQL file to create the table, and then load the data by...

Posted on September 19, 2007 7:17 PM

How AUL (MyDUL) recover truncated table's data easily?

    I have seems somebody truncated their tables by mistaken several times, because of they connect to wrong database and run the script without careful check. To save data, the first thing they need to do is stop the...

Posted on September 17, 2007 9:37 PM

Set the different options value for AUL (MyDUL) utility

    To correctly unload data, you need to tell AUL some option values by the "SET" command. Currently 12 options are available. Some are used to tell AUL the datafile format, some to set the output file format, and...

Posted on September 17, 2007 9:13 PM