linux误删数据文件后恢复

--------------创建测试表

[oracle@rhel6 ~]$ sqlplus / as sysdba

SQL>create user test identified by test default tablespace users;

SQL>grant dba to test;

SQL>create table test.c_test as select * from dba_users;

SQL> select count(*) from test.c_test;

  COUNT(*)
  ----------
    30

--------------删除数据文件

[oracle@rhel6 ~]$cd /u01/app/oradata/orcl

[oracle@rhel6 ~]$mv users01.dbf  users01.dbf.bak

--------------恢复

[oracle@rhel6 orcl]$ ps -ef|grep dbw
oracle    3332     1  0 15:50 ?        00:00:00 ora_dbw0_orcl
oracle    3620  3203  0 16:51 pts/4    00:00:00 grep dbw

 

[oracle@rhel6 orcl]$ cd /proc/3332/fd/

[oracle@rhel6 fd]$ ls -lrt
total 0
lrwx------. 1 oracle oinstall 64 Oct 18 16:51 9 -> /u01/app/oracle/product/11.2.0/db_1/dbs/hc_orcl.dat
lr-x------. 1 oracle oinstall 64 Oct 18 16:51 8 -> /dev/zero
lr-x------. 1 oracle oinstall 64 Oct 18 16:51 7 -> /proc/3332/fd
lr-x------. 1 oracle oinstall 64 Oct 18 16:51 6 -> /u01/app/oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msb
lr-x------. 1 oracle oinstall 64 Oct 18 16:51 5 -> /dev/null
lr-x------. 1 oracle oinstall 64 Oct 18 16:51 4 -> /dev/null
lr-x------. 1 oracle oinstall 64 Oct 18 16:51 3 -> /dev/null
lrwx------. 1 oracle oinstall 64 Oct 18 16:51 262 -> /u01/app/oradata/orcl/users01.dbf (deleted)
lrwx------. 1 oracle oinstall 64 Oct 18 16:51 261 -> /u01/app/oradata/orcl/temp01.dbf
lrwx------. 1 oracle oinstall 64 Oct 18 16:51 260 -> /u01/app/oradata/orcl/undotbs01.dbf
lrwx------. 1 oracle oinstall 64 Oct 18 16:51 259 -> /u01/app/oradata/orcl/sysaux01.dbf
lrwx------. 1 oracle oinstall 64 Oct 18 16:51 258 -> /u01/app/oradata/orcl/system01.dbf
lrwx------. 1 oracle oinstall 64 Oct 18 16:51 257 -> /u01/app/oracle/fast_recovery_area/orcl/control02.ctl
lrwx------. 1 oracle oinstall 64 Oct 18 16:51 256 -> /u01/app/oradata/orcl/control01.ctl
l-wx------. 1 oracle oinstall 64 Oct 18 16:51 2 -> /dev/null
lr-x------. 1 oracle oinstall 64 Oct 18 16:51 13 -> /u01/app/oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msb
lrwx------. 1 oracle oinstall 64 Oct 18 16:51 10 -> /u01/app/oracle/product/11.2.0/db_1/dbs/lkORCL
l-wx------. 1 oracle oinstall 64 Oct 18 16:51 1 -> /dev/null
lr-x------. 1 oracle oinstall 64 Oct 18 16:51 0 -> /dev/null

[oracle@rhel6 fd]$ cp 262 /u01/app/oradata/orcl/users01.dbf

[oracle@rhel6 ~]$ sqlplus / as sysdba

SQL>alter database datafile 4 offline;

Database altered.

SQL>recover datafile 4 ;

Media recovery complete.

SQL>alter database datafile 4 online;

Database altered.

SQL> select count(*) from test.c_test;

  COUNT(*)
  ----------
    30