linux下误删数据文件恢复
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 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
登入後複製
本網站聲明
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn
熱AI工具
Undresser.AI Undress
人工智慧驅動的應用程序，用於創建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Undress AI Tool
免費脫衣圖片
Clothoff.io
AI脫衣器
Video Face Swap
使用我們完全免費的人工智慧換臉工具，輕鬆在任何影片中換臉！
熱門文章
Windows 11 KB5054979中的新功能以及如何解決更新問題
3 週前
By DDD
如何修復KB5055523無法在Windows 11中安裝？
2 週前
By DDD
Inzoi：如何申請學校和大學
4 週前
By DDD
如何修復KB5055518無法在Windows 10中安裝？
2 週前
By DDD
Roblox：Dead Rails - 如何召喚和擊敗Nikola Tesla
1 個月前
By 尊渡假赌尊渡假赌尊渡假赌
熱工具
記事本++7.3.1
好用且免費的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強大的PHP整合開發環境
Dreamweaver CS6
視覺化網頁開發工具
SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)
vscode需要什麼電腦配置
Apr 15, 2025 pm 09:48 PM
VS Code 系統要求：操作系統：Windows 10 及以上、macOS 10.12 及以上、Linux 發行版處理器：最低 1.6 GHz，推薦 2.0 GHz 及以上內存：最低 512 MB，推薦 4 GB 及以上存儲空間：最低 250 MB，推薦 1 GB 及以上其他要求：穩定網絡連接，Xorg/Wayland（Linux）
Linux體系結構：揭示5個基本組件
Apr 20, 2025 am 12:04 AM
Linux系統的五個基本組件是：1.內核，2.系統庫，3.系統實用程序，4.圖形用戶界面，5.應用程序。內核管理硬件資源，系統庫提供預編譯函數，系統實用程序用於系統管理，GUI提供可視化交互，應用程序利用這些組件實現功能。
vscode終端使用教程
Apr 15, 2025 pm 10:09 PM
vscode 內置終端是一個開發工具，允許在編輯器內運行命令和腳本，以簡化開發流程。如何使用 vscode 終端：通過快捷鍵 (Ctrl/Cmd ) 打開終端。輸入命令或運行腳本。使用熱鍵 (如 Ctrl L 清除終端)。更改工作目錄 (如 cd 命令)。高級功能包括調試模式、代碼片段自動補全和交互式命令歷史。
git怎麼查看倉庫地址
Apr 17, 2025 pm 01:54 PM
要查看 Git 倉庫地址，請執行以下步驟：1. 打開命令行並導航到倉庫目錄；2. 運行 "git remote -v" 命令；3. 查看輸出中的倉庫名稱及其相應的地址。
notepad怎麼運行java代碼
Apr 16, 2025 pm 07:39 PM
雖然 Notepad 無法直接運行 Java 代碼，但可以通過借助其他工具實現：使用命令行編譯器 (javac) 編譯代碼，生成字節碼文件 (filename.class)。使用 Java 解釋器 (java) 解釋字節碼，執行代碼並輸出結果。
vscode在哪寫代碼
Apr 15, 2025 pm 09:54 PM
在 Visual Studio Code（VSCode）中編寫代碼簡單易行，只需安裝 VSCode、創建項目、選擇語言、創建文件、編寫代碼、保存並運行即可。 VSCode 的優點包括跨平台、免費開源、強大功能、擴展豐富，以及輕量快速。
Linux的主要目的是什麼？
Apr 16, 2025 am 12:19 AM
Linux的主要用途包括：1.服務器操作系統，2.嵌入式系統，3.桌面操作系統，4.開發和測試環境。 Linux在這些領域表現出色，提供了穩定性、安全性和高效的開發工具。
vscode終端命令不能用
Apr 15, 2025 pm 10:03 PM
VS Code 終端命令無法使用的原因及解決辦法：未安裝必要的工具（Windows：WSL；macOS：Xcode 命令行工具）路徑配置錯誤（添加可執行文件到 PATH 環境變量中）權限問題（以管理員身份運行 VS Code）防火牆或代理限制（檢查設置，解除限制）終端設置不正確（啟用使用外部終端）VS Code 安裝損壞（重新安裝或更新）終端配置不兼容（嘗試不同的終端類型或命令）特定環境變量缺失（設置必要的環境變量）
