文件系统是ext3,操作系统是rhel5.5
数据库正常关闭后，oradata/orcl104/*被全部删除，未做任何动作，然后卸载了文件系统。

[root@db9 ~]# df -h
FilesystemSizeUsed Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
38G32G4.0G90% /
/dev/sda199M13M82M14% /boot
tmpfs2.2G02.2G0% /dev/shm

使用工具恢复数据文件

[root@db9 ~]# extundelete /dev/sdf1 --restore-all
Loading filesystem metadata ... 80 groups loaded.
Loading journal descriptors ... 358 descriptors loaded.
Writing output to directory RECOVERED_FILES/
Searching for recoverable inodes in directory / ...
13 recoverable inodes found.
Looking through the directory structure for deleted files ...
Restored inode 49153 to file RECOVERED_FILES/control01.ctl
Restored inode 49154 to file RECOVERED_FILES/control02.ctl
Restored inode 49155 to file RECOVERED_FILES/control03.ctl
Restored inode 49156 to file RECOVERED_FILES/mytbs1.dbf.2
Restored inode 49157 to file RECOVERED_FILES/redo01.log
Restored inode 49158 to file RECOVERED_FILES/redo02.log
Restored inode 49159 to file RECOVERED_FILES/redo03.log
Restored inode 49160 to file RECOVERED_FILES/sysaux01.dbf
Restored inode 49161 to file RECOVERED_FILES/system01.dbf
Restored inode 49162 to file RECOVERED_FILES/temp01.dbf
Restored inode 49163 to file RECOVERED_FILES/undotbs01.dbf
Restored inode 49164 to file RECOVERED_FILES/users01.dbf
Restored inode 49165 to file RECOVERED_FILES/mydbs1_01.dbf
0 recoverable inodes still lost.
[root@db9 ~]#
[root@db9 orcl104]# ll
total 1136052
-rw-r--r-- 1 oracle dba7061504 Sep6 20:31 control01.ctl
-rw-r--r-- 1 oracle dba7061504 Sep6 20:31 control02.ctl
-rw-r--r-- 1 oracle dba7061504 Sep6 20:31 control03.ctl
-rw-r--r-- 1 oracle dba 104865792 Sep6 20:31 mydbs1_01.dbf
-rw-r--r-- 1 oracle dba20979712 Sep6 20:31 mytbs1.dbf.2
-rw-r--r-- 1 oracle dba52429312 Sep6 20:31 redo01.log
-rw-r--r-- 1 oracle dba52429312 Sep6 20:31 redo02.log
-rw-r--r-- 1 oracle dba52429312 Sep6 20:31 redo03.log
-rw-r--r-- 1 oracle dba 272637952 Sep6 20:31 sysaux01.dbf
-rw-r--r-- 1 oracle dba 503324672 Sep6 20:31 system01.dbf
-rw-r--r-- 1 oracle dba20979712 Sep6 20:31 temp01.dbf
-rw-r--r-- 1 oracle dba73408512 Sep6 20:31 undotbs01.dbf
-rw-r--r-- 1 oracle dba7872512 Sep6 20:31 users01.dbf
复制到数据文件夹下，可正常打开数据库
[oracle@db9 ~]$ sqlplus/ as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on20:33:13 2012
Copyright (c) 1982, 2006, Oracle.All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area897581056 bytes
Fixed Size2076848 bytes
Variable Size239079248 bytes
Database Buffers650117120 bytes
Redo Buffers6307840 bytes
Database mounted.
Database opened.

同样测试2如下：
在数据库打开的时候，有事务运行的情况下，删除undotbs1表空间，然后实例报错

Thu Sep6 21:58:23 2012
Errors in file /u01/app/oracle/admin/orcl104/bdump/orcl104_smon_28552.trc:
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl104/undotbs01.dbf'
Thu Sep6 21:58:24 2012
Errors in file /u01/app/oracle/admin/orcl104/bdump/orcl104_smon_28552.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl104/undotbs01.dbf'
通过lsof也无法找到文件，故只有杀掉smon进程。然后恢复了undo数据文件
[root@db9 ~]# extundelete /dev/sdf1 --restore-all
Loading filesystem metadata ... 80 groups loaded.
Loading journal descriptors ... 1826 descriptors loaded.
Writing output to directory RECOVERED_FILES/
Searching for recoverable inodes in directory / ...
15 recoverable inodes found.
Looking through the directory structure for deleted files ...
Restored inode 19 to file RECOVERED_FILES/undotbs01.dbf
Restored inode 49164 to file RECOVERED_FILES/undotbs01.dbf.v1
Restored inode 49165 to file RECOVERED_FILES/users01.dbf
12 recoverable inodes still lost.
Failed to restore inode 11 to file RECOVERED_FILES/file.11:Inode does not correspond to a regular file.
Unable to restore inode 49153 (file.49153): Space has been reallocated.
Unable to restore inode 49154 (file.49154): Space has been reallocated.
Unable to restore inode 49155 (file.49155): Space has been reallocated.
Unable to restore inode 49156 (file.49156): Space has been reallocated.
Unable to restore inode 49157 (file.49157): Space has been reallocated.
Restored inode 49158 to file RECOVERED_FILES/file.49158
Restored inode 49159 to file RECOVERED_FILES/file.49159
Restored inode 49160 to file RECOVERED_FILES/file.49160
Restored inode 49161 to file RECOVERED_FILES/file.49161
Restored inode 49162 to file RECOVERED_FILES/file.49162
Restored inode 49163 to file RECOVERED_FILES/file.49163
重启后undo表空间是离线的，故报错如下

Completed: alter database open
Thu Sep6 22:02:57 2012
Errors in file /u01/app/oracle/admin/orcl104/bdump/orcl104_j002_32251.trc:
ORA-12012: error on auto execute of job 8912
ORA-00376: file ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl104/undotbs01.dbf'
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1347
ORA-06512: at "SYS.DBMS_SPACE", line 1566
cannot be read at this time
Thu Sep6 22:03:01 2012
GATHER_STATS_JOB encountered errors.Check the trace file.
Thu Sep6 22:03:01 2012
Errors in file /u01/app/oracle/admin/orcl104/bdump/orcl104_j001_32249.trc:
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl104/undotbs01.dbf'
SQL> col name format a460
SQL> col name format a60
SQL> r
1* select name,STATUS from v$datafile
NAMESTATUS
------------------------------------------------------------ --------------
/u01/app/oracle/oradata/orcl104/system01.dbfSYSTEM
/u01/app/oracle/oradata/orcl104/undotbs01.dbfRECOVER
/u01/app/oracle/oradata/orcl104/sysaux01.dbfONLINE
/u01/app/oracle/oradata/orcl104/users01.dbfONLINE
/u01/app/oracle/oradata/orcl104/mydbs1_01.dbfONLINE
SQL> select file#, name,STATUS from v$datafile;
FILE# NAMESTATUS
---------- ------------------------------------------------------------ --------------
1 /u01/app/oracle/oradata/orcl104/system01.dbfSYSTEM
2 /u01/app/oracle/oradata/orcl104/undotbs01.dbfRECOVER
3 /u01/app/oracle/oradata/orcl104/sysaux01.dbfONLINE
4 /u01/app/oracle/oradata/orcl104/users01.dbfONLINE
5 /u01/app/oracle/oradata/orcl104/mydbs1_01.dbfONLINE
SQL> recover datafile 2;
ORA-00279: change 940995 generated at 09/06/2012 21:46:08 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/arch/1_33_649507406.dbf
ORA-00280: change 940995 for thread 1 is in sequence #33

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 944108 generated at 09/06/2012 21:47:11 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/arch/1_34_649507406.dbf
ORA-00280: change 944108 for thread 1 is in sequence #34
ORA-00278: log file '/u01/app/oracle/arch/1_33_649507406.dbf' no longer needed for this recovery

Log applied.
Media recovery complete.
SQL> select file#, name,STATUS from v$datafile;
FILE# NAMESTATUS
---------- ------------------------------------------------------------ --------------
1 /u01/app/oracle/oradata/orcl104/system01.dbfSYSTEM
2 /u01/app/oracle/oradata/orcl104/undotbs01.dbfOFFLINE
3 /u01/app/oracle/oradata/orcl104/sysaux01.dbfONLINE
4 /u01/app/oracle/oradata/orcl104/users01.dbfONLINE
5 /u01/app/oracle/oradata/orcl104/mydbs1_01.dbfONLINE
SQL> select count(*) from t4;
select count(*) from t4
*
ERROR at line 1:
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl104/undotbs01.dbf'

SQL> select file#, name,STATUS from v$datafile;
FILE# NAMESTATUS
---------- ------------------------------------------------------------ --------------
1 /u01/app/oracle/oradata/orcl104/system01.dbfSYSTEM
2 /u01/app/oracle/oradata/orcl104/undotbs01.dbfOFFLINE
3 /u01/app/oracle/oradata/orcl104/sysaux01.dbfONLINE
4 /u01/app/oracle/oradata/orcl104/users01.dbfONLINE
5 /u01/app/oracle/oradata/orcl104/mydbs1_01.dbfONLINE
SQL> recover datafile 2;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

SQL> recover datafile 2;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

SQL> alter database datafile 2 online;
Database altered.
SQL> alter tablespace undotbs1 online;
Tablespace altered.
SQL> select file#, name,STATUS from v$datafile;
FILE# NAMESTATUS
---------- ------------------------------------------------------------ --------------
1 /u01/app/oracle/oradata/orcl104/system01.dbfSYSTEM
2 /u01/app/oracle/oradata/orcl104/undotbs01.dbfONLINE
3 /u01/app/oracle/oradata/orcl104/sysaux01.dbfONLINE
4 /u01/app/oracle/oradata/orcl104/users01.dbfONLINE
5 /u01/app/oracle/oradata/orcl104/mydbs1_01.dbfONLINE
SQL> select count(*) from t4;
COUNT(*)
----------
199340
SQL> select count(*) from t1;
COUNT(*)
----------
199328
SQL> select count(*) from t2;
COUNT(*)
----------
199332
SQL> select count(*) from t3;
COUNT(*)
----------
199336
SQL> select count(*) from t4;
COUNT(*)
----------
199340
【Linux下使用extundelete恢复ext3误删除数据文件】SQL>

推荐阅读

• 

  虎牙电脑开直播要求，虎牙直播要求电脑配置
• 

  导航怎样测速
• 

  老公经常说离婚是什么心理 老公说离婚应该怎么做
• 

  减重1公斤，需付出多少努力 减脂1公斤体重减多少
• 

  2019年第6周|2019年第6周 最有成就感的6件小事
• 

  两个人很契合是指投合,意气相投 两个人很契合是什么意思
• 

  北京的最低工资标准2021 最低工资标准2022北京
• 

  骂小山智丽，是否我们都骂错了 小山智利
• 

  日常生活有哪些常见小窍门
• 

  redis对服务器要求 服务器Redis配置
• 

  投稿|时尚、影视圈入局，虚拟偶像正在取代饭圈哥哥？
• 

  国家反诈中心app靠谱吗？你会安利你的家人和朋友下载吗？
• 

  海面一个川字乘以100打一成语
• 

  真空胎里打胶水好不好 真空胎是什么
• 

  财务分析-开篇
• 

  山西壶口瀑布在哪
• 

  疫情控制结束的标准
• 

  曲面屏|华为手机规格泄露!华为Mate50 Pro:顶级曲面屏+熟悉的设计 真香
• 

  mysql联合索引和单个索引 mysql组合索引单条
• 

  阳台适合种什么竹子 阳台种竹子好吗

• 开学第一天（下）
• 由浅入深理解AOP
• 【故障公告】周五下午的一次突发故障
• 【译】20个更有效地使用谷歌搜索的技巧
• 生活随笔｜好天气下的意外之喜
• mybatisplus如何在xml的连表查询中使用queryWrapper
• MybatisPlus|MybatisPlus LambdaQueryWrapper使用int默认值的坑及解决
• MybatisPlus使用queryWrapper如何实现复杂查询
• MongoDB，Wondows下免安装版|MongoDB，Wondows下免安装版 （简化版操作）
• 汇讲-勇于突破