{"id":930,"date":"2013-07-16T15:53:14","date_gmt":"2013-07-16T07:53:14","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=930"},"modified":"2013-07-16T15:55:05","modified_gmt":"2013-07-16T07:55:05","slug":"%e6%97%a0%e5%a4%87%e4%bb%bd%e6%83%85%e5%86%b5%e4%b8%8b%e7%9a%84%e6%95%b0%e6%8d%ae%e6%96%87%e4%bb%b6%e6%81%a2%e5%a4%8d%e4%b8%80%e4%be%8b","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=930","title":{"rendered":"\u65e0\u5907\u4efd\u60c5\u51b5\u4e0b\u7684\u6570\u636e\u6587\u4ef6\u6062\u590d\u4e00\u4f8b"},"content":{"rendered":"<p><strong>\u4e0b\u8fb9\u7684\u4f8b\u5b50\u662f\u6570\u636e\u5e93\u59cb\u7ec8\u5728\u542f\u52a8\u72b6\u6001\u4e0b\uff0c\u901a\u8fc7\u64cd\u4f5c\u7cfb\u7edf\u6587\u4ef6\u63cf\u8ff0\u7b26\u6062\u590d\u8bef\u5220\u9664\u7684\u6570\u636e\u5e93\u7684\u6570\u636e\u6587\u4ef6\u3002<br \/>\n\u6062\u590d\u6761\u4ef6\uff1a\u6570\u636e\u5e93\u59cb\u7ec8\u5904\u4e8e\u542f\u52a8\u72b6\u6001\u3002<br \/>\n\u6ce8\u610f\uff1a\u901a\u8fc7lsof\u547d\u4ee4\u627e\u64cd\u4f5c\u7cfb\u7edf\u6587\u4ef6\u53f7\u548c\u6570\u636e\u5e93\u6587\u4ef6\u7684\u5bf9\u5e94\u5173\u7cfb\u662f\u5173\u952e\u3002<\/strong><\/p>\n<p>\u64cd\u4f5c\u7cfb\u7edf\u4fe1\u606f<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@rhl6 ~]$ uname -a\r\nLinux rhl6.0x64 2.6.32-71.el6.x86_64 #1 SMP Wed Sep 1 01:33:01 EDT 2010 x86_64 x86_64 x86_64 GNU\/Linux\r\n<\/pre>\n<p>\u6570\u636e\u5e93\u7248\u672c<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; set line 300\r\nSQL&gt; select * from v$version;\r\n\r\nBANNER\r\n--------------------------------------------------------------------------------\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nPL\/SQL Release 11.2.0.3.0 - Production\r\nCORE    11.2.0.3.0      Production\r\nTNS for Linux: Version 11.2.0.3.0 - Production\r\nNLSRTL Version 11.2.0.3.0 - Production\r\n<\/pre>\n<p>\u6a21\u62df\u6570\u636e<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; create tablespace yallonking datafile &#039;\/u01\/testdir\/yallonking01.dbf&#039; size 10m;\r\n\r\nTablespace created.\r\n\r\nSQL&gt; create user yallonking identified by yallonking default tablespace yallonking quota unlimited on yallonking;\r\n\r\nUser created.\r\n\r\nSQL&gt; grant dba to yallonking;\r\n\r\nGrant succeeded.\r\n\r\nSQL&gt; conn yallonking\/yallonking\r\nConnected.\r\nSQL&gt; create table yallonking (id number,name varchar2(30),my_date date);\r\n\r\nTable created.\r\n\r\nSQL&gt; insert into yallonking values(1,&#039;yallonking&#039;,sysdate);\r\n\r\n1 row created.\r\n\r\nSQL&gt; commit;\r\n\r\nCommit complete.\r\n\r\nSQL&gt; alter session set nls_date_format=&#039;yyyy\/mm\/dd hh24:mi:ss&#039;;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select * from yallonking;\r\n\r\n        ID NAME                           MY_DATE\r\n---------- ------------------------------ -------------------\r\n         1 yallonking                     2013\/07\/16 14:47:28\r\n\r\nSQL&gt; col name for a50\r\nSQL&gt; select FILE#,name from v$datafile;\r\n\r\n     FILE# NAME\r\n---------- --------------------------------------------------\r\n         1 \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\n         2 \/u01\/app\/oracle\/oradata\/ora11gr2\/sysaux01.dbf\r\n         3 \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf\r\n         4 \/u01\/app\/oracle\/oradata\/ora11gr2\/users01.dbf\r\n         5 \/u01\/testdir\/yallonking01.dbf\r\n<\/pre>\n<p>\u4ece\u64cd\u4f5c\u7cfb\u7edf\u5c42\u9762\u5220\u9664\u76ee\u5f55\/testdir\u6a21\u62df\u6570\u636e\u6587\u4ef6\u4e22\u5931<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@rhl6 ~]$ cd \/u01\r\n[oracle@rhl6 u01]$ ls -ltr\r\ntotal 8\r\ndrwxr-xr-x. 4 oracle oinstall 4096 Dec 24  2012 app\r\ndrwxr-xr-x. 2 oracle oinstall 4096 Jul 16 14:44 testdir\r\n[oracle@rhl6 u01]$ ls -l testdir\/\r\ntotal 10248\r\n-rw-r-----. 1 oracle oinstall 10493952 Jul 16 14:44 yallonking01.dbf\r\n[oracle@rhl6 u01]$ rm -rf testdir\r\n[oracle@rhl6 u01]$ ls -l\r\ntotal 4\r\ndrwxr-xr-x. 4 oracle oinstall 4096 Dec 24  2012 app\r\n<\/pre>\n<p>\u5728\u6e05\u7a7a\u7f13\u5b58\u540e\uff0c\u67e5\u8be2\u62a5\u9519<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; select * from yallonking.yallonking;\r\n\r\n        ID NAME                           MY_DATE\r\n---------- ------------------------------ ---------\r\n         1 yallonking                     16-JUL-13\r\n\r\nSQL&gt; alter system flush BUFFER_CACHE;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; select * from yallonking.yallonking;\r\nselect * from yallonking.yallonking\r\n                         *\r\nERROR at line 1:\r\nORA-01116: error in opening database file 5\r\nORA-01110: data file 5: &#039;\/u01\/testdir\/yallonking01.dbf&#039;\r\nORA-27041: unable to open file\r\nLinux-x86_64 Error: 2: No such file or directory\r\nAdditional information: 3\r\n<\/pre>\n<p>\u65e5\u5fd7\u62a5\u9519\u5982\u4e0b<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nTue Jul 16 14:54:57 2013\r\nALTER SYSTEM: Flushing buffer cache\r\nTue Jul 16 14:55:07 2013\r\nChecker run found 1 new persistent data failures\r\nTue Jul 16 14:58:26 2013\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_m000_2160.trc:\r\nORA-01116: error in opening database file 5\r\nORA-01110: data file 5: &#039;\/u01\/testdir\/yallonking01.dbf&#039;\r\nORA-27041: unable to open file\r\nLinux-x86_64 Error: 2: No such file or directory\r\nAdditional information: 3\r\n\r\n<\/pre>\n<p>----------------------<strong>\u5f00\u59cb\u6062\u590d<\/strong>----------------------<br \/>\n\u5728\u64cd\u4f5c\u7cfb\u7edf\u67e5\u770b\u4e22\u5931\u6587\u4ef6\u7684\u6587\u4ef6\u53f7<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[root@rhl6 ~]# ps -ef | grep dbw | grep -v grep\r\noracle    1809     1  0 14:38 ?        00:00:00 ora_dbw0_ora11gr2\r\n[root@rhl6 ~]# lsof -p 1809\r\nCOMMAND  PID   USER   FD   TYPE DEVICE  SIZE\/OFF    NODE NAME\r\noracle  1809 oracle  cwd    DIR    8,3      4096 1046904 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\r\noracle  1809 oracle  rtd    DIR    8,3      4096       2 \/\r\noracle  1809 oracle  txt    REG    8,3 232472284 1584882 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/bin\/oracle\r\noracle  1809 oracle  mem    REG   0,17   4194304   14436 \/dev\/shm\/ora_ora11gr2_32768_0\r\noracle  1809 oracle  mem    REG   0,17   4194304   14437 \/dev\/shm\/ora_ora11gr2_32768_1\r\noracle  1809 oracle  mem    REG   0,17   4194304   14438 \/dev\/shm\/ora_ora11gr2_32768_2\r\noracle  1809 oracle  mem    REG   0,17         0   14442 \/dev\/shm\/ora_ora11gr2_65537_0\r\noracle  1809 oracle  mem    REG   0,17         0   14443 \/dev\/shm\/ora_ora11gr2_65537_1\r\noracle  1809 oracle  mem    REG   0,17         0   14444 \/dev\/shm\/ora_ora11gr2_65537_2\r\noracle  1809 oracle  mem    REG   0,17         0   14445 \/dev\/shm\/ora_ora11gr2_65537_3\r\noracle  1809 oracle  mem    REG   0,17         0   14446 \/dev\/shm\/ora_ora11gr2_65537_4\r\noracle  1809 oracle  mem    REG   0,17         0   14447 \/dev\/shm\/ora_ora11gr2_65537_5\r\noracle  1809 oracle  mem    REG   0,17         0   14448 \/dev\/shm\/ora_ora11gr2_65537_6\r\noracle  1809 oracle  mem    REG   0,17         0   14449 \/dev\/shm\/ora_ora11gr2_65537_7\r\noracle  1809 oracle  mem    REG   0,17         0   14450 \/dev\/shm\/ora_ora11gr2_65537_8\r\noracle  1809 oracle  mem    REG   0,17         0   14451 \/dev\/shm\/ora_ora11gr2_65537_9\r\noracle  1809 oracle  mem    REG   0,17         0   14452 \/dev\/shm\/ora_ora11gr2_65537_10\r\noracle  1809 oracle  mem    REG   0,17         0   14453 \/dev\/shm\/ora_ora11gr2_65537_11\r\noracle  1809 oracle  mem    REG   0,17         0   14454 \/dev\/shm\/ora_ora11gr2_65537_12\r\noracle  1809 oracle  mem    REG   0,17         0   14455 \/dev\/shm\/ora_ora11gr2_65537_13\r\noracle  1809 oracle  mem    REG   0,17         0   14456 \/dev\/shm\/ora_ora11gr2_65537_14\r\noracle  1809 oracle  mem    REG   0,17         0   14457 \/dev\/shm\/ora_ora11gr2_65537_15\r\noracle  1809 oracle  mem    REG   0,17         0   14458 \/dev\/shm\/ora_ora11gr2_65537_16\r\noracle  1809 oracle  mem    REG   0,17         0   14459 \/dev\/shm\/ora_ora11gr2_65537_17\r\noracle  1809 oracle  mem    REG   0,17         0   14460 \/dev\/shm\/ora_ora11gr2_65537_18\r\noracle  1809 oracle  mem    REG   0,17         0   14461 \/dev\/shm\/ora_ora11gr2_65537_19\r\noracle  1809 oracle  mem    REG   0,17         0   14462 \/dev\/shm\/ora_ora11gr2_65537_20\r\noracle  1809 oracle  mem    REG   0,17         0   14463 \/dev\/shm\/ora_ora11gr2_65537_21\r\noracle  1809 oracle  mem    REG   0,17         0   14464 \/dev\/shm\/ora_ora11gr2_65537_22\r\noracle  1809 oracle  mem    REG   0,17         0   14465 \/dev\/shm\/ora_ora11gr2_65537_23\r\noracle  1809 oracle  mem    REG   0,17         0   14466 \/dev\/shm\/ora_ora11gr2_65537_24\r\noracle  1809 oracle  mem    REG   0,17         0   14467 \/dev\/shm\/ora_ora11gr2_65537_25\r\noracle  1809 oracle  mem    REG   0,17         0   14468 \/dev\/shm\/ora_ora11gr2_65537_26\r\noracle  1809 oracle  mem    REG   0,17         0   14469 \/dev\/shm\/ora_ora11gr2_65537_27\r\noracle  1809 oracle  mem    REG   0,17         0   14470 \/dev\/shm\/ora_ora11gr2_65537_28\r\noracle  1809 oracle  mem    REG   0,17         0   14471 \/dev\/shm\/ora_ora11gr2_65537_29\r\noracle  1809 oracle  mem    REG   0,17         0   14472 \/dev\/shm\/ora_ora11gr2_65537_30\r\noracle  1809 oracle  mem    REG   0,17         0   14473 \/dev\/shm\/ora_ora11gr2_65537_31\r\noracle  1809 oracle  mem    REG   0,17         0   14474 \/dev\/shm\/ora_ora11gr2_65537_32\r\noracle  1809 oracle  mem    REG   0,17         0   14475 \/dev\/shm\/ora_ora11gr2_65537_33\r\noracle  1809 oracle  mem    REG   0,17         0   14476 \/dev\/shm\/ora_ora11gr2_65537_34\r\noracle  1809 oracle  mem    REG   0,17         0   14477 \/dev\/shm\/ora_ora11gr2_65537_35\r\noracle  1809 oracle  mem    REG   0,17         0   14478 \/dev\/shm\/ora_ora11gr2_65537_36\r\noracle  1809 oracle  mem    REG   0,17         0   14479 \/dev\/shm\/ora_ora11gr2_65537_37\r\noracle  1809 oracle  mem    REG   0,17         0   14480 \/dev\/shm\/ora_ora11gr2_65537_38\r\noracle  1809 oracle  mem    REG   0,17         0   14481 \/dev\/shm\/ora_ora11gr2_65537_39\r\noracle  1809 oracle  mem    REG   0,17         0   14482 \/dev\/shm\/ora_ora11gr2_65537_40\r\noracle  1809 oracle  mem    REG   0,17         0   14483 \/dev\/shm\/ora_ora11gr2_65537_41\r\noracle  1809 oracle  mem    REG   0,17         0   14484 \/dev\/shm\/ora_ora11gr2_65537_42\r\noracle  1809 oracle  mem    REG   0,17         0   14485 \/dev\/shm\/ora_ora11gr2_65537_43\r\noracle  1809 oracle  mem    REG   0,17         0   14486 \/dev\/shm\/ora_ora11gr2_65537_44\r\noracle  1809 oracle  mem    REG   0,17         0   14487 \/dev\/shm\/ora_ora11gr2_65537_45\r\noracle  1809 oracle  mem    REG   0,17         0   14488 \/dev\/shm\/ora_ora11gr2_65537_46\r\noracle  1809 oracle  mem    REG   0,17         0   14489 \/dev\/shm\/ora_ora11gr2_65537_47\r\noracle  1809 oracle  mem    REG   0,17         0   14490 \/dev\/shm\/ora_ora11gr2_65537_48\r\noracle  1809 oracle  mem    REG   0,17         0   14491 \/dev\/shm\/ora_ora11gr2_65537_49\r\noracle  1809 oracle  mem    REG   0,17         0   14492 \/dev\/shm\/ora_ora11gr2_65537_50\r\noracle  1809 oracle  mem    REG   0,17         0   14493 \/dev\/shm\/ora_ora11gr2_65537_51\r\noracle  1809 oracle  mem    REG   0,17         0   14494 \/dev\/shm\/ora_ora11gr2_65537_52\r\noracle  1809 oracle  mem    REG   0,17         0   14495 \/dev\/shm\/ora_ora11gr2_65537_53\r\noracle  1809 oracle  mem    REG   0,17         0   14496 \/dev\/shm\/ora_ora11gr2_65537_54\r\noracle  1809 oracle  mem    REG   0,17         0   14497 \/dev\/shm\/ora_ora11gr2_65537_55\r\noracle  1809 oracle  mem    REG   0,17         0   14498 \/dev\/shm\/ora_ora11gr2_65537_56\r\noracle  1809 oracle  mem    REG   0,17         0   14499 \/dev\/shm\/ora_ora11gr2_65537_57\r\noracle  1809 oracle  mem    REG   0,17         0   14500 \/dev\/shm\/ora_ora11gr2_65537_58\r\noracle  1809 oracle  mem    REG   0,17         0   14501 \/dev\/shm\/ora_ora11gr2_65537_59\r\noracle  1809 oracle  mem    REG   0,17         0   14502 \/dev\/shm\/ora_ora11gr2_65537_60\r\noracle  1809 oracle  mem    REG   0,17         0   14503 \/dev\/shm\/ora_ora11gr2_65537_61\r\noracle  1809 oracle  mem    REG   0,17         0   14504 \/dev\/shm\/ora_ora11gr2_65537_62\r\noracle  1809 oracle  mem    REG   0,17         0   14505 \/dev\/shm\/ora_ora11gr2_65537_63\r\noracle  1809 oracle  mem    REG   0,17         0   14506 \/dev\/shm\/ora_ora11gr2_65537_64\r\noracle  1809 oracle  mem    REG   0,17         0   14507 \/dev\/shm\/ora_ora11gr2_65537_65\r\noracle  1809 oracle  mem    REG   0,17         0   14508 \/dev\/shm\/ora_ora11gr2_65537_66\r\noracle  1809 oracle  mem    REG   0,17         0   14509 \/dev\/shm\/ora_ora11gr2_65537_67\r\noracle  1809 oracle  mem    REG   0,17         0   14510 \/dev\/shm\/ora_ora11gr2_65537_68\r\noracle  1809 oracle  mem    REG   0,17         0   14511 \/dev\/shm\/ora_ora11gr2_65537_69\r\noracle  1809 oracle  mem    REG   0,17         0   14512 \/dev\/shm\/ora_ora11gr2_65537_70\r\noracle  1809 oracle  mem    REG   0,17         0   14513 \/dev\/shm\/ora_ora11gr2_65537_71\r\noracle  1809 oracle  mem    REG   0,17         0   14514 \/dev\/shm\/ora_ora11gr2_65537_72\r\noracle  1809 oracle  mem    REG   0,17         0   14515 \/dev\/shm\/ora_ora11gr2_65537_73\r\noracle  1809 oracle  mem    REG   0,17         0   14516 \/dev\/shm\/ora_ora11gr2_65537_74\r\noracle  1809 oracle  mem    REG   0,17         0   14517 \/dev\/shm\/ora_ora11gr2_65537_75\r\noracle  1809 oracle  mem    REG   0,17         0   14518 \/dev\/shm\/ora_ora11gr2_65537_76\r\noracle  1809 oracle  mem    REG   0,17         0   14519 \/dev\/shm\/ora_ora11gr2_65537_77\r\noracle  1809 oracle  mem    REG   0,17         0   14520 \/dev\/shm\/ora_ora11gr2_65537_78\r\noracle  1809 oracle  mem    REG   0,17         0   14521 \/dev\/shm\/ora_ora11gr2_65537_79\r\noracle  1809 oracle  mem    REG   0,17         0   14522 \/dev\/shm\/ora_ora11gr2_65537_80\r\noracle  1809 oracle  mem    REG   0,17         0   14523 \/dev\/shm\/ora_ora11gr2_65537_81\r\noracle  1809 oracle  mem    REG   0,17         0   14524 \/dev\/shm\/ora_ora11gr2_65537_82\r\noracle  1809 oracle  mem    REG   0,17         0   14525 \/dev\/shm\/ora_ora11gr2_65537_83\r\noracle  1809 oracle  mem    REG   0,17         0   14526 \/dev\/shm\/ora_ora11gr2_65537_84\r\noracle  1809 oracle  mem    REG   0,17         0   14527 \/dev\/shm\/ora_ora11gr2_65537_85\r\noracle  1809 oracle  mem    REG   0,17         0   14528 \/dev\/shm\/ora_ora11gr2_65537_86\r\noracle  1809 oracle  mem    REG   0,17         0   14529 \/dev\/shm\/ora_ora11gr2_65537_87\r\noracle  1809 oracle  mem    REG   0,17         0   14530 \/dev\/shm\/ora_ora11gr2_65537_88\r\noracle  1809 oracle  mem    REG   0,17         0   14531 \/dev\/shm\/ora_ora11gr2_65537_89\r\noracle  1809 oracle  mem    REG   0,17   4194304   14532 \/dev\/shm\/ora_ora11gr2_65537_90\r\noracle  1809 oracle  mem    REG   0,17   4194304   14533 \/dev\/shm\/ora_ora11gr2_65537_91\r\noracle  1809 oracle  mem    REG   0,17   4194304   14534 \/dev\/shm\/ora_ora11gr2_65537_92\r\noracle  1809 oracle  mem    REG   0,17   4194304   14535 \/dev\/shm\/ora_ora11gr2_65537_93\r\noracle  1809 oracle  mem    REG   0,17   4194304   14536 \/dev\/shm\/ora_ora11gr2_65537_94\r\noracle  1809 oracle  mem    REG   0,17   4194304   14537 \/dev\/shm\/ora_ora11gr2_65537_95\r\noracle  1809 oracle  mem    REG   0,17   4194304   14538 \/dev\/shm\/ora_ora11gr2_65537_96\r\noracle  1809 oracle  mem    REG   0,17   4194304   14539 \/dev\/shm\/ora_ora11gr2_65537_97\r\noracle  1809 oracle  mem    REG   0,17   4194304   14540 \/dev\/shm\/ora_ora11gr2_65537_98\r\noracle  1809 oracle  mem    REG   0,17   4194304   14541 \/dev\/shm\/ora_ora11gr2_65537_99\r\noracle  1809 oracle  mem    REG   0,17   4194304   14542 \/dev\/shm\/ora_ora11gr2_65537_100\r\noracle  1809 oracle  mem    REG   0,17   4194304   14543 \/dev\/shm\/ora_ora11gr2_65537_101\r\noracle  1809 oracle  mem    REG   0,17   4194304   14544 \/dev\/shm\/ora_ora11gr2_65537_102\r\noracle  1809 oracle  mem    REG   0,17   4194304   14545 \/dev\/shm\/ora_ora11gr2_65537_103\r\noracle  1809 oracle  mem    REG   0,17   4194304   14546 \/dev\/shm\/ora_ora11gr2_65537_104\r\noracle  1809 oracle  mem    REG   0,17   4194304   14547 \/dev\/shm\/ora_ora11gr2_65537_105\r\noracle  1809 oracle  mem    REG   0,17   4194304   14548 \/dev\/shm\/ora_ora11gr2_65537_106\r\noracle  1809 oracle  mem    REG   0,17   4194304   14549 \/dev\/shm\/ora_ora11gr2_65537_107\r\noracle  1809 oracle  mem    REG   0,17   4194304   14550 \/dev\/shm\/ora_ora11gr2_65537_108\r\noracle  1809 oracle  mem    REG   0,17   4194304   14551 \/dev\/shm\/ora_ora11gr2_65537_109\r\noracle  1809 oracle  mem    REG   0,17   4194304   14552 \/dev\/shm\/ora_ora11gr2_65537_110\r\noracle  1809 oracle  mem    REG   0,17   4194304   14553 \/dev\/shm\/ora_ora11gr2_65537_111\r\noracle  1809 oracle  mem    REG   0,17   4194304   14554 \/dev\/shm\/ora_ora11gr2_65537_112\r\noracle  1809 oracle  mem    REG   0,17   4194304   14555 \/dev\/shm\/ora_ora11gr2_65537_113\r\noracle  1809 oracle  mem    REG   0,17   4194304   14556 \/dev\/shm\/ora_ora11gr2_65537_114\r\noracle  1809 oracle  mem    REG   0,17   4194304   14557 \/dev\/shm\/ora_ora11gr2_65537_115\r\noracle  1809 oracle  mem    REG   0,17   4194304   14558 \/dev\/shm\/ora_ora11gr2_65537_116\r\noracle  1809 oracle  mem    REG   0,17   4194304   14559 \/dev\/shm\/ora_ora11gr2_65537_117\r\noracle  1809 oracle  mem    REG   0,17   4194304   14560 \/dev\/shm\/ora_ora11gr2_65537_118\r\noracle  1809 oracle  mem    REG   0,17   4194304   14561 \/dev\/shm\/ora_ora11gr2_65537_119\r\noracle  1809 oracle  mem    REG   0,17   4194304   14562 \/dev\/shm\/ora_ora11gr2_65537_120\r\noracle  1809 oracle  mem    REG   0,17   4194304   14563 \/dev\/shm\/ora_ora11gr2_65537_121\r\noracle  1809 oracle  mem    REG   0,17   4194304   14564 \/dev\/shm\/ora_ora11gr2_65537_122\r\noracle  1809 oracle  mem    REG   0,17   4194304   14565 \/dev\/shm\/ora_ora11gr2_65537_123\r\noracle  1809 oracle  mem    REG   0,17   4194304   14566 \/dev\/shm\/ora_ora11gr2_65537_124\r\noracle  1809 oracle  mem    REG   0,17   4194304   14567 \/dev\/shm\/ora_ora11gr2_65537_125\r\noracle  1809 oracle  mem    REG   0,17   4194304   14568 \/dev\/shm\/ora_ora11gr2_65537_126\r\noracle  1809 oracle  mem    REG   0,17   4194304   14569 \/dev\/shm\/ora_ora11gr2_65537_127\r\noracle  1809 oracle  mem    REG   0,17   4194304   14570 \/dev\/shm\/ora_ora11gr2_65537_128\r\noracle  1809 oracle  mem    REG   0,17   4194304   14571 \/dev\/shm\/ora_ora11gr2_65537_129\r\noracle  1809 oracle  mem    REG   0,17   4194304   14572 \/dev\/shm\/ora_ora11gr2_65537_130\r\noracle  1809 oracle  mem    REG   0,17   4194304   14573 \/dev\/shm\/ora_ora11gr2_65537_131\r\noracle  1809 oracle  mem    REG   0,17   4194304   14574 \/dev\/shm\/ora_ora11gr2_65537_132\r\noracle  1809 oracle  mem    REG   0,17   4194304   14575 \/dev\/shm\/ora_ora11gr2_65537_133\r\noracle  1809 oracle  mem    REG   0,17   4194304   14576 \/dev\/shm\/ora_ora11gr2_65537_134\r\noracle  1809 oracle  mem    REG   0,17   4194304   14577 \/dev\/shm\/ora_ora11gr2_65537_135\r\noracle  1809 oracle  mem    REG   0,17   4194304   14578 \/dev\/shm\/ora_ora11gr2_65537_136\r\noracle  1809 oracle  mem    REG   0,17   4194304   14579 \/dev\/shm\/ora_ora11gr2_65537_137\r\noracle  1809 oracle  mem    REG   0,17   4194304   14580 \/dev\/shm\/ora_ora11gr2_65537_138\r\noracle  1809 oracle  mem    REG   0,17   4194304   14581 \/dev\/shm\/ora_ora11gr2_65537_139\r\noracle  1809 oracle  mem    REG   0,17   4194304   14582 \/dev\/shm\/ora_ora11gr2_65537_140\r\noracle  1809 oracle  mem    REG   0,17   4194304   14583 \/dev\/shm\/ora_ora11gr2_65537_141\r\noracle  1809 oracle  mem    REG   0,17   4194304   14584 \/dev\/shm\/ora_ora11gr2_65537_142\r\noracle  1809 oracle  mem    REG   0,17   4194304   14585 \/dev\/shm\/ora_ora11gr2_65537_143\r\noracle  1809 oracle  mem    REG   0,17   4194304   14586 \/dev\/shm\/ora_ora11gr2_65537_144\r\noracle  1809 oracle  mem    REG   0,17   4194304   14587 \/dev\/shm\/ora_ora11gr2_65537_145\r\noracle  1809 oracle  mem    REG   0,17   4194304   14588 \/dev\/shm\/ora_ora11gr2_65537_146\r\noracle  1809 oracle  mem    REG   0,17   4194304   14589 \/dev\/shm\/ora_ora11gr2_65537_147\r\noracle  1809 oracle  mem    REG   0,17   4194304   14590 \/dev\/shm\/ora_ora11gr2_65537_148\r\noracle  1809 oracle  mem    REG   0,17   4194304   14591 \/dev\/shm\/ora_ora11gr2_65537_149\r\noracle  1809 oracle  mem    REG   0,17   4194304   14592 \/dev\/shm\/ora_ora11gr2_65537_150\r\noracle  1809 oracle  mem    REG   0,17   4194304   14593 \/dev\/shm\/ora_ora11gr2_65537_151\r\noracle  1809 oracle  mem    REG   0,17   4194304   14594 \/dev\/shm\/ora_ora11gr2_65537_152\r\noracle  1809 oracle  mem    REG   0,17   4194304   14595 \/dev\/shm\/ora_ora11gr2_65537_153\r\noracle  1809 oracle  mem    REG   0,17   4194304   14596 \/dev\/shm\/ora_ora11gr2_65537_154\r\noracle  1809 oracle  mem    REG   0,17   4194304   14597 \/dev\/shm\/ora_ora11gr2_65537_155\r\noracle  1809 oracle  mem    REG   0,17   4194304   14598 \/dev\/shm\/ora_ora11gr2_65537_156\r\noracle  1809 oracle  mem    REG   0,17   4194304   14599 \/dev\/shm\/ora_ora11gr2_65537_157\r\noracle  1809 oracle  mem    REG   0,17   4194304   14600 \/dev\/shm\/ora_ora11gr2_65537_158\r\noracle  1809 oracle  mem    REG   0,17   4194304   14601 \/dev\/shm\/ora_ora11gr2_65537_159\r\noracle  1809 oracle  mem    REG   0,17   4194304   14602 \/dev\/shm\/ora_ora11gr2_65537_160\r\noracle  1809 oracle  mem    REG   0,17   4194304   14603 \/dev\/shm\/ora_ora11gr2_65537_161\r\noracle  1809 oracle  mem    REG   0,17   4194304   14604 \/dev\/shm\/ora_ora11gr2_65537_162\r\noracle  1809 oracle  mem    REG   0,17   4194304   14605 \/dev\/shm\/ora_ora11gr2_65537_163\r\noracle  1809 oracle  mem    REG   0,17   4194304   14606 \/dev\/shm\/ora_ora11gr2_65537_164\r\noracle  1809 oracle  mem    REG   0,17   4194304   14607 \/dev\/shm\/ora_ora11gr2_65537_165\r\noracle  1809 oracle  mem    REG   0,17   4194304   14608 \/dev\/shm\/ora_ora11gr2_65537_166\r\noracle  1809 oracle  mem    REG   0,17   4194304   14609 \/dev\/shm\/ora_ora11gr2_65537_167\r\noracle  1809 oracle  mem    REG   0,17   4194304   14610 \/dev\/shm\/ora_ora11gr2_65537_168\r\noracle  1809 oracle  mem    REG   0,17   4194304   14611 \/dev\/shm\/ora_ora11gr2_65537_169\r\noracle  1809 oracle  mem    REG   0,17   4194304   14612 \/dev\/shm\/ora_ora11gr2_65537_170\r\noracle  1809 oracle  mem    REG   0,17   4194304   14613 \/dev\/shm\/ora_ora11gr2_65537_171\r\noracle  1809 oracle  mem    REG   0,17   4194304   14614 \/dev\/shm\/ora_ora11gr2_65537_172\r\noracle  1809 oracle  mem    REG   0,17   4194304   14615 \/dev\/shm\/ora_ora11gr2_65537_173\r\noracle  1809 oracle  mem    REG   0,17   4194304   14616 \/dev\/shm\/ora_ora11gr2_65537_174\r\noracle  1809 oracle  mem    REG   0,17   4194304   14617 \/dev\/shm\/ora_ora11gr2_65537_175\r\noracle  1809 oracle  mem    REG   0,17   4194304   14618 \/dev\/shm\/ora_ora11gr2_65537_176\r\noracle  1809 oracle  mem    REG   0,17   4194304   14619 \/dev\/shm\/ora_ora11gr2_65537_177\r\noracle  1809 oracle  mem    REG   0,17   4194304   14620 \/dev\/shm\/ora_ora11gr2_65537_178\r\noracle  1809 oracle  mem    REG   0,17   4194304   14621 \/dev\/shm\/ora_ora11gr2_65537_179\r\noracle  1809 oracle  mem    REG   0,17   4194304   14622 \/dev\/shm\/ora_ora11gr2_65537_180\r\noracle  1809 oracle  mem    REG   0,17   4194304   14623 \/dev\/shm\/ora_ora11gr2_65537_181\r\noracle  1809 oracle  mem    REG   0,17   4194304   14624 \/dev\/shm\/ora_ora11gr2_65537_182\r\noracle  1809 oracle  mem    REG   0,17   4194304   14625 \/dev\/shm\/ora_ora11gr2_65537_183\r\noracle  1809 oracle  mem    REG   0,17   4194304   14626 \/dev\/shm\/ora_ora11gr2_65537_184\r\noracle  1809 oracle  mem    REG   0,17   4194304   14627 \/dev\/shm\/ora_ora11gr2_65537_185\r\noracle  1809 oracle  mem    REG   0,17   4194304   14628 \/dev\/shm\/ora_ora11gr2_65537_186\r\noracle  1809 oracle  mem    REG   0,17   4194304   14629 \/dev\/shm\/ora_ora11gr2_65537_187\r\noracle  1809 oracle  mem    REG   0,17   4194304   14630 \/dev\/shm\/ora_ora11gr2_65537_188\r\noracle  1809 oracle  mem    REG   0,17   4194304   14631 \/dev\/shm\/ora_ora11gr2_65537_189\r\noracle  1809 oracle  mem    REG   0,17   4194304   14632 \/dev\/shm\/ora_ora11gr2_65537_190\r\noracle  1809 oracle  mem    REG   0,17   4194304   14633 \/dev\/shm\/ora_ora11gr2_65537_191\r\noracle  1809 oracle  mem    REG   0,17   4194304   14634 \/dev\/shm\/ora_ora11gr2_65537_192\r\noracle  1809 oracle  mem    REG   0,17   4194304   14635 \/dev\/shm\/ora_ora11gr2_65537_193\r\noracle  1809 oracle  mem    REG   0,17   4194304   14636 \/dev\/shm\/ora_ora11gr2_65537_194\r\noracle  1809 oracle  mem    REG   0,17   4194304   14637 \/dev\/shm\/ora_ora11gr2_65537_195\r\noracle  1809 oracle  mem    REG   0,17   4194304   14638 \/dev\/shm\/ora_ora11gr2_65537_196\r\noracle  1809 oracle  mem    REG   0,17   4194304   14639 \/dev\/shm\/ora_ora11gr2_65537_197\r\noracle  1809 oracle  mem    REG   0,17   4194304   14640 \/dev\/shm\/ora_ora11gr2_65537_198\r\noracle  1809 oracle  mem    REG   0,17   4194304   14641 \/dev\/shm\/ora_ora11gr2_65537_199\r\noracle  1809 oracle  mem    REG   0,17   4194304   14642 \/dev\/shm\/ora_ora11gr2_65537_200\r\noracle  1809 oracle  mem    REG   0,17   4194304   14643 \/dev\/shm\/ora_ora11gr2_65537_201\r\noracle  1809 oracle  mem    REG   0,17   4194304   14644 \/dev\/shm\/ora_ora11gr2_65537_202\r\noracle  1809 oracle  mem    REG   0,17   4194304   14645 \/dev\/shm\/ora_ora11gr2_65537_203\r\noracle  1809 oracle  mem    REG   0,17   4194304   14646 \/dev\/shm\/ora_ora11gr2_65537_204\r\noracle  1809 oracle  mem    REG   0,17   4194304   14647 \/dev\/shm\/ora_ora11gr2_65537_205\r\noracle  1809 oracle  mem    REG   0,17   4194304   14648 \/dev\/shm\/ora_ora11gr2_65537_206\r\noracle  1809 oracle  mem    REG   0,17   4194304   14649 \/dev\/shm\/ora_ora11gr2_65537_207\r\noracle  1809 oracle  mem    REG   0,17   4194304   14650 \/dev\/shm\/ora_ora11gr2_65537_208\r\noracle  1809 oracle  mem    REG   0,17   4194304   14651 \/dev\/shm\/ora_ora11gr2_65537_209\r\noracle  1809 oracle  mem    REG   0,17   4194304   14652 \/dev\/shm\/ora_ora11gr2_65537_210\r\noracle  1809 oracle  mem    REG   0,17   4194304   14653 \/dev\/shm\/ora_ora11gr2_65537_211\r\noracle  1809 oracle  mem    REG   0,17   4194304   14654 \/dev\/shm\/ora_ora11gr2_65537_212\r\noracle  1809 oracle  mem    REG   0,17   4194304   14655 \/dev\/shm\/ora_ora11gr2_65537_213\r\noracle  1809 oracle  mem    REG   0,17   4194304   14656 \/dev\/shm\/ora_ora11gr2_65537_214\r\noracle  1809 oracle  mem    REG   0,17   4194304   14657 \/dev\/shm\/ora_ora11gr2_65537_215\r\noracle  1809 oracle  mem    REG   0,17   4194304   14658 \/dev\/shm\/ora_ora11gr2_65537_216\r\noracle  1809 oracle  mem    REG   0,17   4194304   14659 \/dev\/shm\/ora_ora11gr2_65537_217\r\noracle  1809 oracle  mem    REG   0,17   4194304   14660 \/dev\/shm\/ora_ora11gr2_65537_218\r\noracle  1809 oracle  mem    REG   0,17   4194304   14661 \/dev\/shm\/ora_ora11gr2_65537_219\r\noracle  1809 oracle  mem    REG   0,17   4194304   14662 \/dev\/shm\/ora_ora11gr2_65537_220\r\noracle  1809 oracle  mem    REG   0,17   4194304   14663 \/dev\/shm\/ora_ora11gr2_65537_221\r\noracle  1809 oracle  mem    REG   0,17   4194304   14666 \/dev\/shm\/ora_ora11gr2_98306_0\r\noracle  1809 oracle  mem    REG    8,3    150672  654453 \/lib64\/ld-2.12.so\r\noracle  1809 oracle  mem    REG    8,3      5624  654218 \/lib64\/libaio.so.1.0.1\r\noracle  1809 oracle  mem    REG    8,3   1838296  654454 \/lib64\/libc-2.12.so\r\noracle  1809 oracle  mem    REG    8,3    145672  654462 \/lib64\/libpthread-2.12.so\r\noracle  1809 oracle  mem    REG    8,3    598816  654469 \/lib64\/libm-2.12.so\r\noracle  1809 oracle  mem    REG    8,3     47072  654466 \/lib64\/librt-2.12.so\r\noracle  1809 oracle  mem    REG    8,3     35752 1453157 \/usr\/lib64\/libnuma.so.1\r\noracle  1809 oracle  mem    REG    8,3    116136  654491 \/lib64\/libnsl-2.12.so\r\noracle  1809 oracle  mem    CHR    1,5              3739 \/dev\/zero\r\noracle  1809 oracle  mem    REG    8,3      1544 1050855 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/hc_ora11gr2.dat\r\noracle  1809 oracle  mem    REG    8,3     61624  654110 \/lib64\/libnss_files-2.12.so\r\noracle  1809 oracle  mem    REG    8,3     22536  654456 \/lib64\/libdl-2.12.so\r\noracle  1809 oracle  mem    REG    8,3    153574 1066413 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libocrutl11.so\r\noracle  1809 oracle  mem    REG    8,3   3319072 1066412 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libocrb11.so\r\noracle  1809 oracle  mem    REG    8,3   1590995 1066411 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libocr11.so\r\noracle  1809 oracle  mem    REG    8,3     12755 1051572 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libskgxn2.so\r\noracle  1809 oracle  mem    REG    8,3  17319952 1066379 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libhasgen11.so\r\noracle  1809 oracle  mem    REG    8,3    161764 1051337 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libdbcfg11.so\r\noracle  1809 oracle  mem    REG    8,3    228765 1066381 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libclsra11.so\r\noracle  1809 oracle  mem    REG    8,3   7955322 1066638 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libnnz11.so\r\noracle  1809 oracle  mem    REG    8,3   1010297 1049728 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libskgxp11.so\r\noracle  1809 oracle  mem    REG    8,3    589359 1066818 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libcell11.so\r\noracle  1809 oracle  mem    REG    8,3     12259 1048574 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libodmd11.so\r\noracle  1809 oracle    0r   CHR    1,3       0t0    3737 \/dev\/null\r\noracle  1809 oracle    1w   CHR    1,3       0t0    3737 \/dev\/null\r\noracle  1809 oracle    2w   CHR    1,3       0t0    3737 \/dev\/null\r\noracle  1809 oracle    3r   CHR    1,3       0t0    3737 \/dev\/null\r\noracle  1809 oracle    4r   CHR    1,3       0t0    3737 \/dev\/null\r\noracle  1809 oracle    5u   REG    8,3      1544 1050855 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/hc_ora11gr2.dat\r\noracle  1809 oracle    6r   CHR    1,3       0t0    3737 \/dev\/null\r\noracle  1809 oracle    7r   CHR    1,3       0t0    3737 \/dev\/null\r\noracle  1809 oracle    8r   CHR    1,3       0t0    3737 \/dev\/null\r\noracle  1809 oracle    9r   CHR    1,3       0t0    3737 \/dev\/null\r\noracle  1809 oracle   10r   CHR    1,5       0t0    3739 \/dev\/zero\r\noracle  1809 oracle   11r   CHR    1,5       0t0    3739 \/dev\/zero\r\noracle  1809 oracle   12u   REG    8,3      1544 1050855 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/hc_ora11gr2.dat\r\noracle  1809 oracle   13r   REG    8,3   1101312 1584371 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/rdbms\/mesg\/oraus.msb\r\noracle  1809 oracle   14r   DIR    0,3         0   14854 \/proc\/1809\/fd\r\noracle  1809 oracle   15r   CHR    1,5       0t0    3739 \/dev\/zero\r\noracle  1809 oracle   16u   REG    8,3      1544 1050855 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/hc_ora11gr2.dat\r\noracle  1809 oracle   17uR  REG    8,3        24 1049647 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/lkORA11GR2\r\noracle  1809 oracle   18r   REG    8,3   1101312 1584371 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/rdbms\/mesg\/oraus.msb\r\noracle  1809 oracle  256u   REG    8,3   9748480 1177382 \/u01\/app\/oracle\/oradata\/ora11gr2\/control01.ctl\r\noracle  1809 oracle  257u   REG    8,3   9748480 1177383 \/u01\/app\/oracle\/fast_recovery_area\/ora11gr2\/control02.ctl\r\noracle  1809 oracle  258uW  REG    8,3 734011392 1177387 \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\noracle  1809 oracle  259uW  REG    8,3 629153792 1177388 \/u01\/app\/oracle\/oradata\/ora11gr2\/sysaux01.dbf\r\noracle  1809 oracle  260uW  REG    8,3 325066752 1177389 \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf\r\noracle  1809 oracle  261uW  REG    8,3   5251072 1177393 \/u01\/app\/oracle\/oradata\/ora11gr2\/users01.dbf\r\noracle  1809 oracle  262uW  REG    8,3  62922752 1177390 \/u01\/app\/oracle\/oradata\/ora11gr2\/temp01.dbf\r\noracle  1809 oracle  263uW  REG    8,3  10493952 1177433 \/u01\/testdir\/yallonking01.dbf (deleted)    &lt;&lt;\u6b64\u5904\u4e3a\u5220\u9664\u6587\u4ef6\u7684\u4fe1\u606f\r\n<\/pre>\n<p>\u6b64\u5904\u67e5\u5230\u7684\u662f<strong>263<\/strong>\uff0c\u4e14\u5df2\u7ecf\u88ab\u6807\u8bb0\u4e3a\u5220\u9664\u3002<\/p>\n<p>\u5c06\u5df2\u5220\u9664\u7684\u6587\u4ef6\uff08\u5728OS\u7ea7\u522b\u88ab\u6807\u8bb0\u4e3a\u5220\u9664\uff0c\u4f46\u662f\u5728OS\u4e0a\u5e76\u672a\u771f\u6b63\u5220\u9664\uff0c\u53ef\u901a\u8fc7\u6587\u4ef6\u63cf\u8ff0\u7b26\u627e\u5230\u8be5\u6587\u4ef6\uff09\u62f7\u8d1d\u5230\u65b0\u76ee\u5f55\u4e0b\u8fdb\u884c\u6062\u590d<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@rhl6 ~]$ ps -ef | grep dbw | grep -v grep\r\noracle    1809     1  0 14:38 ?        00:00:00 ora_dbw0_ora11gr2\r\n[oracle@rhl6 ~]$ ls -l \/proc\/1809\/fd\r\ntotal 0\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 0 -&gt; \/dev\/null\r\nl-wx------. 1 oracle oinstall 64 Jul 16 14:57 1 -&gt; \/dev\/null\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 10 -&gt; \/dev\/zero\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 11 -&gt; \/dev\/zero\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 12 -&gt; \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/hc_ora11gr2.dat\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 13 -&gt; \/u01\/app\/oracle\/product\/11.2.0\/db_1\/rdbms\/mesg\/oraus.msb\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 14 -&gt; \/proc\/1809\/fd\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 15 -&gt; \/dev\/zero\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 16 -&gt; \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/hc_ora11gr2.dat\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 17 -&gt; \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/lkORA11GR2\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 18 -&gt; \/u01\/app\/oracle\/product\/11.2.0\/db_1\/rdbms\/mesg\/oraus.msb\r\nl-wx------. 1 oracle oinstall 64 Jul 16 14:57 2 -&gt; \/dev\/null\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 256 -&gt; \/u01\/app\/oracle\/oradata\/ora11gr2\/control01.ctl\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 257 -&gt; \/u01\/app\/oracle\/fast_recovery_area\/ora11gr2\/control02.ctl\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 258 -&gt; \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 259 -&gt; \/u01\/app\/oracle\/oradata\/ora11gr2\/sysaux01.dbf\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 260 -&gt; \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 261 -&gt; \/u01\/app\/oracle\/oradata\/ora11gr2\/users01.dbf\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 262 -&gt; \/u01\/app\/oracle\/oradata\/ora11gr2\/temp01.dbf\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 263 -&gt; \/u01\/testdir\/yallonking01.dbf (deleted)\t\t\t\t&lt;&lt;\u8be5\u884c\u4f1a\u95ea\u52a8\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 3 -&gt; \/dev\/null\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 4 -&gt; \/dev\/null\r\nlrwx------. 1 oracle oinstall 64 Jul 16 14:57 5 -&gt; \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/hc_ora11gr2.dat\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 6 -&gt; \/dev\/null\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 7 -&gt; \/dev\/null\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 8 -&gt; \/dev\/null\r\nlr-x------. 1 oracle oinstall 64 Jul 16 14:57 9 -&gt; \/dev\/null\r\n<\/pre>\n<p><strong>\u6ce8\u610f\uff1a\u8be5\u5904\u4e5f\u8fdb\u4e00\u6b65\u8bf4\u660e\u5220\u9664\u7684\u6587\u4ef6\u53f7\u662f263.<\/strong><\/p>\n<p>\u6839\u636e\u6587\u4ef6\u53f7\u6216\u8005\u4e0a\u8fb9\u7684\u8f93\u51fa\u5c06\u6587\u4ef6\u62f7\u8d1d\u81f3\u65b0\u7684\u4f4d\u7f6e<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@rhl6 ~]$ cp \/proc\/1809\/fd\/263 \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\nSQL&gt; conn \/as sysdba\r\nConnected.\r\nSQL&gt; alter database datafile 5 offline;\r\nalter database datafile 5 offline\r\n*\r\nERROR at line 1:\r\nORA-01145: offline immediate disallowed unless media recovery enabled\r\n\r\n\r\nSQL&gt; archive log list;\r\nDatabase log mode              No Archive Mode\r\nAutomatic archival             Disabled\r\nArchive destination            USE_DB_RECOVERY_FILE_DEST\r\nOldest online log sequence     66\r\nCurrent log sequence           68\r\nSQL&gt; alter database datafile 5 offline drop;\r\n\r\nDatabase altered.\r\n<\/pre>\n<p>\u6ce8\u610f\uff1a\u7531\u4e8e\u662f\u5728\u975e\u5f52\u6863\u6a21\u5f0f\u4e0b\uff0c\u6545\u5355\u4e00\u7684\u5c06\u6570\u636e\u6587\u4ef6offline\u4f1a\u62a5\u9519\u3002<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; alter database rename file &#039;\/u01\/testdir\/yallonking01.dbf&#039; to &#039;\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf&#039;;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; recover datafile 5;\r\nMedia recovery complete.\r\nSQL&gt; alter database datafile 5 online;\r\n\r\nDatabase altered.\r\n<\/pre>\n<p>\u6062\u590d\u540e\u9a8c\u8bc1<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; alter session set nls_date_format=&#039;yyyy\/mm\/dd hh24:mi:ss&#039;;    \r\n\r\nSession altered.\r\n\r\nSQL&gt; select * from yallonking.yallonking;\r\n\r\n        ID NAME                                               MY_DATE\r\n---------- -------------------------------------------------- -------------------\r\n         1 yallonking                                         2013\/07\/16 14:47:28\r\n\r\nSQL&gt; alter system flush BUFFER_CACHE;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; select * from yallonking.yallonking;\r\n\r\n        ID NAME                                               MY_DATE\r\n---------- -------------------------------------------------- -------------------\r\n         1 yallonking                                         2013\/07\/16 14:47:28\r\n<\/pre>\n<p>\u64cd\u4f5c\u65e5\u5fd7\u5982\u4e0b<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nTue Jul 16 15:07:22 2013\r\nalter database datafile 5 offline\r\nORA-1145 signalled during: alter database datafile 5 offline...\r\nTue Jul 16 15:07:59 2013\r\nalter database datafile 5 offline drop\r\nCompleted: alter database datafile 5 offline drop\r\nTue Jul 16 15:08:27 2013\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_m001_2249.trc:\r\nORA-01135: file 5 accessed for DML\/query is offline\r\nORA-01110: data file 5: &#039;\/u01\/testdir\/yallonking01.dbf&#039;\r\nTue Jul 16 15:09:05 2013\r\nalter database rename file &#039;\/u01\/testdir\/yallonking01.dbf&#039; to &#039;\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf&#039;\r\nCompleted: alter database rename file &#039;\/u01\/testdir\/yallonking01.dbf&#039; to &#039;\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf&#039;\r\nTue Jul 16 15:09:20 2013\r\nALTER DATABASE RECOVER  datafile 5  \r\nMedia Recovery Start\r\nSerial Media Recovery started\r\nRecovery of Online Redo Log: Thread 1 Group 2 Seq 68 Reading mem 0\r\n  Mem# 0: \/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log\r\nMedia Recovery Complete (ora11gr2)\r\nCompleted: ALTER DATABASE RECOVER  datafile 5  \r\nTue Jul 16 15:09:33 2013\r\nalter database datafile 5 online\r\nCompleted: alter database datafile 5 online\r\nTue Jul 16 15:11:39 2013\r\nALTER SYSTEM: Flushing buffer cache\r\n<\/pre>\n<p>\u81f3\u6b64\uff0c\u6062\u590dOK\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e0b\u8fb9\u7684\u4f8b\u5b50\u662f\u6570\u636e\u5e93\u59cb\u7ec8\u5728\u542f\u52a8\u72b6\u6001\u4e0b\uff0c\u901a\u8fc7\u64cd\u4f5c\u7cfb\u7edf\u6587\u4ef6\u63cf\u8ff0\u7b26\u6062\u590d\u8bef\u5220\u9664\u7684\u6570\u636e\u5e93\u7684\u6570\u636e\u6587\u4ef6\u3002 \u6062\u590d\u6761\u4ef6\uff1a\u6570\u636e\u5e93\u59cb\u7ec8 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[215,124],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/930"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=930"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/930\/revisions"}],"predecessor-version":[{"id":932,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/930\/revisions\/932"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=930"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}