資源描述:
《linuxrm誤刪除數(shù)據(jù)庫(kù)文件的恢復(fù)方法.doc》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在工程資料-天天文庫(kù)。
1、1.首先測(cè)試rm誤刪除數(shù)據(jù)庫(kù)文件[oracle@primarydbwdn]$lltotal2153164-rw-r-----1oracledba8536064Nov2721:50control01.ctl-rw-r-----1oracledba8536064Nov2721:50control02.ctl-rw-r-----1oracledba8536064Nov2721:50control03.ctl-rw-r-----1oracledba104865792Nov2721:32ggs01.dbf-rw-r-----1oracledba525344768Nov2721:32perfsta
2、t.dbf-rw-r-----1oracledba52429312Nov2721:10redo01.log-rw-r-----1oracledba52429312Nov2721:49redo02.log-rw-r-----1oracledba52429312Nov2721:10redo03.log-rw-r-----1oracledba10493952Nov2721:32shkz_data_01.dbf-rw-r-----1oracledba524296192Nov2721:49sysaux01.dbf-rw-r-----1oracledba524296192Nov2721:49sys
3、tem01.dbf-rw-r-----1oracledba209723392Nov1810:54temp01.dbf-rw-r-----1oracledba52436992Nov2721:32test01.dbf-rw-r-----1oracledba251666432Nov2721:49undotbs01.dbf-rw-r-----1oracledba26222592Nov2721:32users01.dbf[oracle@primarydbwdn]$rmtest01.dbf2.找到數(shù)據(jù)庫(kù)后臺(tái)進(jìn)程dbw0oracle34931021:10?00:00:00ora_dbw0_dbwdn
4、進(jìn)程號(hào)34933.找到被誤刪除的數(shù)據(jù)庫(kù)文件[oracle@primarydbwdn]$ll/proc/3493/fdtotal0lr-x------1oracleoinstall64Nov2721:520->/dev/nulllr-x------1oracleoinstall64Nov2721:521->/dev/nulllr-x------1oracleoinstall64Nov2721:5210->/dev/zerolr-x------1oracleoinstall64Nov2721:5211->/dev/zerolr-x------1oracleoinstall64Nov2721
5、:5212->/u01/app/oracle/product/10.2.0/db_1/rdbms/mesg/oraus.msblrwx------1oracleoinstall64Nov2721:5213->/u01/app/oracle/product/10.2.0/db_1/dbs/hc_dbwdn.datlrwx------1oracleoinstall64Nov2721:5214->/u01/app/oracle/product/10.2.0/db_1/dbs/lkDBWDNlrwx------1oracleoinstall64Nov2721:5215->/u01/app/or
6、acle/oradata/dbwdn/control01.ctllrwx------1oracleoinstall64Nov2721:5216->/u01/app/oracle/oradata/dbwdn/control02.ctllrwx------1oracleoinstall64Nov2721:5217->/u01/app/oracle/oradata/dbwdn/control03.ctllrwx------1oracleoinstall64Nov2721:5218->/u01/app/oracle/oradata/dbwdn/system01.dbflrwx------1or
7、acleoinstall64Nov2721:5219->/u01/app/oracle/oradata/dbwdn/undotbs01.dbflr-x------1oracleoinstall64Nov2721:522->/dev/nulllrwx------1oracleoinstall64Nov2721:5220->/u01/app/oracle/oradata/dbwdn/sysaux01.dbflrwx------1oracleoins