| 澶辨晥閾炬帴澶勭悊 |
|
涓€涓《綰BA鐨勮嚜鎴戜慨鍏?PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1K-2GP-LE9NU3hq_snXyb7Q
鎻愬彇鐮侊細(xì)inh0
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
1.1.鍧氬喅涓嶅湪鏈嶅姟鍣ㄤ笂鐩存帴鎵ц RM 鎿嶄綔
褰撴湁鏂囦歡闇€瑕佸垹闄ゆ椂錛屾妸榪欎簺鏂囦歡 MV 鍒頒竴涓瀹氱殑鏂囦歡澶癸紝鐒跺悗 CD 榪涘叆姝ゆ枃浠跺す鍐?/div>
榪涜鍒犻櫎鎿嶄綔銆?/div>
1.2.涓嶇洿鎺ュ湪鐢熶駭搴撲笂鍋氭病鏈夌粡榪囧弽澶嶆祴璇曟垚鍔熺殑淇敼
浠諱綍涓€嬈℃暟鎹簱鐨勪慨鏀歸兘闇€瑕佸湪嫻嬭瘯搴撲笂閫氳繃鍙嶅嫻嬭瘯騫朵笖鎴愬姛銆傜敱鐩存帴棰嗗瀹℃壒鍚庯紝
鎵嶈兘瀵圭敓浜у簱榪涜淇敼銆?/div>
1.3.瀵?ddl 璇彞蹇?jī)瀛樻暚鐣?/div>
DBA 搴旇鐭ラ亾 truncate / drop 絳?ddl 鎿嶄綔鍙兘甯︽潵鐨勫獎(jiǎng)鍝嶏紝鎵€浠ュ簲璇ュ榪欎簺 ddl 鎿嶄綔蹇?/div>
瀛樻暚鐣忥紝鐢氳嚦搴旇閬垮厤鎵ц鎴栭伩鍏嶈崏鐜囨墽琛岃繖鏍風(fēng)殑鎿嶄綔錛屾渶濂藉吇鎴愬湪 ddl 娓呴櫎鏁版嵁涔嬪墠澶囦喚
鐨勪範(fàn)鎯€?/div>
閫氳繃涓€浜涜壇濂戒範(fàn)鎯殑鍏繪垚錛屽彲浠ヤ嬌寰楁垜浠皯鐘敊璇€?/div>
2. DBA 鏃ュ父宸ヤ綔
2.1.姣忔棩宸ヤ綔
2.1.1.媯€(gè)鏌?ORACLE 鍚庡彴榪涚▼
紜鎵€鏈夌殑 INSTANCE 鐘舵€佹甯哥櫥闄嗗埌鎵€鏈夋暟鎹簱鎴栦緥紼?媯€(gè)嫻?ORACLE 鍚庡彴榪涚▼:
$ps –ef|grep ora
2.1.2.媯€(gè)鏌ユ枃浠剁郴緇熺殑浣跨敤錛堝墿浣欑┖闂達(dá)級(jí)銆?/div>
濡傛灉鏂囦歡緋葷粺鐨勫墿浣欑┖闂村皬浜?20%錛岄渶鍒犻櫎涓嶇敤鐨勬枃浠朵互閲婃斁絀洪棿銆?/div>
$df –k
鏇村 IT 璁よ瘉璇劇▼璇瘋闂?緹庢渤瀛︿範(fàn)鍦ㄧ嚎 www.eimhe.com
2.1.3.瀹炴椂鐩戞帶鏁版嵁搴撳憡璀︽棩蹇椼€乀RC 鏂囦歡銆佺洃鍚棩蹇楁枃浠?/div>
榪欐槸蹇呴』榪涜鐨勫伐浣滐紝騫朵笖搴旇鏍規(guī)嵁涓嶅悓鐨勪弗閲嶇駭鍒紝鍙戦€佷笉鍚岀駭鍒殑鍛婅錛屽強(qiáng)鏃朵簡(jiǎn)瑙?/div>
鏁版嵁搴撶殑鍙樺寲涓庡憡璀︺€?/div>
2.1.3.1. 娓呯悊鏁版嵁搴撴棩蹇?/div>
紜涓嶅湪闇€瑕佺殑鏃ュ織闇€瑕佽繘琛屾竻鐞嗭細(xì)
$ORACLE_BASE/admin/<SID>/bdump/alert_<sid>.log:錛?echo > alert_<sid>.log
$ORACLE_HOME/network/log/listener.log: echo >listener.log
$ORACLE_BASE/admin/udump/*.trc: rm –rf *.trc
2.1.4.瀹炴椂媯€(gè)鏌ュ浠芥棩蹇楅獙璇佸浠芥湁鏁堟€?/div>
姣忔棩鐨勬暟鎹簱澶囦喚閮藉湪鑷姩榪涜錛屼絾姣曠珶鏄寜鐓ц剼鏈嚜鍔ㄥ浠界殑錛屼篃鏈夊け璐ョ殑鏃跺€欍€傛墍
浠ラ渶瑕佹瘡鏃ユ鏌ユ暟鎹簱澶囦喚鏃ュ織.
2.1.4.1. 澶囦喚鏍￠獙
rman>restore database validate;
2.1.5.鏌ョ湅鏁版嵁搴撹繛鎺ヤ俊鎭?/div>
瀹氭椂瀵規(guī)暟鎹簱鐨勮繛鎺ユ儏鍐佃繘琛屾鏌ワ紝鐪嬩笌鏁版嵁搴撳緩绔嬬殑浼?xì)璇濇暟鐩槸涓嶆槸姝ｅ父锛屽鏋滃缓绔?/div>
浜?jiǎn)杩囧鐨剺q炴帴錛屼細(xì)娑堣€楁暟鎹簱鐨勮祫婧愩€傚悓鏃訛紝瀵逛竴浜?ldquo;鎸傛”鐨勮繛鎺ワ紝鍙兘闇€瑕佹墜宸ヨ繘琛屾竻
鐞嗐€?/div>
浠ヤ笅鐨?SQL 璇彞鍒楀嚭褰撳墠鏁版嵁搴撳緩绔嬬殑浼?xì)璇濇儏鍐靛Q?/div>
Select count(*) from v$session; 鈥曗€曟煡鐪嬪綋鍓嶄細(xì)璇濊繛鎺ユ暟
select sid,serial#,username,program,machine,status from v$session;
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
