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

参考《oracle DBA工作笔记》

[root@11g ~]# su - oracle[oracle@11g ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 14 15:21:59 2017Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> 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.dbfSQL> quitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith 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]$ lso1_mf_sysaux_ctdyf4f3_.dbf  o1_mf_temp_ctdyhg1s_.tmp      o1_mf_users_ctdyf4fv_.dbfo1_mf_system_ctdyf4d0_.dbf  o1_mf_undotbs1_ctdyf4fg_.dbf[oracle@11g datafile]$ ps -ef|grep dbworacle    1917     1  0 02:17 ?        00:00:01 ora_dbw0_orcloracle    6250  6154  0 15:23 pts/2    00:00:00 grep dbw[oracle@11g datafile]$ cd /proc/1917/fd[oracle@11g fd]$ lltotal 0lr-x------ 1 oracle oinstall 64 Mar 14 08:54 0 -> /dev/nulll-wx------ 1 oracle oinstall 64 Mar 14 08:54 1 -> /dev/nulllrwx------ 1 oracle oinstall 64 Mar 14 08:54 10 -> /u01/app/oracle/product/11.2.0/dbhome_1/dbs/lkORCLlr-x------ 1 oracle oinstall 64 Mar 14 08:54 13 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msbl-wx------ 1 oracle oinstall 64 Mar 14 08:54 2 -> /dev/nulllrwx------ 1 oracle oinstall 64 Mar 14 08:54 256 -> /oradata/ORCL/controlfile/o1_mf_ctdygv67_.ctllrwx------ 1 oracle oinstall 64 Mar 14 08:54 257 -> /oradata/ORCL/datafile/o1_mf_system_ctdyf4d0_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 258 -> /oradata/ORCL/datafile/o1_mf_sysaux_ctdyf4f3_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 259 -> /oradata/ORCL/datafile/o1_mf_undotbs1_ctdyf4fg_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 260 -> /oradata/ORCL/datafile/o1_mf_users_ctdyf4fv_.dbflrwx------ 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_.tmplr-x------ 1 oracle oinstall 64 Mar 14 08:54 3 -> /dev/nulllr-x------ 1 oracle oinstall 64 Mar 14 08:54 4 -> /dev/nulllr-x------ 1 oracle oinstall 64 Mar 14 08:54 5 -> /dev/nulllr-x------ 1 oracle oinstall 64 Mar 14 08:54 6 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msblr-x------ 1 oracle oinstall 64 Mar 14 08:54 7 -> /proc/1917/fdlr-x------ 1 oracle oinstall 64 Mar 14 08:54 8 -> /dev/zerolrwx------ 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]$ lltotal 0lr-x------ 1 oracle oinstall 64 Mar 14 08:54 0 -> /dev/nulll-wx------ 1 oracle oinstall 64 Mar 14 08:54 1 -> /dev/nulllrwx------ 1 oracle oinstall 64 Mar 14 08:54 10 -> /u01/app/oracle/product/11.2.0/dbhome_1/dbs/lkORCLlr-x------ 1 oracle oinstall 64 Mar 14 08:54 13 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msbl-wx------ 1 oracle oinstall 64 Mar 14 08:54 2 -> /dev/nulllrwx------ 1 oracle oinstall 64 Mar 14 08:54 256 -> /oradata/ORCL/controlfile/o1_mf_ctdygv67_.ctllrwx------ 1 oracle oinstall 64 Mar 14 08:54 257 -> /oradata/ORCL/datafile/o1_mf_system_ctdyf4d0_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 258 -> /oradata/ORCL/datafile/o1_mf_sysaux_ctdyf4f3_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 259 -> /oradata/ORCL/datafile/o1_mf_undotbs1_ctdyf4fg_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 260 -> /oradata/ORCL/datafile/o1_mf_users_ctdyf4fv_.dbflrwx------ 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_.tmplr-x------ 1 oracle oinstall 64 Mar 14 08:54 3 -> /dev/nulllr-x------ 1 oracle oinstall 64 Mar 14 08:54 4 -> /dev/nulllr-x------ 1 oracle oinstall 64 Mar 14 08:54 5 -> /dev/nulllr-x------ 1 oracle oinstall 64 Mar 14 08:54 6 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msblr-x------ 1 oracle oinstall 64 Mar 14 08:54 7 -> /proc/1917/fdlr-x------ 1 oracle oinstall 64 Mar 14 08:54 8 -> /dev/zerolrwx------ 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 sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 14 15:24:16 2017Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> recover datafile '/oradata/ORCL/datafile/test_01.dbf';ORA-00283: recovery session canceled due to errorsORA-01124: cannot recover data file 5 - file is in use or recoveryORA-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> quitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@11g fd]$ lltotal 0lr-x------ 1 oracle oinstall 64 Mar 14 08:54 0 -> /dev/nulll-wx------ 1 oracle oinstall 64 Mar 14 08:54 1 -> /dev/nulllrwx------ 1 oracle oinstall 64 Mar 14 08:54 10 -> /u01/app/oracle/product/11.2.0/dbhome_1/dbs/lkORCLlrwx------ 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.msbl-wx------ 1 oracle oinstall 64 Mar 14 08:54 2 -> /dev/nulllrwx------ 1 oracle oinstall 64 Mar 14 08:54 256 -> /oradata/ORCL/controlfile/o1_mf_ctdygv67_.ctllrwx------ 1 oracle oinstall 64 Mar 14 08:54 257 -> /oradata/ORCL/datafile/o1_mf_system_ctdyf4d0_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 258 -> /oradata/ORCL/datafile/o1_mf_sysaux_ctdyf4f3_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 259 -> /oradata/ORCL/datafile/o1_mf_undotbs1_ctdyf4fg_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 260 -> /oradata/ORCL/datafile/o1_mf_users_ctdyf4fv_.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 261 -> /oradata/ORCL/datafile/test_01.dbflrwx------ 1 oracle oinstall 64 Mar 14 08:54 262 -> /oradata/ORCL/datafile/o1_mf_temp_ctdyhg1s_.tmplr-x------ 1 oracle oinstall 64 Mar 14 08:54 3 -> /dev/nulllr-x------ 1 oracle oinstall 64 Mar 14 08:54 4 -> /dev/nulllr-x------ 1 oracle oinstall 64 Mar 14 08:54 5 -> /dev/nulllr-x------ 1 oracle oinstall 64 Mar 14 08:54 6 -> /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/mesg/oraus.msblr-x------ 1 oracle oinstall 64 Mar 14 08:54 7 -> /proc/1917/fdlr-x------ 1 oracle oinstall 64 Mar 14 08:54 8 -> /dev/zerolrwx------ 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]$