Test Oracle 11g data file recovery with AUL utility
I asked someone who have Oracle 11g beta version to send me a data file of Oracle 11g, and I got it this morning, great thanks to this unknown friend. Then I use AUL to test it, extract the zip file and create a AUL configuration file named "db.txt" as following.
1 1 users01.dbf
Then run the AUL and open it, check the data file header block with ORADUMP command. "ver=0x0b100000" means the data file is from Oracle 11g, "fmt=0xa2" means the block format is the same with oracle 10g's.
AUL> open db.txt
* ts# fno rfn ver bsize blocks filename
- ---- ---- ---- --- ----- ---------- -----------------------
Y 4 4 4 a2 8192 640 users01.dbf
AUL> oradump file 4 block 1
RDBA=0x01000001(4/1),type=0x0b,fmt=0xa2, seq=0x01, flag=0x04
DBID=0x44814ad1=1149323985, db=ORCL, ts#=4, ts=USERS, file#=4, blksiz=8192, blks=640, ver=0x0b100000, fzy=--O-
There is no system information of this data file, so try the method of non-system recovery. Run the "SCAN TABLE to scan_11g.txt" command, and then find the following command lines from the generated text file.
CMD:UNLOAD OBJECT 68415 CLUSTER 0 COLUMN NUMBER VARCHAR VARCHAR TO OBJD0000068415C000.txt;
CMD:UNLOAD OBJECT 68417 CLUSTER 0 COLUMN NUMBER VARCHAR VARCHAR NUMBER DATE NUMBER NUMBER NUMBER TO OBJD0000068417C000.txt;
CMD:UNLOAD OBJECT 68420 CLUSTER 0 COLUMN NUMBER NUMBER NUMBER TO OBJD0000068420C000.txt;
CMD:UNLOAD OBJECT 70052 CLUSTER 0 COLUMN NUMBER VARCHAR VARCHAR NUMBER DATE NUMBER NUMBER NUMBER TO OBJD0000070052C000.txt;
By carefully check, the guessed column type is completely correct, just run these command, you will see rows are recovered from Oracle 11g data file. But still need more test on Oracle 11g, then I will announce that AUL formally support Oracle 11g.
