DBA Tools

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

When lossing one of the data files for a tablespace

    I saw two case recently about losing one of the data files for a tablespace, first case was losing a data file totally, second case is one of the data files has no recent backup, so it's equal...

Posted on October 25, 2007 2:18 PM

The Oracle data recovery without system is really complex.

    A few databases got corrupted recently. Such as, disk holding the system tablespace data files got crashed, tables got dropped by mistakes, schema got dropped by mistakes, tablespace got dropped by mistakes (data files still exist). These are...

Posted on October 19, 2007 11:18 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

Fastest Oracle data recovery service by AUL/MyDUL utility

    I provided an Oracle data recovery service for a US company, it took just one and half hours to get 8GB data recovered, from get in touch with me through MSN to finish the data recovery. Before they...

Posted on October 16, 2007 10:39 AM

Cost saving in wrong place

    Someone got their database lost today. A decision support system (DSS) database, 200GB size, running in noarchive log mode, and no backup available. One of the hard disk got corrupted, after got the data files back with disk...

Posted on October 11, 2007 7:43 PM

Implement materialized view log on MySQL for asyncdata

    Of cause, MySQL does not have materialized view log now as Oracle has. But we can implement the same feature with a log table and a trigger, since MySQL version 5 does support the trigger. In MySQL we...

Posted on September 11, 2007 5:30 PM

Using trigger for asyncdata log table in Oracle database

    Oracle materialized view log is good for capture the DML change, however it's not flexible, for example, the table must have a physical primary key defined for asyncdata, and you have no wait to skip the change capture...

Posted on September 11, 2007 12:15 PM

Tuning the performance of data replication with asyncdata

    Performance is critical for OLTP system, asyncdata should have good performance for the data replication, else it may not be able to catch up with the source table. Following is the key points to get the best performance....

Posted on September 10, 2007 10:53 PM

Migrate data between different databases with asyncdata script

    Migrate data may be a regular job for a DBA, sometime from this Oracle server to another Oracle server, and sometime migrate from Oracle to MySQL or other database, or other database to Oracle. With good utility it...

Posted on September 10, 2007 8:55 PM

Data compare tool needed, compare rows between tables.

    Sometimes we need to compare rows for two tables. I have saw many times people were asking this kind of tools, I want such a tool too. I did put some time in designing such a tool, but...

Posted on September 7, 2007 11:23 PM