使用句柄实现特定场景的无备份恢复

本文链接：https://blog.csdn.net/qq_21127313/article/details/72831466
参考《oracle DBA工作笔记》
[root@11g ~]# su - oracle
[oracle@11g ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 14 15:21:59 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/oradata/ORCL/datafile/o1_mf_system_ctdyf4d0_.dbf
/oradata/ORCL/datafile/o1_mf_sysaux_ctdyf4f3_.dbf
/oradata/ORCL/datafile/o1_mf_undotbs1_ctdyf4fg_.dbf
/oradata/ORCL/datafile/o1_mf_users_ctdyf4fv_.dbf
/oradata/ORCL/datafile/test_01.dbf

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g ~]$ rm /oradata/ORCL/datafile/test_01.dbf
[oracle@11g ~]$ cd /oradata/ORCL/datafile/
[oracle@11g datafile]$ ls
o1_mf_sysaux_ctdyf4f3_.dbf  o1_mf_temp_ctdyhg1s_.tmp      o1_mf_users_ctdyf4fv_.dbf
o1_mf_system_ctdyf4d0_.dbf  o1_mf_undotbs1_ctdyf4fg_.dbf
[oracle@11g datafile]$ ps -ef|grep dbw
oracle    1917     1  0 02:17 ?        00:00:01 ora_dbw0_orcl
oracle    6250  6154  0 15:23 pts/2    00:00:00 grep dbw
[oracle@11g datafile]$ cd /proc/1917/fd
[oracle@11g fd]$ ll
total 0
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 0 -> /dev/null
l-wx------ 1 oracle oinstall 64 Mar 14 08:54 1 -> /dev/null
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 10 -> /u01/app/oracle/product/11.2.0/dbhome_1/dbs/lkORCL
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 13 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msb
l-wx------ 1 oracle oinstall 64 Mar 14 08:54 2 -> /dev/null
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 256 -> /oradata/ORCL/controlfile/o1_mf_ctdygv67_.ctl
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 257 -> /oradata/ORCL/datafile/o1_mf_system_ctdyf4d0_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 258 -> /oradata/ORCL/datafile/o1_mf_sysaux_ctdyf4f3_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 259 -> /oradata/ORCL/datafile/o1_mf_undotbs1_ctdyf4fg_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 260 -> /oradata/ORCL/datafile/o1_mf_users_ctdyf4fv_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 261 -> /oradata/ORCL/datafile/test_01.dbf (deleted)
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 262 -> /oradata/ORCL/datafile/o1_mf_temp_ctdyhg1s_.tmp
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 3 -> /dev/null
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 4 -> /dev/null
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 5 -> /dev/null
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 6 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msb
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 7 -> /proc/1917/fd
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 8 -> /dev/zero
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 9 -> /u01/app/oracle/product/11.2.0/dbhome_1/dbs/hc_orcl.dat
[oracle@11g fd]$ cp 261 /oradata/ORCL/datafile/test_01.dbf
[oracle@11g fd]$ ll
total 0
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 0 -> /dev/null
l-wx------ 1 oracle oinstall 64 Mar 14 08:54 1 -> /dev/null
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 10 -> /u01/app/oracle/product/11.2.0/dbhome_1/dbs/lkORCL
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 13 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msb
l-wx------ 1 oracle oinstall 64 Mar 14 08:54 2 -> /dev/null
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 256 -> /oradata/ORCL/controlfile/o1_mf_ctdygv67_.ctl
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 257 -> /oradata/ORCL/datafile/o1_mf_system_ctdyf4d0_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 258 -> /oradata/ORCL/datafile/o1_mf_sysaux_ctdyf4f3_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 259 -> /oradata/ORCL/datafile/o1_mf_undotbs1_ctdyf4fg_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 260 -> /oradata/ORCL/datafile/o1_mf_users_ctdyf4fv_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 261 -> /oradata/ORCL/datafile/test_01.dbf (deleted)
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 262 -> /oradata/ORCL/datafile/o1_mf_temp_ctdyhg1s_.tmp
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 3 -> /dev/null
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 4 -> /dev/null
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 5 -> /dev/null
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 6 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msb
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 7 -> /proc/1917/fd
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 8 -> /dev/zero
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 9 -> /u01/app/oracle/product/11.2.0/dbhome_1/dbs/hc_orcl.dat
[oracle@11g fd]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 14 15:24:16 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> recover datafile '/oradata/ORCL/datafile/test_01.dbf';
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 5 - file is in use or recovery
ORA-01110: data file 5: '/oradata/ORCL/datafile/test_01.dbf'


SQL> alter database datafile '/oradata/ORCL/datafile/test_01.dbf' offline;

Database altered.

SQL> recover datafile '/oradata/ORCL/datafile/test_01.dbf';
Media recovery complete.
SQL> alter database datafile '/oradata/ORCL/datafile/test_01.dbf' online;

Database altered.

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g fd]$ ll
total 0
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 0 -> /dev/null
l-wx------ 1 oracle oinstall 64 Mar 14 08:54 1 -> /dev/null
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 10 -> /u01/app/oracle/product/11.2.0/dbhome_1/dbs/lkORCL
lrwx------ 1 oracle oinstall 64 Mar 14 15:25 11 -> socket:[226937]
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 13 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msb
l-wx------ 1 oracle oinstall 64 Mar 14 08:54 2 -> /dev/null
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 256 -> /oradata/ORCL/controlfile/o1_mf_ctdygv67_.ctl
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 257 -> /oradata/ORCL/datafile/o1_mf_system_ctdyf4d0_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 258 -> /oradata/ORCL/datafile/o1_mf_sysaux_ctdyf4f3_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 259 -> /oradata/ORCL/datafile/o1_mf_undotbs1_ctdyf4fg_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 260 -> /oradata/ORCL/datafile/o1_mf_users_ctdyf4fv_.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 261 -> /oradata/ORCL/datafile/test_01.dbf
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 262 -> /oradata/ORCL/datafile/o1_mf_temp_ctdyhg1s_.tmp
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 3 -> /dev/null
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 4 -> /dev/null
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 5 -> /dev/null
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 6 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msb
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 7 -> /proc/1917/fd
lr-x------ 1 oracle oinstall 64 Mar 14 08:54 8 -> /dev/zero
lrwx------ 1 oracle oinstall 64 Mar 14 08:54 9 -> /u01/app/oracle/product/11.2.0/dbhome_1/dbs/hc_orcl.dat
[oracle@11g fd]$