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 6 ORA-01110: data file 6: '/opt/oracle/oradata/orcl11g/zbdba01.dbf' ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory Additional information: 3 [root@ogg1 ~]# ps -ef |grep dbw oracle 4884 1 0 22:31 ? 00:00:00 ora_dbw0_orcl11g root 5083 5063 0 22:35 pts/3 00:00:00 grep dbw [root@ogg1 ~]# lsof 4884 [root@ogg1 ~]# lsof -p 4884 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME oracle 4884 oracle cwd DIR 253,0 4096 1311097 /opt/oracle/products/11.2.0/dbs oracle 4884 oracle rtd DIR 253,0 4096 2 / oracle 4884 oracle txt REG 253,0 210823828 1715825 /opt/oracle/products/11.2.0/bin/oracle oracle 4884 oracle mem REG 0,16 4194304 30646 /dev/shm/ora_orcl11g_688128_0 oracle 4884 oracle mem REG 0,16 4194304 30647 /dev/shm/ora_orcl11g_688128_1 oracle 4884 oracle mem REG 0,16 0 30648 /dev/shm/ora_orcl11g_688128_2 oracle 4884 oracle mem REG 0,16 0 30649 /dev/shm/ora_orcl11g_688128_3 oracle 4884 oracle mem REG 0,16 0 30650 /dev/shm/ora_orcl11g_688128_4 oracle 4884 oracle mem REG 0,16 0 30651 /dev/shm/ora_orcl11g_688128_5 oracle 4884 oracle mem REG 0,16 0 30652 /dev/shm/ora_orcl11g_688128_6 oracle 4884 oracle mem REG 0,16 0 30653 /dev/shm/ora_orcl11g_688128_7 oracle 4884 oracle mem REG 0,16 0 30654 /dev/shm/ora_orcl11g_688128_8 oracle 4884 oracle mem REG 0,16 0 30655 /dev/shm/ora_orcl11g_688128_9 oracle 4884 oracle mem REG 0,16 0 30656 /dev/shm/ora_orcl11g_688128_10 oracle 4884 oracle mem REG 0,16 0 30657 /dev/shm/ora_orcl11g_688128_11 oracle 4884 oracle mem REG 0,16 0 30658 /dev/shm/ora_orcl11g_688128_12 oracle 4884 oracle mem REG 0,16 0 30659 /dev/shm/ora_orcl11g_688128_13 oracle 4884 oracle mem REG 0,16 0 30660 /dev/shm/ora_orcl11g_688128_14 oracle 4884 oracle mem REG 0,16 0 30661 /dev/shm/ora_orcl11g_688128_15 oracle 4884 oracle mem REG 0,16 0 30662 /dev/shm/ora_orcl11g_688128_16 oracle 4884 oracle mem REG 0,16 0 30663 /dev/shm/ora_orcl11g_688128_17 oracle 4884 oracle mem REG 0,16 0 30664 /dev/shm/ora_orcl11g_688128_18 oracle 4884 oracle mem REG 0,16 0 30665 /dev/shm/ora_orcl11g_688128_19 oracle 4884 oracle mem REG 0,16 0 30666 /dev/shm/ora_orcl11g_688128_20 oracle 4884 oracle mem REG 0,16 0 30667 /dev/shm/ora_orcl11g_688128_21 oracle 4884 oracle mem REG 0,16 0 30668 /dev/shm/ora_orcl11g_688128_22 oracle 4884 oracle mem REG 0,16 0 30669 /dev/shm/ora_orcl11g_688128_23 oracle 4884 oracle mem REG 0,16 0 30670 /dev/shm/ora_orcl11g_688128_24 oracle 4884 oracle mem REG 0,16 0 30671 /dev/shm/ora_orcl11g_688128_25 oracle 4884 oracle mem REG 0,16 0 30672 /dev/shm/ora_orcl11g_688128_26 oracle 4884 oracle mem REG 0,16 0 30673 /dev/shm/ora_orcl11g_688128_27 oracle 4884 oracle mem REG 0,16 0 30674 /dev/shm/ora_orcl11g_688128_28 oracle 4884 oracle mem REG 0,16 0 30675 /dev/shm/ora_orcl11g_688128_29 oracle 4884 oracle mem REG 0,16 0 30676 /dev/shm/ora_orcl11g_688128_30 oracle 4884 oracle mem REG 0,16 0 30677 /dev/shm/ora_orcl11g_688128_31 oracle 4884 oracle mem REG 0,16 0 30678 /dev/shm/ora_orcl11g_688128_32 oracle 4884 oracle mem REG 0,16 0 30679 /dev/shm/ora_orcl11g_688128_33 oracle 4884 oracle mem REG 0,16 0 30680 /dev/shm/ora_orcl11g_688128_34 oracle 4884 oracle mem REG 0,16 0 30681 /dev/shm/ora_orcl11g_688128_35 oracle 4884 oracle mem REG 0,16 0 30682 /dev/shm/ora_orcl11g_688128_36 oracle 4884 oracle mem REG 0,16 0 30683 /dev/shm/ora_orcl11g_688128_37 oracle 4884 oracle mem REG 0,16 0 30684 /dev/shm/ora_orcl11g_688128_38 oracle 4884 oracle mem REG 0,16 0 30685 /dev/shm/ora_orcl11g_688128_39 oracle 4884 oracle mem REG 0,16 4194304 30686 /dev/shm/ora_orcl11g_688128_40 oracle 4884 oracle mem REG 0,16 4194304 30687 /dev/shm/ora_orcl11g_688128_41 oracle 4884 oracle mem REG 0,16 4194304 30688 /dev/shm/ora_orcl11g_688128_42 oracle 4884 oracle mem REG 0,16 4194304 30689 /dev/shm/ora_orcl11g_688128_43 oracle 4884 oracle mem REG 0,16 4194304 30690 /dev/shm/ora_orcl11g_688128_44 oracle 4884 oracle mem REG 0,16 4194304 30691 /dev/shm/ora_orcl11g_688128_45 oracle 4884 oracle mem REG 0,16 4194304 30692 /dev/shm/ora_orcl11g_688128_46 oracle 4884 oracle mem REG 0,16 4194304 30693 /dev/shm/ora_orcl11g_688128_47 oracle 4884 oracle mem REG 0,16 4194304 30694 /dev/shm/ora_orcl11g_688128_48 oracle 4884 oracle mem REG 0,16 4194304 30695 /dev/shm/ora_orcl11g_688128_49 oracle 4884 oracle mem REG 0,16 4194304 30696 /dev/shm/ora_orcl11g_688128_50 oracle 4884 oracle mem REG 0,16 4194304 30697 /dev/shm/ora_orcl11g_688128_51 oracle 4884 oracle mem REG 0,16 4194304 30698 /dev/shm/ora_orcl11g_688128_52 oracle 4884 oracle mem REG 0,16 4194304 30699 /dev/shm/ora_orcl11g_688128_53 oracle 4884 oracle mem REG 0,16 4194304 30700 /dev/shm/ora_orcl11g_688128_54 oracle 4884 oracle mem REG 0,16 4194304 30701 /dev/shm/ora_orcl11g_688128_55 oracle 4884 oracle mem REG 0,16 4194304 30702 /dev/shm/ora_orcl11g_688128_56 oracle 4884 oracle mem REG 0,16 4194304 30703 /dev/shm/ora_orcl11g_688128_57 oracle 4884 oracle mem REG 0,16 4194304 30704 /dev/shm/ora_orcl11g_688128_58 oracle 4884 oracle mem REG 0,16 4194304 30705 /dev/shm/ora_orcl11g_688128_59 oracle 4884 oracle mem REG 0,16 4194304 30706 /dev/shm/ora_orcl11g_688128_60 oracle 4884 oracle mem REG 0,16 4194304 30707 /dev/shm/ora_orcl11g_688128_61 oracle 4884 oracle mem REG 0,16 4194304 30708 /dev/shm/ora_orcl11g_688128_62 oracle 4884 oracle mem REG 0,16 4194304 30709 /dev/shm/ora_orcl11g_688128_63 oracle 4884 oracle mem REG 0,16 4194304 30710 /dev/shm/ora_orcl11g_688128_64 oracle 4884 oracle mem REG 0,16 4194304 30711 /dev/shm/ora_orcl11g_688128_65 oracle 4884 oracle mem REG 0,16 4194304 30712 /dev/shm/ora_orcl11g_688128_66 oracle 4884 oracle mem REG 0,16 4194304 30713 /dev/shm/ora_orcl11g_688128_67 oracle 4884 oracle mem REG 0,16 4194304 30714 /dev/shm/ora_orcl11g_688128_68 oracle 4884 oracle mem REG 0,16 4194304 30715 /dev/shm/ora_orcl11g_688128_69 oracle 4884 oracle mem REG 0,16 4194304 30716 /dev/shm/ora_orcl11g_688128_70 oracle 4884 oracle mem REG 0,16 4194304 30717 /dev/shm/ora_orcl11g_688128_71 oracle 4884 oracle mem REG 0,16 4194304 30718 /dev/shm/ora_orcl11g_688128_72 oracle 4884 oracle mem REG 0,16 4194304 30719 /dev/shm/ora_orcl11g_688128_73 oracle 4884 oracle mem REG 0,16 4194304 30720 /dev/shm/ora_orcl11g_688128_74 oracle 4884 oracle mem REG 0,16 4194304 30721 /dev/shm/ora_orcl11g_688128_75 oracle 4884 oracle mem REG 0,16 4194304 30722 /dev/shm/ora_orcl11g_688128_76 oracle 4884 oracle mem REG 0,16 4194304 30723 /dev/shm/ora_orcl11g_688128_77 oracle 4884 oracle mem REG 0,16 4194304 30724 /dev/shm/ora_orcl11g_688128_78 oracle 4884 oracle mem REG 0,16 4194304 30725 /dev/shm/ora_orcl11g_688128_79 oracle 4884 oracle mem REG 0,16 4194304 30726 /dev/shm/ora_orcl11g_688128_80 oracle 4884 oracle mem REG 0,16 4194304 30727 /dev/shm/ora_orcl11g_688128_81 oracle 4884 oracle mem REG 0,16 4194304 30728 /dev/shm/ora_orcl11g_688128_82 oracle 4884 oracle mem REG 0,16 4194304 30729 /dev/shm/ora_orcl11g_688128_83 oracle 4884 oracle mem REG 0,16 4194304 30730 /dev/shm/ora_orcl11g_688128_84 oracle 4884 oracle mem REG 0,16 4194304 30731 /dev/shm/ora_orcl11g_688128_85 oracle 4884 oracle mem REG 0,16 4194304 30732 /dev/shm/ora_orcl11g_688128_86 oracle 4884 oracle mem REG 0,16 4194304 30733 /dev/shm/ora_orcl11g_688128_87 oracle 4884 oracle mem REG 0,16 4194304 30734 /dev/shm/ora_orcl11g_688128_88 oracle 4884 oracle mem REG 0,16 4194304 30735 /dev/shm/ora_orcl11g_688128_89 oracle 4884 oracle mem REG 0,16 4194304 30736 /dev/shm/ora_orcl11g_688128_90 oracle 4884 oracle mem REG 0,16 4194304 30737 /dev/shm/ora_orcl11g_688128_91 oracle 4884 oracle mem REG 0,16 4194304 30738 /dev/shm/ora_orcl11g_688128_92 oracle 4884 oracle mem REG 0,16 4194304 30739 /dev/shm/ora_orcl11g_688128_93 oracle 4884 oracle mem REG 0,16 4194304 30740 /dev/shm/ora_orcl11g_688128_94 oracle 4884 oracle mem REG 0,16 4194304 30741 /dev/shm/ora_orcl11g_688128_95 oracle 4884 oracle mem REG 0,16 4194304 30742 /dev/shm/ora_orcl11g_688128_96 oracle 4884 oracle mem REG 0,16 4194304 30743 /dev/shm/ora_orcl11g_688128_97 oracle 4884 oracle mem REG 0,16 4194304 30744 /dev/shm/ora_orcl11g_688128_98 oracle 4884 oracle mem REG 0,16 4194304 30745 /dev/shm/ora_orcl11g_688128_99 oracle 4884 oracle mem REG 0,16 4194304 30746 /dev/shm/ora_orcl11g_688128_100 oracle 4884 oracle mem REG 253,0 156872 917907 /lib64/ld-2.12.so oracle 4884 oracle mem REG 253,0 5624 917738 /lib64/libaio.so.1.0.1 oracle 4884 oracle mem REG 253,0 1918016 917908 /lib64/libc-2.12.so oracle 4884 oracle mem REG 253,0 145720 917913 /lib64/libpthread-2.12.so oracle 4884 oracle mem REG 253,0 598800 917909 /lib64/libm-2.12.so oracle 4884 oracle mem REG 253,0 47064 917920 /lib64/librt-2.12.so oracle 4884 oracle mem REG 253,0 116368 917655 /lib64/libnsl-2.12.so oracle 4884 oracle mem CHR 1,5 3645 /dev/zero oracle 4884 oracle mem REG 253,0 65928 917534 /lib64/libnss_files-2.12.so oracle 4884 oracle mem REG 253,0 22536 917915 /lib64/libdl-2.12.so oracle 4884 oracle mem REG 253,0 703495 1326729 /opt/oracle/products/11.2.0/lib/libasmclnt11.so oracle 4884 oracle mem REG 253,0 150756 1326374 /opt/oracle/products/11.2.0/lib/libocrutl11.so oracle 4884 oracle mem REG 253,0 3217927 1326373 /opt/oracle/products/11.2.0/lib/libocrb11.so oracle 4884 oracle mem REG 253,0 1493029 1326372 /opt/oracle/products/11.2.0/lib/libocr11.so oracle 4884 oracle mem REG 253,0 12771 1314370 /opt/oracle/products/11.2.0/lib/libskgxn2.so oracle 4884 oracle mem REG 253,0 12820762 1326340 /opt/oracle/products/11.2.0/lib/libhasgen11.so oracle 4884 oracle mem REG 253,0 162324 1314137 /opt/oracle/products/11.2.0/lib/libdbcfg11.so oracle 4884 oracle mem REG 253,0 190634 1326342 /opt/oracle/products/11.2.0/lib/libclsra11.so oracle 4884 oracle mem REG 253,0 7899997 1326546 /opt/oracle/products/11.2.0/lib/libnnz11.so oracle 4884 oracle mem REG 253,0 1544 1327995 /opt/oracle/products/11.2.0/dbs/hc_orcl11g.dat oracle 4884 oracle mem REG 253,0 851253 1313055 /opt/oracle/products/11.2.0/lib/libskgxp11.so oracle 4884 oracle mem REG 253,0 460569 1326728 /opt/oracle/products/11.2.0/lib/libcell11.so oracle 4884 oracle mem REG 253,0 12331 1311958 /opt/oracle/products/11.2.0/lib/libodmd11.so oracle 4884 oracle 0r CHR 1,3 0t0 3643 /dev/null oracle 4884 oracle 1w CHR 1,3 0t0 3643 /dev/null oracle 4884 oracle 2w CHR 1,3 0t0 3643 /dev/null oracle 4884 oracle 3w REG 253,0 765 1716105 /opt/oracle/products/11.2.0/rdbms/log/orcl11g_ora_4820.trc oracle 4884 oracle 4r CHR 1,3 0t0 3643 /dev/null oracle 4884 oracle 5r CHR 1,3 0t0 3643 /dev/null oracle 4884 oracle 6r CHR 1,3 0t0 3643 /dev/null oracle 4884 oracle 7u REG 253,0 1544 1327995 /opt/oracle/products/11.2.0/dbs/hc_orcl11g.dat oracle 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/fd oracle 4884 oracle 10w REG 253,0 14367 1977638 /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_ora_4820.trc oracle 4884 oracle 11w REG 253,0 258 1977639 /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_ora_4820.trm oracle 4884 oracle 12r REG 253,0 1074176 1715159 /opt/oracle/products/11.2.0/rdbms/mesg/oraus.msb oracle 4884 oracle 13r CHR 1,5 0t0 3645 /dev/zero oracle 4884 oracle 14r DIR 0,3 0 30896 /proc/4884/fd oracle 4884 oracle 15r CHR 1,5 0t0 3645 /dev/zero oracle 4884 oracle 16u REG 253,0 1544 1327995 /opt/oracle/products/11.2.0/dbs/hc_orcl11g.dat oracle 4884 oracle 17uR REG 253,0 24 1327997 /opt/oracle/products/11.2.0/dbs/lkORCL11G oracle 4884 oracle 18u REG 253,0 15843328 1967839 /opt/oracle/oradata/orcl11g/control01.ctl oracle 4884 oracle 19u REG 253,0 15843328 1967840 /opt/oracle/flash_recovery_area/orcl11g/control02.ctl oracle 4884 oracle 20uW REG 253,0 734011392 1967874 /opt/oracle/oradata/orcl11g/system01.dbf oracle 4884 oracle 21uW REG 253,0 545267712 1967875 /opt/oracle/oradata/orcl11g/sysaux01.dbf oracle 4884 oracle 22uW REG 253,0 68165632 1967883 /opt/oracle/oradata/orcl11g/undotbs01.dbf oracle 4884 oracle 23uW REG 253,0 57679872 1967884 /opt/oracle/oradata/orcl11g/users01.dbf oracle 4884 oracle 24uW REG 253,0 838868992 1977635 /opt/oracle/oradata/orcl11g/zbdba.dbf oracle 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.dbf oracle 4884 oracle 27uW REG 253,0 1056768 1967890 /opt/oracle/oradata/orcl11g/test_size.dbf oracle 4884 oracle 28uW REG 253,0 2105344 1967891 /opt/oracle/oradata/orcl11g/test_size2.dbf oracle 4884 oracle 29uW REG 253,0 104865792 1968637 /opt/oracle/oradata/orcl11g/undotb02.dbf oracle 4884 oracle 30uW REG 253,0 104865792 1968177 /opt/oracle/oradata/orcl11g/temp.dbf oracle 4884 oracle 31r REG 253,0 1074176 1715159 /opt/oracle/products/11.2.0/rdbms/mesg/oraus.msb [root@ogg1 ~]# ls -ltar /proc/4884/fd total 0 dr-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/fd lrwx------ 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.dat lr-x------ 1 oracle oinstall 64 Nov 2 22:33 6 -> /dev/null lr-x------ 1 oracle oinstall 64 Nov 2 22:33 5 -> /dev/null lr-x------ 1 oracle oinstall 64 Nov 2 22:33 4 -> /dev/null lr-x------ 1 oracle oinstall 64 Nov 2 22:33 31 -> /opt/oracle/products/11.2.0/rdbms/mesg/oraus.msb lrwx------ 1 oracle oinstall 64 Nov 2 22:33 30 -> /opt/oracle/oradata/orcl11g/temp.dbf l-wx------ 1 oracle oinstall 64 Nov 2 22:33 3 -> /opt/oracle/products/11.2.0/rdbms/log/orcl11g_ora_4820.trc lrwx------ 1 oracle oinstall 64 Nov 2 22:33 29 -> /opt/oracle/oradata/orcl11g/undotb02.dbf lrwx------ 1 oracle oinstall 64 Nov 2 22:33 28 -> /opt/oracle/oradata/orcl11g/test_size2.dbf lrwx------ 1 oracle oinstall 64 Nov 2 22:33 27 -> /opt/oracle/oradata/orcl11g/test_size.dbf lrwx------ 1 oracle oinstall 64 Nov 2 22:33 26 -> /opt/oracle/oradata/orcl11g/test.dbf lrwx------ 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.dbf lrwx------ 1 oracle oinstall 64 Nov 2 22:33 23 -> /opt/oracle/oradata/orcl11g/users01.dbf lrwx------ 1 oracle oinstall 64 Nov 2 22:33 22 -> /opt/oracle/oradata/orcl11g/undotbs01.dbf lrwx------ 1 oracle oinstall 64 Nov 2 22:33 21 -> /opt/oracle/oradata/orcl11g/sysaux01.dbf lrwx------ 1 oracle oinstall 64 Nov 2 22:33 20 -> /opt/oracle/oradata/orcl11g/system01.dbf l-wx------ 1 oracle oinstall 64 Nov 2 22:33 2 -> /dev/null lrwx------ 1 oracle oinstall 64 Nov 2 22:33 19 -> /opt/oracle/flash_recovery_area/orcl11g/control02.ctl lrwx------ 1 oracle oinstall 64 Nov 2 22:33 18 -> /opt/oracle/oradata/orcl11g/control01.ctl lrwx------ 1 oracle oinstall 64 Nov 2 22:33 17 -> /opt/oracle/products/11.2.0/dbs/lkORCL11G lrwx------ 1 oracle oinstall 64 Nov 2 22:33 16 -> /opt/oracle/products/11.2.0/dbs/hc_orcl11g.dat lr-x------ 1 oracle oinstall 64 Nov 2 22:33 15 -> /dev/zero lr-x------ 1 oracle oinstall 64 Nov 2 22:33 14 -> /proc/4884/fd lr-x------ 1 oracle oinstall 64 Nov 2 22:33 13 -> /dev/zero lr-x------ 1 oracle oinstall 64 Nov 2 22:33 12 -> /opt/oracle/products/11.2.0/rdbms/mesg/oraus.msb l-wx------ 1 oracle oinstall 64 Nov 2 22:33 11 -> /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_ora_4820.trm l-wx------ 1 oracle oinstall 64 Nov 2 22:33 10 -> /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_ora_4820.trc l-wx------ 1 oracle oinstall 64 Nov 2 22:33 1 -> /dev/null lr-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 -lrt total 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 -lrt total 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.ctl SYS@orcl11g>startup ORACLE instance started. Total System Global Area 417546240 bytes Fixed Size 2213936 bytes Variable Size 327157712 bytes Database Buffers 83886080 bytes Redo Buffers 4288512 bytes Database mounted. ORA-01113: file 6 needs media recovery ORA-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 ------------------------------------------------------------ zbdba huihui

