DBA Tools

Oracle ASM Data Recovery Test of AUL for Oracle ASM Utility.

    I create a tablespace based on an Oracle ASM disk group with two physical disks, and create a table with 499999 rows to make sure the data distributed on two disks evenly. SQL> select disk_number, name,path from v$asm_disk;...

Posted on April 20, 2011 8:57 PM

Change of the AUL license mode on Linux platform.

    AUL is a well known Oracle data recovery utility, it has helped lot's of customers to find their data back from corrupted Oracle database (file corrupted, system dropped, table truncated etc).     New AUL license is required...

Posted on April 20, 2011 8:43 PM

AUL for Oracle ASM, Oracle ASM Data Recovery Utility.

    I wrote a tool for Oracle ASM data recovery, for example, if we have an Oracle ASM with 10 disks in one disk group, and one of them corrupted, how to recover the data on other 9 disks?...

Posted on April 15, 2011 7:28 PM

Trigger based data replication utility from Oracle to MySQL database

    In some read focus system, we may make copies of the write database to take the heavy read activites, however how to make a read database if we plan to write on Oracle and read from MySQL database?...

Posted on April 10, 2011 12:27 PM

Migrate Oracle data to MySQL database with ora2mysql utility

    I wrote a program named (ora2mysql) when learning MySQL C API client programing, it can be used for data migration from Oracle to MySQL database, and I think it's definatelly a good utility for DBAs who need manages...

Posted on April 8, 2011 3:41 PM

Protect the database connection information in SQLULDR2

    Some departments need to extract rows from the production daily for busines analyze, so we decide to open the standby in read only mode for data extracting with database link. The database link can protect the database user...

Posted on June 11, 2009 8:58 PM

How to change SQLULDR2 session level's parameters?

    Somebody need to change the date type format (default, "yyyy-mm-dd hh24:mi:ss"), and change the numeric characters. For Oracle, you can run some "alter session set ..." commands to make the changes, so I add a new command line...

Posted on June 3, 2009 4:20 PM

Get more than expected from oramon performance alert.

    Now, we have more performance alert point than previously, we just had performance alert based on the load average and active sessions. I were wondering that we will receive too much performance alert and it may bother our...

Posted on May 26, 2009 1:49 PM

Send oracle performance alert based on oramon performance data

    For critical online transaction process database, it's very important to find out an effective way to monitor the database performance and alert the database performance problem. Because their are many concurrent sessions, any small problem can make the...

Posted on May 23, 2009 9:07 AM

Deploy the new oramon version to production database hosts.

    I was changing the code of oramon in recent few weeks, keeping on adding more useful performance data and removing useless performance data, it took me one month to finally release the new version of oramon, and deploy...

Posted on May 21, 2009 7:50 AM