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

MySQLdiffersfromotherSQLdialectsinsyntaxforLIMIT,auto-increment,stringcomparison,subqueries,andperformanceanalysis.1)MySQLusesLIMIT,whileSQLServerusesTOPandOracleusesROWNUM.2)MySQL'sAUTO_INCREMENTcontrastswithPostgreSQL'sSERIALandOracle'ssequenceandt

MySQL partitioning improves performance and simplifies maintenance. 1) Divide large tables into small pieces by specific criteria (such as date ranges), 2) physically divide data into independent files, 3) MySQL can focus on related partitions when querying, 4) Query optimizer can skip unrelated partitions, 5) Choosing the right partition strategy and maintaining it regularly is key.

How to grant and revoke permissions in MySQL? 1. Use the GRANT statement to grant permissions, such as GRANTALLPRIVILEGESONdatabase_name.TO'username'@'host'; 2. Use the REVOKE statement to revoke permissions, such as REVOKEALLPRIVILEGESONdatabase_name.FROM'username'@'host' to ensure timely communication of permission changes.

InnoDB is suitable for applications that require transaction support and high concurrency, while MyISAM is suitable for applications that require more reads and less writes. 1.InnoDB supports transaction and bank-level locks, suitable for e-commerce and banking systems. 2.MyISAM provides fast read and indexing, suitable for blogging and content management systems.

There are four main JOIN types in MySQL: INNERJOIN, LEFTJOIN, RIGHTJOIN and FULLOUTERJOIN. 1.INNERJOIN returns all rows in the two tables that meet the JOIN conditions. 2.LEFTJOIN returns all rows in the left table, even if there are no matching rows in the right table. 3. RIGHTJOIN is contrary to LEFTJOIN and returns all rows in the right table. 4.FULLOUTERJOIN returns all rows in the two tables that meet or do not meet JOIN conditions.

MySQLoffersvariousstorageengines,eachsuitedfordifferentusecases:1)InnoDBisidealforapplicationsneedingACIDcomplianceandhighconcurrency,supportingtransactionsandforeignkeys.2)MyISAMisbestforread-heavyworkloads,lackingtransactionsupport.3)Memoryengineis

Common security vulnerabilities in MySQL include SQL injection, weak passwords, improper permission configuration, and unupdated software. 1. SQL injection can be prevented by using preprocessing statements. 2. Weak passwords can be avoided by forcibly using strong password strategies. 3. Improper permission configuration can be resolved through regular review and adjustment of user permissions. 4. Unupdated software can be patched by regularly checking and updating the MySQL version.

Identifying slow queries in MySQL can be achieved by enabling slow query logs and setting thresholds. 1. Enable slow query logs and set thresholds. 2. View and analyze slow query log files, and use tools such as mysqldumpslow or pt-query-digest for in-depth analysis. 3. Optimizing slow queries can be achieved through index optimization, query rewriting and avoiding the use of SELECT*.


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

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Dreamweaver CS6
Visual web development tools

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

Atom editor mac version download
The most popular open source editor

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
