DBA Tools |
|
Good tools make the work easy and improve life quality. |
|
Tips: Add to Google | Oracle DUL? | AUL License | AnySQL.net | asyncdata | ociuldr
Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin
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...
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...
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...
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$"...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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....
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: ...
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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...
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...
Personal Information
| Name | Fangxin Lou |
| Job | Oracle DBA |
| Loc | Shanghai China (+08:00) |
| Skype | anysql |
| MSN | anysql©live.com |
| AIM | loufangxin |
| anysql©126.com anysql©yahoo.com |