DBA Tools

Oracle and ASM Storage Data Recovery Tools

    AUL/MyDUL is an alternative of Oracle DUL, which can read rows directly from data file without Oracle instance. If you cannot start the Oracle database and have no valid backup to restore, for example, lost system tablespace data files, table dropped or truncated, some data files corrupted. You can choose AUL (Feature Overview) as the final solution with much lower cost compare to Oracle DUL service. It has recovered more than 2TB data and more than 30 customers from different countries.

    You can download and test it (Step by Step) with the free demo license(Fixed license available for Windows platform only) before you make the decision. You can recover the data from a truncated table or database lossing system. In some cases, AUL/MyDUL is stronger than Oracle DUL, you should always keep another eye on AUL. The most important thing is that we have faster response time than service from Oracle or other companies.

    AUL (MyDUL) 6 can direct access data files on ASM, if you have problem to mount ASM disk group up, you can try AUL 6 to read the Oracle data file out to operating system file systems in emergency case, and them try to open the Oracle database.

    Anyway, if you have problems when your Oracle database recovery, please contact me by MSN (anysql@live.com) for real time communication with english.

Create Different Business Chart (Pie, Bar, Line, etc) Pages.

    WebChart can help you to show data in simple web pages or different business charts (pie chart, line chart, bar chart, area chart etc), and download the data to an excel (Office 2003) file for further analyze. You just need to install and configure the database connection on the application server (Tomcat, Resin etc), no client installation is required, then everyone can start analyzing data with it. With Java JDBC it can display data from many different types of database system, such as Oracle, MySQL, etc. I have deployed WebChart into the business monitor system, and it works fine. For business data security, WebChart also have it's own security framework to control the access of every pages, all passwords in the configuration files must be encrypted for high security. You can quickly create navigation links between pages.

    WebChart is a free utility, you will not be charged for both personal usage and comercial usage, but if you need techniqual support from me, you will be charged for the support service.

Recent 12 posts of this blog

• Oracle ASM Data Recovery Test of AUL for Oracle ASM Utility.  -  Apr 20, 2011
• Change of the AUL license mode on Linux platform.  -  Apr 20, 2011
• AUL for Oracle ASM, Oracle ASM Data Recovery Utility.  -  Apr 15, 2011
• Trigger based data replication utility from Oracle to MySQL database  -  Apr 10, 2011
• Migrate Oracle data to MySQL database with ora2mysql utility  -  Apr 8, 2011
• Windows GUI version of SQLULDR2 and DataCopy released.  -  May 13, 2010
• SQLULDR2 : Native Parallel Support! Parallel Inside!  -  Apr 30, 2010
• SQLULDR2 Windows Developer SDK Released.  -  Apr 19, 2010
• DataCopy : Native Parallel Support Now ! Parallel Inside !  -  Apr 17, 2010
• Parallel execution of SQLULDR2 or DataCopy for huge tables  -  Apr 15, 2010
• Data Migration between different Oracle character set  -  Apr 14, 2010
• DataSync: Data Replication (SCOTT.EMP) between Oracle databases  -  Mar 25, 2010

Oracle Text Unload & Data Migration Tools

    Pure text file is an important way of data exchange, however Oracle does not provide it for us, we have to write our own, ociuldr is one of them wroten in high performance OCI interface. It's free (Download) and you can get the source code to compile it on any OS platform.

    It has a lot of command line options to tune the unload job, and generate the sqlldr control file for data loading & migration. With detailed exit code, you can embed it in your script well.

    sqluldr2 is the enterprise text unload utility, it's 50% faster than ociuldr by the IO tuning, and some new features. You can download the windows binary for testing, with almost the same command line options as ociuldr.

    Download the detailed document and start to use it!

Oracle Performance Monitor Tools

    Many people don't know how to do performance tuning, just because they don't know where is the problem. So we need an Oracle tool to record some performance data of the database, oramon is one of it. It get performance data from "V$SYSSTAT", "V$SESSION" etc, by comparing the same data (consistent gets, physical read, active sessions etc) of different time, you can easily get to know where is the problem.

    You can download and try it freely if you have no idea of performance tuning, I could provide support service based on it, by giving me the data gathered and making suggestions after analyzing the data.

Other Database Tools

    AnySQL is a Java & JDBC based database interactive utility, you can run SQLs or DMLs on it. It intergreted a lot of customized SQL commands and some special features.

    asyncdata is a Perl script to replicate changed data (capture by triggers) between different databases, not limited to the same type of DBMS, such as Oracle replicate to Microsoft SQL Server.

    Compare Any Column is a Perl script to compare tables and indexes structure between multiple Oracle databases, if you split your database horizontally like eBay, you may need it.

    ocidiff is an OCI program to compare objects structure between two Oracle schemas, and synchronize them automatically. If you have a lot of QA databases, and want to keep tables structure the same with a core database, you should choose it.

    lobs is an OCI program to unload LOB values to OS files or upload OS files to LOB values in Oracle.

    dmp2utf8 is a C program to change the character id in Oracle dump file created by exp utility.