Aul Recovering truncate deleted tables

Background

Received the user declaration, the new brother accidentally put the database of the 3 key tables to truncate, because this business is still in the testing phase, the system does not have any form of backup.

The customer's OS platform is the Windows platform and the database is Oracle9207

In this case, an attempt was made to use aul to recover. This explains the recovery of one of the tables (XM_FXL)

Pre-recovery Preparation a

1. Download the Aul software to www.anysql.net. If the data file is less than 512M, the software is free to use

2. Control files: Control files like Aul and Dul, it is necessary to have a control file (Orcl.dul) to tell it where the files need to be recovered and whether there is a system file. Because the original database is running normally (OPEN), it is easy to query the table space number and relative file number where the TRUNCATE table is located, and the position is the new position copied out.

Orcl.dul

0 1 D:\boypoo\system01.dbf 10 10 D:\boypoo\infdata01.dbf

Pre-Recovery Preparation II

The rest is inside the Boypoo blog. Too lazy to turn.

Http://www.loveunix.cn/html/32/1132-13480.html

Transfer from http://www.loveunix.net/viewthread.php?tid=84043

Source: Http://blog.163.com/card_2005/blog/static/11781036820091066936400/

Aul Recover truncate deleted tables