Oracle DBA ±ÊÊÔÌâ
	
    
    
	author£ºskate
time£º2010-05-26
Oracle DBA ±ÊÊÔÌâ
£¨´ðÌâʱ¼ä60·ÖÖÓ£©
ÍøÉÏ¿´¼ûһƪDBAµÄÃæÊÔÌ⣬¾õµÃͦʵÓõ쬶ø²»ÏñÓеÄÃæÊÔŪµÃºÜÐ飬ºÜÀíÏ뻯¡£
Unix/Linux퉀1¡¢ÈçºÎ²é¿´Ö÷»úcpu£¬ÄÚ´æ¡¢IPºÍ´ÅÅ̿ռä?
2¡¢Äã³£ÓõĽø³Ì¹ÜÀí¡¢Ö÷»úÐÔÄܲ쿴ÃüÁîÓÐÄÄЩ£¿
3¡¢½¨Á¢×édbaºÍ¸Ã×éÏÂÓû§oracle£¬Ä¬ÈÏshellΪbash¡£
4¡¢ÈçºÎ²é¿´Óû§oracleµÄµÇ½ÀúÊ·ºÍÃüÁî²Ù×÷ÀúÊ·£¿
5¡¢Ð´crontab£¬Èýű¾/opt/test.shÔÚÿÖÜÈÕÍíÉÏ8:00Ö´ÐС£
6¡¢ÈçºÎ²éÕÒµ±Ç°Ä¿Â¼¼°ÆäËùÓÐ×ÓĿ¼Ïº¬ÓГORA-”»ò“warning”×Ö·ûÄÚÈݵÄËùÓдølogºó׺µÄÎļþ¡£
7¡¢Ð´Ò»¸öshell£¬Íê³É×Ô¶¯µÇ½Êý¾Ý¿â£¨Óû§ÃûÃÜÂëÊÇtest/testpwd, ÍøÂçÁ¬½Ó´®ÊÇdb_wending£©²¢»ñÈ¡Êý¾Ý¿âµ±Ç°SCNµÄ¹¦ÄÜ¡£
Oracle Database퉀1¡¢ÈçºÎ¿ìËÙÁ˽âÒ»¸öÒѾÔËÐкܾõÄÊý¾Ý¿âϵͳ£¿
2¡¢ÈçºÎ»ñµÃSQLÓï¾äµÄÖ´Ðмƻ®ºÍͳ¼ÆÐÅÏ¢£¿
3¡¢ÁгöÄã³£ÓõÄÊý¾Ý×ÖµäÊÓͼºÍ¶¯Ì¬ÐÔÄÜÊÓͼ¡£
4¡¢³ÂÊöʹÓùýµÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´¼¼Êõ£¬¼°ÆäÓÅȱµã¡£
5¡¢ÃèÊö table/segment/tablespace/datafile/extent/block Ö®¼äµÄ¹ØÏµ¡£
6¡¢Ç°Ì¨ÏµÍ³·´Ó³·Ç³£Âý£¬ÐèÒªÄãÈ¥·ÖÎöÕï¶Ï¡£ÇëÏêϸ³ÂÊöÕï¶ÏÁ÷³Ì£¬°üÀ¨Ð´Ï¿ÉÄÜÓõ½µÄ²Ù×÷ϵͳÃüÁî¡¢Êý¾Ý¿âÊÓͼµÈ¡£
7¡¢¹«Ë¾×¼±¸°ÑOracle9iÉý¼¶ÎªOracle10.2.0.4£¬µ«Åú×¼µÄÍ£¿âʱ¼ä½öΪ10·ÖÖÓ£¬Äã´òËãÈçºÎÓ¦¶Ô£¿
8¡¢Ïêϸ³ÂÊöRAC¡¢Dataguard¡¢Streams Replication¡¢Advanced ReplicationµÈOracle HA¼¼ÊõµÄÔÀíºÍÓÅȱµã¡£
9¡¢Ð´´æ´¢¹ý³Ì£¬°Ñµ±Ç°Óû§ÏÂÊý¾Ý¿â¶ÔÏó¸öÊýÐÅÏ¢°´¶ÔÏóÀàÐÍ·Ö×éÊä³öÀ´¡£
10¡¢ÇëдÏÂÄã³£¹Ø×¢µÄoracle³õʼ»¯²ÎÊý¡£
---end---
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    
	
	
	
	
	<!--
		@page { margin: 2cm }
		P { margin-bottom: 0.21cm }
	-->
¹«ÍøÖÕÓÚͨµÄ£¬ÎÒµÄubuntu
Ò²ÖÕÓÚ¿ÉÒÔ¼ÌÐøÊ¹ÓÃÁË¡£¡£¡£
  
	
Ê×ÏȰѱ¾×ÓµÄubuntu
´Ó9.04
Éý¼¶µ½10.04
£¬·¢ÏÖϵͳ±ä³ÉÓ¢ºº»ìÓÃÁË£¬ÖØÑ¡ÓïÑÔÖ§³Ö°üÒ²²»¿ÉÒÔ£¬ÊäÈë·¨Ò²Ìí¼Ó²»ÉÏ£¬µ¹ÊÇûÓÐÍøÉÏÓÐÈËÌáµ½µÄϵͳÏìÓ¦·Ç³£»ºÂýµÄÎ ......
	
    
        
    
    ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
     sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
     sql>  SELECT * from dba_profiles s WHERE 
   ......
	
    
        
    
    Oracle¶Ô±í×öÈ«±íɨÃèµÄʱºò
£¬»áɨÃèÍêHWMÒÔÏÂ
µÄÊý¾Ý¿é¡£Èç¹ûij¸ö±ídelete(delete²Ù×÷²»»á½µµÍ¸ßˮλ)ÁË´óÁ¿Êý¾Ý£¬ÄÇôÕâʱ¶Ô±í×öÈ«±íɨÃè¾Í»á×öºÜ¶àÎÞÓù¦£¬É¨ÃèÁËÒ»´ó¶ÑÊý¾Ý¿é£¬×îºó·¢ÏÖ¿éÀïÃæ¾ÓȻûÓÐÊý¾Ý¡£
ͨ³££¬ÔÚ¶Ô±í×öÁË´óÅúÁ¿delete²Ù×÷Ö®ºó£¬¾ÍÓ¦¸ÃÂíÉϽµµÍ±íµÄ¸ßˮ룬¿ÉÒÔʹÓÃshrink ÃüÁî»òÕßalter&n ......
	
    
        
    
    ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺 
SQL> desc test; 
Name     Type          Nullable Default Comments 
------- ------------ -------- ------- -------- 
COUNTRY VARCHAR2(20) Y       &nb ......
	
    
        
    
    ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺 
SQL> desc test; 
Name     Type          Nullable Default Comments 
------- ------------ -------- ------- -------- 
COUNTRY VARCHAR2(20) Y       &nb ......