linux设备节点是应用程序和设备驱动程序沟通的一个桥梁;设备节点被创建在“/dev”,是连接内核与用户层的枢纽,相当于硬盘的inode一样的东西,记录了硬件设备的位置和信息。设备节点使用户可以与内核进行硬件的沟通,读写设备以及其他的操作。

区别:1、open是UNIX系统调用函数,而fopen是ANSIC标准中的C语言库函数;2、open的移植性没fopen好;3、fopen只能操纵普通正规文件,而open可以操作普通文件、网络套接字等;4、open无缓冲,fopen有缓冲。

端口映射又称端口转发,是指将外部主机的IP地址的端口映射到Intranet中的一台计算机,当用户访问外网IP的这个端口时,服务器自动将请求映射到对应局域网内部的机器上;可以通过使用动态或固定的公共网络IP路由ADSL宽带路由器来实现。

在linux中,交叉编译是指在一个平台上生成另一个平台上的可执行代码,即编译源代码的平台和执行源代码编译后程序的平台是两个不同的平台。使用交叉编译的原因:1、目标系统没有能力在其上进行本地编译;2、有能力进行源代码编译的平台与目标平台不同。

在linux中,eof是自定义终止符,是“END Of File”的缩写;因为是自定义的终止符,所以eof就不是固定的,可以随意的设置别名,linux中按“ctrl+d”就代表eof,eof一般会配合cat命令用于多行文本输出,指文件末尾。

在linux中,可以利用“rpm -qa pcre”命令判断pcre是否安装;rpm命令专门用于管理各项套件,使用该命令后,若结果中出现pcre的版本信息,则表示pcre已经安装,若没有出现版本信息,则表示没有安装pcre。

linux查询mac地址的方法:1、打开系统,在桌面中点击鼠标右键,选择“打开终端”;2、在终端中,执行“ifconfig”命令,查看输出结果,在输出信息第四行中紧跟“ether”单词后的字符串就是mac地址。

在linux中,rpc是远程过程调用的意思,是Reomote Procedure Call的缩写,特指一种隐藏了过程调用时实际通信细节的IPC方法;linux中通过RPC可以充分利用非共享内存的多处理器环境,提高系统资源的利用率。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 Chinese version
Chinese version, very easy to use

SublimeText3 Mac version
God-level code editing software (SublimeText3)

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Dreamweaver CS6
Visual web development tools

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
