linux下误删数据文件恢复

linux下文件被删除可以用很多工具进行恢复，例如undelete(适合ext2,ext3)、giis(不能恢复安装giis之前的文件)、ext3grep(仅限ext3)、R-linux(支持ext3,但是需要操作系统是32位的)。还有testdisk等等就不一一介绍了。需要注意的是，我们误删文件后，最好保持现

linux下文件被删除可以用很多工具进行恢复，例如undelete(适合ext2,ext3)、giis(不能恢复安装giis之前的文件)、ext3grep(仅限ext3)、R-linux(支持ext3,但是需要操作系统是32位的)。还有testdisk等等就不一一介绍了。需要注意的是，我们误删文件后，最好保持现场。

下面不用工具来恢复误删的数据文件：

ZBDBA@orcl11g>select * from zbdba;select * from zbdba              *ERROR at line 1:ORA-01116: error in opening database file 6ORA-01110: data file 6: '/opt/oracle/oradata/orcl11g/zbdba01.dbf'ORA-27041: unable to open fileLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3[root@ogg1 ~]# ps -ef |grep dbworacle    4884     1  0 22:31 ?        00:00:00 ora_dbw0_orcl11groot      5083  5063  0 22:35 pts/3    00:00:00 grep dbw[root@ogg1 ~]# lsof 4884[root@ogg1 ~]# lsof -p 4884COMMAND  PID   USER   FD   TYPE DEVICE  SIZE/OFF    NODE NAMEoracle  4884 oracle  cwd    DIR  253,0      4096 1311097 /opt/oracle/products/11.2.0/dbsoracle  4884 oracle  rtd    DIR  253,0      4096       2 /oracle  4884 oracle  txt    REG  253,0 210823828 1715825 /opt/oracle/products/11.2.0/bin/oracleoracle  4884 oracle  mem    REG   0,16   4194304   30646 /dev/shm/ora_orcl11g_688128_0oracle  4884 oracle  mem    REG   0,16   4194304   30647 /dev/shm/ora_orcl11g_688128_1oracle  4884 oracle  mem    REG   0,16         0   30648 /dev/shm/ora_orcl11g_688128_2oracle  4884 oracle  mem    REG   0,16         0   30649 /dev/shm/ora_orcl11g_688128_3oracle  4884 oracle  mem    REG   0,16         0   30650 /dev/shm/ora_orcl11g_688128_4oracle  4884 oracle  mem    REG   0,16         0   30651 /dev/shm/ora_orcl11g_688128_5oracle  4884 oracle  mem    REG   0,16         0   30652 /dev/shm/ora_orcl11g_688128_6oracle  4884 oracle  mem    REG   0,16         0   30653 /dev/shm/ora_orcl11g_688128_7oracle  4884 oracle  mem    REG   0,16         0   30654 /dev/shm/ora_orcl11g_688128_8oracle  4884 oracle  mem    REG   0,16         0   30655 /dev/shm/ora_orcl11g_688128_9oracle  4884 oracle  mem    REG   0,16         0   30656 /dev/shm/ora_orcl11g_688128_10oracle  4884 oracle  mem    REG   0,16         0   30657 /dev/shm/ora_orcl11g_688128_11oracle  4884 oracle  mem    REG   0,16         0   30658 /dev/shm/ora_orcl11g_688128_12oracle  4884 oracle  mem    REG   0,16         0   30659 /dev/shm/ora_orcl11g_688128_13oracle  4884 oracle  mem    REG   0,16         0   30660 /dev/shm/ora_orcl11g_688128_14oracle  4884 oracle  mem    REG   0,16         0   30661 /dev/shm/ora_orcl11g_688128_15oracle  4884 oracle  mem    REG   0,16         0   30662 /dev/shm/ora_orcl11g_688128_16oracle  4884 oracle  mem    REG   0,16         0   30663 /dev/shm/ora_orcl11g_688128_17oracle  4884 oracle  mem    REG   0,16         0   30664 /dev/shm/ora_orcl11g_688128_18oracle  4884 oracle  mem    REG   0,16         0   30665 /dev/shm/ora_orcl11g_688128_19oracle  4884 oracle  mem    REG   0,16         0   30666 /dev/shm/ora_orcl11g_688128_20oracle  4884 oracle  mem    REG   0,16         0   30667 /dev/shm/ora_orcl11g_688128_21oracle  4884 oracle  mem    REG   0,16         0   30668 /dev/shm/ora_orcl11g_688128_22oracle  4884 oracle  mem    REG   0,16         0   30669 /dev/shm/ora_orcl11g_688128_23oracle  4884 oracle  mem    REG   0,16         0   30670 /dev/shm/ora_orcl11g_688128_24oracle  4884 oracle  mem    REG   0,16         0   30671 /dev/shm/ora_orcl11g_688128_25oracle  4884 oracle  mem    REG   0,16         0   30672 /dev/shm/ora_orcl11g_688128_26oracle  4884 oracle  mem    REG   0,16         0   30673 /dev/shm/ora_orcl11g_688128_27oracle  4884 oracle  mem    REG   0,16         0   30674 /dev/shm/ora_orcl11g_688128_28oracle  4884 oracle  mem    REG   0,16         0   30675 /dev/shm/ora_orcl11g_688128_29oracle  4884 oracle  mem    REG   0,16         0   30676 /dev/shm/ora_orcl11g_688128_30oracle  4884 oracle  mem    REG   0,16         0   30677 /dev/shm/ora_orcl11g_688128_31oracle  4884 oracle  mem    REG   0,16         0   30678 /dev/shm/ora_orcl11g_688128_32oracle  4884 oracle  mem    REG   0,16         0   30679 /dev/shm/ora_orcl11g_688128_33oracle  4884 oracle  mem    REG   0,16         0   30680 /dev/shm/ora_orcl11g_688128_34oracle  4884 oracle  mem    REG   0,16         0   30681 /dev/shm/ora_orcl11g_688128_35oracle  4884 oracle  mem    REG   0,16         0   30682 /dev/shm/ora_orcl11g_688128_36oracle  4884 oracle  mem    REG   0,16         0   30683 /dev/shm/ora_orcl11g_688128_37oracle  4884 oracle  mem    REG   0,16         0   30684 /dev/shm/ora_orcl11g_688128_38oracle  4884 oracle  mem    REG   0,16         0   30685 /dev/shm/ora_orcl11g_688128_39oracle  4884 oracle  mem    REG   0,16   4194304   30686 /dev/shm/ora_orcl11g_688128_40oracle  4884 oracle  mem    REG   0,16   4194304   30687 /dev/shm/ora_orcl11g_688128_41oracle  4884 oracle  mem    REG   0,16   4194304   30688 /dev/shm/ora_orcl11g_688128_42oracle  4884 oracle  mem    REG   0,16   4194304   30689 /dev/shm/ora_orcl11g_688128_43oracle  4884 oracle  mem    REG   0,16   4194304   30690 /dev/shm/ora_orcl11g_688128_44oracle  4884 oracle  mem    REG   0,16   4194304   30691 /dev/shm/ora_orcl11g_688128_45oracle  4884 oracle  mem    REG   0,16   4194304   30692 /dev/shm/ora_orcl11g_688128_46oracle  4884 oracle  mem    REG   0,16   4194304   30693 /dev/shm/ora_orcl11g_688128_47oracle  4884 oracle  mem    REG   0,16   4194304   30694 /dev/shm/ora_orcl11g_688128_48oracle  4884 oracle  mem    REG   0,16   4194304   30695 /dev/shm/ora_orcl11g_688128_49oracle  4884 oracle  mem    REG   0,16   4194304   30696 /dev/shm/ora_orcl11g_688128_50oracle  4884 oracle  mem    REG   0,16   4194304   30697 /dev/shm/ora_orcl11g_688128_51oracle  4884 oracle  mem    REG   0,16   4194304   30698 /dev/shm/ora_orcl11g_688128_52oracle  4884 oracle  mem    REG   0,16   4194304   30699 /dev/shm/ora_orcl11g_688128_53oracle  4884 oracle  mem    REG   0,16   4194304   30700 /dev/shm/ora_orcl11g_688128_54oracle  4884 oracle  mem    REG   0,16   4194304   30701 /dev/shm/ora_orcl11g_688128_55oracle  4884 oracle  mem    REG   0,16   4194304   30702 /dev/shm/ora_orcl11g_688128_56oracle  4884 oracle  mem    REG   0,16   4194304   30703 /dev/shm/ora_orcl11g_688128_57oracle  4884 oracle  mem    REG   0,16   4194304   30704 /dev/shm/ora_orcl11g_688128_58oracle  4884 oracle  mem    REG   0,16   4194304   30705 /dev/shm/ora_orcl11g_688128_59oracle  4884 oracle  mem    REG   0,16   4194304   30706 /dev/shm/ora_orcl11g_688128_60oracle  4884 oracle  mem    REG   0,16   4194304   30707 /dev/shm/ora_orcl11g_688128_61oracle  4884 oracle  mem    REG   0,16   4194304   30708 /dev/shm/ora_orcl11g_688128_62oracle  4884 oracle  mem    REG   0,16   4194304   30709 /dev/shm/ora_orcl11g_688128_63oracle  4884 oracle  mem    REG   0,16   4194304   30710 /dev/shm/ora_orcl11g_688128_64oracle  4884 oracle  mem    REG   0,16   4194304   30711 /dev/shm/ora_orcl11g_688128_65oracle  4884 oracle  mem    REG   0,16   4194304   30712 /dev/shm/ora_orcl11g_688128_66oracle  4884 oracle  mem    REG   0,16   4194304   30713 /dev/shm/ora_orcl11g_688128_67oracle  4884 oracle  mem    REG   0,16   4194304   30714 /dev/shm/ora_orcl11g_688128_68oracle  4884 oracle  mem    REG   0,16   4194304   30715 /dev/shm/ora_orcl11g_688128_69oracle  4884 oracle  mem    REG   0,16   4194304   30716 /dev/shm/ora_orcl11g_688128_70oracle  4884 oracle  mem    REG   0,16   4194304   30717 /dev/shm/ora_orcl11g_688128_71oracle  4884 oracle  mem    REG   0,16   4194304   30718 /dev/shm/ora_orcl11g_688128_72oracle  4884 oracle  mem    REG   0,16   4194304   30719 /dev/shm/ora_orcl11g_688128_73oracle  4884 oracle  mem    REG   0,16   4194304   30720 /dev/shm/ora_orcl11g_688128_74oracle  4884 oracle  mem    REG   0,16   4194304   30721 /dev/shm/ora_orcl11g_688128_75oracle  4884 oracle  mem    REG   0,16   4194304   30722 /dev/shm/ora_orcl11g_68812<mark style="color:transparent">来4源gaodaimacom搞#代%码*网</mark>8_76oracle  4884 oracle  mem    REG   0,16   4194304   30723 /dev/shm/ora_orcl11g_688128_77oracle  4884 oracle  mem    REG   0,16   4194304   30724 /dev/shm/ora_orcl11g_688128_78oracle  4884 oracle  mem    REG   0,16   4194304   30725 /dev/shm/ora_orcl11g_688128_79oracle  4884 oracle  mem    REG   0,16   4194304   30726 /dev/shm/ora_orcl11g_688128_80oracle  4884 oracle  mem    REG   0,16   4194304   30727 /dev/shm/ora_orcl11g_688128_81oracle  4884 oracle  mem    REG   0,16   4194304   30728 /dev/shm/ora_orcl11g_688128_82oracle  4884 oracle  mem    REG   0,16   4194304   30729 /dev/shm/ora_orcl11g_688128_83oracle  4884 oracle  mem    REG   0,16   4194304   30730 /dev/shm/ora_orcl11g_688128_84oracle  4884 oracle  mem    REG   0,16   4194304   30731 /dev/shm/ora_orcl11g_688128_85oracle  4884 oracle  mem    REG   0,16   4194304   30732 /dev/shm/ora_orcl11g_688128_86oracle  4884 oracle  mem    REG   0,16   4194304   30733 /dev/shm/ora_orcl11g_688128_87oracle  4884 oracle  mem    REG   0,16   4194304   30734 /dev/shm/ora_orcl11g_688128_88oracle  4884 oracle  mem    REG   0,16   4194304   30735 /dev/shm/ora_orcl11g_688128_89oracle  4884 oracle  mem    REG   0,16   4194304   30736 /dev/shm/ora_orcl11g_688128_90oracle  4884 oracle  mem    REG   0,16   4194304   30737 /dev/shm/ora_orcl11g_688128_91oracle  4884 oracle  mem    REG   0,16   4194304   30738 /dev/shm/ora_orcl11g_688128_92oracle  4884 oracle  mem    REG   0,16   4194304   30739 /dev/shm/ora_orcl11g_688128_93oracle  4884 oracle  mem    REG   0,16   4194304   30740 /dev/shm/ora_orcl11g_688128_94oracle  4884 oracle  mem    REG   0,16   4194304   30741 /dev/shm/ora_orcl11g_688128_95oracle  4884 oracle  mem    REG   0,16   4194304   30742 /dev/shm/ora_orcl11g_688128_96oracle  4884 oracle  mem    REG   0,16   4194304   30743 /dev/shm/ora_orcl11g_688128_97oracle  4884 oracle  mem    REG   0,16   4194304   30744 /dev/shm/ora_orcl11g_688128_98oracle  4884 oracle  mem    REG   0,16   4194304   30745 /dev/shm/ora_orcl11g_688128_99oracle  4884 oracle  mem    REG   0,16   4194304   30746 /dev/shm/ora_orcl11g_688128_100oracle  4884 oracle  mem    REG  253,0    156872  917907 /lib64/ld-2.12.sooracle  4884 oracle  mem    REG  253,0      5624  917738 /lib64/libaio.so.1.0.1oracle  4884 oracle  mem    REG  253,0   1918016  917908 /lib64/libc-2.12.sooracle  4884 oracle  mem    REG  253,0    145720  917913 /lib64/libpthread-2.12.sooracle  4884 oracle  mem    REG  253,0    598800  917909 /lib64/libm-2.12.sooracle  4884 oracle  mem    REG  253,0     47064  917920 /lib64/librt-2.12.sooracle  4884 oracle  mem    REG  253,0    116368  917655 /lib64/libnsl-2.12.sooracle  4884 oracle  mem    CHR    1,5              3645 /dev/zerooracle  4884 oracle  mem    REG  253,0     65928  917534 /lib64/libnss_files-2.12.sooracle  4884 oracle  mem    REG  253,0     22536  917915 /lib64/libdl-2.12.sooracle  4884 oracle  mem    REG  253,0    703495 1326729 /opt/oracle/products/11.2.0/lib/libasmclnt11.sooracle  4884 oracle  mem    REG  253,0    150756 1326374 /opt/oracle/products/11.2.0/lib/libocrutl11.sooracle  4884 oracle  mem    REG  253,0   3217927 1326373 /opt/oracle/products/11.2.0/lib/libocrb11.sooracle  4884 oracle  mem    REG  253,0   1493029 1326372 /opt/oracle/products/11.2.0/lib/libocr11.sooracle  4884 oracle  mem    REG  253,0     12771 1314370 /opt/oracle/products/11.2.0/lib/libskgxn2.sooracle  4884 oracle  mem    REG  253,0  12820762 1326340 /opt/oracle/products/11.2.0/lib/libhasgen11.sooracle  4884 oracle  mem    REG  253,0    162324 1314137 /opt/oracle/products/11.2.0/lib/libdbcfg11.sooracle  4884 oracle  mem    REG  253,0    190634 1326342 /opt/oracle/products/11.2.0/lib/libclsra11.sooracle  4884 oracle  mem    REG  253,0   7899997 1326546 /opt/oracle/products/11.2.0/lib/libnnz11.sooracle  4884 oracle  mem    REG  253,0      1544 1327995 /opt/oracle/products/11.2.0/dbs/hc_orcl11g.datoracle  4884 oracle  mem    REG  253,0    851253 1313055 /opt/oracle/products/11.2.0/lib/libskgxp11.sooracle  4884 oracle  mem    REG  253,0    460569 1326728 /opt/oracle/products/11.2.0/lib/libcell11.sooracle  4884 oracle  mem    REG  253,0     12331 1311958 /opt/oracle/products/11.2.0/lib/libodmd11.sooracle  4884 oracle    0r   CHR    1,3       0t0    3643 /dev/nulloracle  4884 oracle    1w   CHR    1,3       0t0    3643 /dev/nulloracle  4884 oracle    2w   CHR    1,3       0t0    3643 /dev/nulloracle  4884 oracle    3w   REG  253,0       765 1716105 /opt/oracle/products/11.2.0/rdbms/log/orcl11g_ora_4820.trcoracle  4884 oracle    4r   CHR    1,3       0t0    3643 /dev/nulloracle  4884 oracle    5r   CHR    1,3       0t0    3643 /dev/nulloracle  4884 oracle    6r   CHR    1,3       0t0    3643 /dev/nulloracle  4884 oracle    7u   REG  253,0      1544 1327995 /opt/oracle/products/11.2.0/dbs/hc_orcl11g.datoracle  4884 oracle    8u   REG  253,0         0 1327994 /opt/oracle/products/11.2.0/dbs/lkinstorcl11g (deleted)oracle  4884 oracle    9r   DIR    0,3         0   30896 /proc/4884/fdoracle  4884 oracle   10w   REG  253,0     14367 1977638 /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_ora_4820.trcoracle  4884 oracle   11w   REG  253,0       258 1977639 /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_ora_4820.trmoracle  4884 oracle   12r   REG  253,0   1074176 1715159 /opt/oracle/products/11.2.0/rdbms/mesg/oraus.msboracle  4884 oracle   13r   CHR    1,5       0t0    3645 /dev/zerooracle  4884 oracle   14r   DIR    0,3         0   30896 /proc/4884/fdoracle  4884 oracle   15r   CHR    1,5       0t0    3645 /dev/zerooracle  4884 oracle   16u   REG  253,0      1544 1327995 /opt/oracle/products/11.2.0/dbs/hc_orcl11g.datoracle  4884 oracle   17uR  REG  253,0        24 1327997 /opt/oracle/products/11.2.0/dbs/lkORCL11Goracle  4884 oracle   18u   REG  253,0  15843328 1967839 /opt/oracle/oradata/orcl11g/control01.ctloracle  4884 oracle   19u   REG  253,0  15843328 1967840 /opt/oracle/flash_recovery_area/orcl11g/control02.ctloracle  4884 oracle   20uW  REG  253,0 734011392 1967874 /opt/oracle/oradata/orcl11g/system01.dbforacle  4884 oracle   21uW  REG  253,0 545267712 1967875 /opt/oracle/oradata/orcl11g/sysaux01.dbforacle  4884 oracle   22uW  REG  253,0  68165632 1967883 /opt/oracle/oradata/orcl11g/undotbs01.dbforacle  4884 oracle   23uW  REG  253,0  57679872 1967884 /opt/oracle/oradata/orcl11g/users01.dbforacle  4884 oracle   24uW  REG  253,0 838868992 1977635 /opt/oracle/oradata/orcl11g/zbdba.dbforacle  4884 oracle   25uW  REG  253,0 104865792 1977252 /opt/oracle/oradata/orcl11g/zbdba01.dbf (deleted)oracle  4884 oracle   26uW  REG  253,0 125837312 1967879 /opt/oracle/oradata/orcl11g/test.dbforacle  4884 oracle   27uW  REG  253,0   1056768 1967890 /opt/oracle/oradata/orcl11g/test_size.dbforacle  4884 oracle   28uW  REG  253,0   2105344 1967891 /opt/oracle/oradata/orcl11g/test_size2.dbforacle  4884 oracle   29uW  REG  253,0 104865792 1968637 /opt/oracle/oradata/orcl11g/undotb02.dbforacle  4884 oracle   30uW  REG  253,0 104865792 1968177 /opt/oracle/oradata/orcl11g/temp.dbforacle  4884 oracle   31r   REG  253,0   1074176 1715159 /opt/oracle/products/11.2.0/rdbms/mesg/oraus.msb[root@ogg1 ~]# ls -ltar /proc/4884/fdtotal 0dr-xr-xr-x 7 oracle oinstall  0 Nov  2 22:31 ..dr-x------ 2 oracle oinstall  0 Nov  2 22:31 .lr-x------ 1 oracle oinstall 64 Nov  2 22:33 9 -> /proc/4884/fdlrwx------ 1 oracle oinstall 64 Nov  2 22:33 8 -> /opt/oracle/products/11.2.0/dbs/lkinstorcl11g (deleted)lrwx------ 1 oracle oinstall 64 Nov  2 22:33 7 -> /opt/oracle/products/11.2.0/dbs/hc_orcl11g.datlr-x------ 1 oracle oinstall 64 Nov  2 22:33 6 -> /dev/nulllr-x------ 1 oracle oinstall 64 Nov  2 22:33 5 -> /dev/nulllr-x------ 1 oracle oinstall 64 Nov  2 22:33 4 -> /dev/nulllr-x------ 1 oracle oinstall 64 Nov  2 22:33 31 -> /opt/oracle/products/11.2.0/rdbms/mesg/oraus.msblrwx------ 1 oracle oinstall 64 Nov  2 22:33 30 -> /opt/oracle/oradata/orcl11g/temp.dbfl-wx------ 1 oracle oinstall 64 Nov  2 22:33 3 -> /opt/oracle/products/11.2.0/rdbms/log/orcl11g_ora_4820.trclrwx------ 1 oracle oinstall 64 Nov  2 22:33 29 -> /opt/oracle/oradata/orcl11g/undotb02.dbflrwx------ 1 oracle oinstall 64 Nov  2 22:33 28 -> /opt/oracle/oradata/orcl11g/test_size2.dbflrwx------ 1 oracle oinstall 64 Nov  2 22:33 27 -> /opt/oracle/oradata/orcl11g/test_size.dbflrwx------ 1 oracle oinstall 64 Nov  2 22:33 26 -> /opt/oracle/oradata/orcl11g/test.dbflrwx------ 1 oracle oinstall 64 Nov  2 22:33 25 -> /opt/oracle/oradata/orcl11g/zbdba01.dbf (deleted)lrwx------ 1 oracle oinstall 64 Nov  2 22:33 24 -> /opt/oracle/oradata/orcl11g/zbdba.dbflrwx------ 1 oracle oinstall 64 Nov  2 22:33 23 -> /opt/oracle/oradata/orcl11g/users01.dbflrwx------ 1 oracle oinstall 64 Nov  2 22:33 22 -> /opt/oracle/oradata/orcl11g/undotbs01.dbflrwx------ 1 oracle oinstall 64 Nov  2 22:33 21 -> /opt/oracle/oradata/orcl11g/sysaux01.dbflrwx------ 1 oracle oinstall 64 Nov  2 22:33 20 -> /opt/oracle/oradata/orcl11g/system01.dbfl-wx------ 1 oracle oinstall 64 Nov  2 22:33 2 -> /dev/nulllrwx------ 1 oracle oinstall 64 Nov  2 22:33 19 -> /opt/oracle/flash_recovery_area/orcl11g/control02.ctllrwx------ 1 oracle oinstall 64 Nov  2 22:33 18 -> /opt/oracle/oradata/orcl11g/control01.ctllrwx------ 1 oracle oinstall 64 Nov  2 22:33 17 -> /opt/oracle/products/11.2.0/dbs/lkORCL11Glrwx------ 1 oracle oinstall 64 Nov  2 22:33 16 -> /opt/oracle/products/11.2.0/dbs/hc_orcl11g.datlr-x------ 1 oracle oinstall 64 Nov  2 22:33 15 -> /dev/zerolr-x------ 1 oracle oinstall 64 Nov  2 22:33 14 -> /proc/4884/fdlr-x------ 1 oracle oinstall 64 Nov  2 22:33 13 -> /dev/zerolr-x------ 1 oracle oinstall 64 Nov  2 22:33 12 -> /opt/oracle/products/11.2.0/rdbms/mesg/oraus.msbl-wx------ 1 oracle oinstall 64 Nov  2 22:33 11 -> /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_ora_4820.trml-wx------ 1 oracle oinstall 64 Nov  2 22:33 10 -> /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_ora_4820.trcl-wx------ 1 oracle oinstall 64 Nov  2 22:33 1 -> /dev/nulllr-x------ 1 oracle oinstall 64 Nov  2 22:33 0 -> /dev/null[root@ogg1 ~]# cd /proc/4884/fd[root@ogg1 fd]# cat 25 > /opt/oracle/oradata/orcl11g/zbdba01.dbf[root@ogg1 fd]# cd //opt/oracle/oradata/orcl11g/[root@ogg1 orcl11g]# ls -lrttotal 2895908-rw-r--r-- 1 oracle oinstall    405512 Oct 25 22:21 file.out-rw-r----- 1 oracle oinstall  25174016 Oct 27 02:04 temp01.dbf-rw-r----- 1 oracle oinstall  68165632 Oct 30 02:19 undo.dbf-rw-r----- 1 oracle oinstall 104865792 Nov  2 20:37 temp.dbf-rw-r----- 1 oracle oinstall  52429312 Nov  2 22:31 redo01.log-rw-r----- 1 oracle oinstall  52429312 Nov  2 22:31 redo02.log-rw-r----- 1 oracle oinstall  68165632 Nov  2 22:31 undotbs01.dbf-rw-r----- 1 oracle oinstall  57679872 Nov  2 22:31 users01.dbf-rw-r----- 1 oracle oinstall 838868992 Nov  2 22:31 zbdba.dbf-rw-r----- 1 oracle oinstall 125837312 Nov  2 22:31 test.dbf-rw-r----- 1 oracle oinstall   1056768 Nov  2 22:31 test_size.dbf-rw-r----- 1 oracle oinstall   2105344 Nov  2 22:31 test_size2.dbf-rw-r----- 1 oracle oinstall 104865792 Nov  2 22:31 1103.dbf-rw-r----- 1 oracle oinstall 545267712 Nov  2 22:41 sysaux01.dbf-rw-r----- 1 oracle oinstall 104865792 Nov  2 22:42 undotb02.dbf-rw-r----- 1 oracle oinstall 734011392 Nov  2 22:42 system01.dbf-rw-r----- 1 oracle oinstall  52429312 Nov  2 22:47 redo03.log-rw-r--r-- 1 root   root     104865792 Nov  2 22:47 zbdba01.dbf-rw-r----- 1 oracle oinstall  15843328 Nov  2 22:48 control01.ctl[root@ogg1 orcl11g]#[root@ogg1 orcl11g]# chown -R oracle.oinstall zbdba01.dbf[root@ogg1 orcl11g]# ls -lrttotal 2895908-rw-r--r-- 1 oracle oinstall    405512 Oct 25 22:21 file.out-rw-r----- 1 oracle oinstall  25174016 Oct 27 02:04 temp01.dbf-rw-r----- 1 oracle oinstall  68165632 Oct 30 02:19 undo.dbf-rw-r----- 1 oracle oinstall 104865792 Nov  2 20:37 temp.dbf-rw-r----- 1 oracle oinstall  52429312 Nov  2 22:31 redo01.log-rw-r----- 1 oracle oinstall  52429312 Nov  2 22:31 redo02.log-rw-r----- 1 oracle oinstall 104865792 Nov  2 22:31 1103.dbf-rw-r--r-- 1 oracle oinstall 104865792 Nov  2 22:47 zbdba01.dbf-rw-r----- 1 oracle oinstall  52429312 Nov  2 22:48 redo03.log-rw-r----- 1 oracle oinstall 734011392 Nov  2 22:48 system01.dbf-rw-r----- 1 oracle oinstall 545267712 Nov  2 22:48 sysaux01.dbf-rw-r----- 1 oracle oinstall  68165632 Nov  2 22:48 undotbs01.dbf-rw-r----- 1 oracle oinstall  57679872 Nov  2 22:48 users01.dbf-rw-r----- 1 oracle oinstall 838868992 Nov  2 22:48 zbdba.dbf-rw-r----- 1 oracle oinstall 125837312 Nov  2 22:48 test.dbf-rw-r----- 1 oracle oinstall   1056768 Nov  2 22:48 test_size.dbf-rw-r----- 1 oracle oinstall   2105344 Nov  2 22:48 test_size2.dbf-rw-r----- 1 oracle oinstall 104865792 Nov  2 22:48 undotb02.dbf-rw-r----- 1 oracle oinstall  15843328 Nov  2 22:49 control01.ctlSYS@orcl11g>startupORACLE instance started.Total System Global Area  417546240 bytesFixed Size                  2213936 bytesVariable Size             327157712 bytesDatabase Buffers           83886080 bytesRedo Buffers                4288512 bytesDatabase mounted.ORA-01113: file 6 needs media recoveryORA-01110: data file 6: '/opt/oracle/oradata/orcl11g/zbdba01.dbf'SYS@orcl11g>recover datafile 6;Media recovery complete.SYS@orcl11g>alter database open;Database altered.ZBDBA@orcl11g>select file_name,status from dba_data_files;FILE_NAME                                                    STATUS------------------------------------------------------------ ------------------------------------------------------------/opt/oracle/oradata/orcl11g/undotbs01.dbf                    AVAILABLE/opt/oracle/oradata/orcl11g/zbdba.dbf                        AVAILABLE/opt/oracle/oradata/orcl11g/zbdba01.dbf                      AVAILABLE/opt/oracle/oradata/orcl11g/users01.dbf                      AVAILABLE/opt/oracle/oradata/orcl11g/test.dbf                         AVAILABLE/opt/oracle/oradata/orcl11g/sysaux01.dbf                     AVAILABLE/opt/oracle/oradata/orcl11g/system01.dbf                     AVAILABLE/opt/oracle/oradata/orcl11g/test_size.dbf                    AVAILABLE/opt/oracle/oradata/orcl11g/test_size2.dbf                   AVAILABLE/opt/oracle/oradata/orcl11g/undotb02.dbf                     AVAILABLE

再次查看该表：

SYS@orcl11g>conn zbdba/oracle;Connected.ZBDBA@orcl11g>select * from zbdba;NAME------------------------------------------------------------zbdbahuihui

喜欢 (0)赏

[搞代码]

分享 (0)