DBA Tools

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

Use MyLOG to fasten the recovery of drop operation

    I got some requests of data recovery by drop operation, including drop tables and drop tablespaces and drop schema. For this kind of recovery, the most complex step is to map the table with the data object id...

Posted on September 21, 2007 2:25 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

The dump format recovery of AUL (MyDUL)

    AUL (MyDUL) can recover the data to dump file by setting the output style, the character set and the national character set. As following, 871 is the UTF8 character set id. AUL> SET OUTPUT_STYLE DMP   Current OUTPUT_STYLE is...

Posted on September 16, 2007 8:52 AM

Step by step AUL/MyDUL data recovery example

    Download the binary and put it into a directory with enough free space to hold the recovered data, then prepare a text file (db10g.cfg) to tell AUL (MyDUL) where the data files is. As following. #  FILE#   RFILE# NAME...

Posted on September 15, 2007 2:52 PM

How to handle dead (corrupted) block in AUL (MyDUL)?

    In Oracle we know that it's possible to contain some corrupted blocks that cannot be read, We could use dbv or rman to check them. But in AUL/MyDUL, it's still possible to recover rows from these corrupted blocks,...

Posted on September 15, 2007 2:10 PM

The steps of register and apply AUL(MyDUL) license

    AUL(MyDUL) use a dynamic license model, every time you start AUL, you need register license to remove the demo limit (2 Files and 256MB only). By this way, you can perform the data recovery with my online support...

Posted on September 15, 2007 1:17 PM

What to do before you choose AUL(MyDUL) as recovery solution

    When you need Oracle database recovery, before you choosing AUL(MyDUL), please check the following. Because AUL(MyDUL) can only be the last method you should choose, and it's not free, you will be charged.     Do you have...

Posted on September 15, 2007 10:32 AM

Features overview of AUL(MyDUL) data recovery utility

    AUL (MyDUL) has recovered a lot of data for global customers. As it can read the rows out from data files without Oracle environment just as Oracle DUL can do, we can use it in the following case...

Posted on September 13, 2007 8:29 PM

AUL(MyDUL), an oracle database recovery utility.

    AUL(MyDUL) can read rows directly from Oracle data files without Oracle environment, so it can be used to perform recovery when you cannot open the database while you have no backup available. DBAs sometimes hit the following case...

Posted on September 7, 2007 10:56 PM