linux下误删数据文件恢复

数据库|mysql教程

linux,下误,数据,文件,恢复,linux,文件,删除,

数据库-mysql教程

jsp 开源商城系统源码,ubuntu强制关机慢,蜥蜴人和爬虫,私活 php,环保行业seolzw

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

会员下载系统源码,换源安装ubuntu,tomcat默认账号是什么,爬虫数据去除干扰,细说PHP 第4版 mobi,江苏外贸seolzw

网页留言板源码 php,ubuntu更改系统时间,python爬虫点赞,php shouce,河北前端seolzw

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.dbfORA-27041: unable to open fileLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3[root@ogg1 ~]# ps -ef |grep dbworacle 48841 0 22:31 ? 00:00:00 ora_dbw0_orcl11groot5083 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,04096 1311097 /opt/oracle/products/11.2.0/dbsoracle 4884 oracle rtd DIR 253,04096 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_688128_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,05624 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,047064 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,065928 917534 /lib64/libnss_files-2.12.sooracle 4884 oracle mem REG 253,022536 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,012771 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,01544 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,012331 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,01544 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,014367 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,01544 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 root104865792 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 Buffers4288512 bytesDatabase mounted.ORA-01113: file 6 needs media recoveryORA-01110: data file 6: /opt/oracle/oradata/orcl11g/zbdba01.dbfSYS@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.dbfAVAILABLE/opt/oracle/oradata/orcl11g/users01.dbfAVAILABLE/opt/oracle/oradata/orcl11g/test.dbf AVAILABLE/opt/oracle/oradata/orcl11g/sysaux01.dbfAVAILABLE/opt/oracle/oradata/orcl11g/system01.dbfAVAILABLE/opt/oracle/oradata/orcl11g/test_size.dbf AVAILABLE/opt/oracle/oradata/orcl11g/test_size2.dbf AVAILABLE/opt/oracle/oradata/orcl11g/undotb02.dbfAVAILABLE

再次查看该表：

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