oracle startup shutdownÃüÁî
дЩ»ù´¡µÄ! ¶Ô×Ô¼º»¹ÊÇÓкô¦µÄ.
shutdownÓÐËĸö²ÎÊý£ºnormal¡¢transactional¡¢immediate¡¢abort¡£È±Ê¡²»´øÈκβÎÊýʱ±íʾÊÇnormal
Ò»:
shutdown normal:
²»¶Ï¿ªÏÖÔÚÁ¬½ÓµÄÓû§,×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó£¬°üÀ¨¹ÜÀíÔ±ÔÚÄÚ¡£ÒѾÁ¬½ÓµÄÓû§Äܹ»¼ÌÐøËûÃǵ±Ç°µÄ¹¤×÷,ÈçµÝ½»ÐµĸüÐÂÊÂÎñ,Ö±µ½´ËÓû§×ÔÐжϿªÁ¬½Ó.ÕâÑùÐèÒªµÈ´ýµÄʱ¼ä³¤,¿ÉÒÔ²é³öÏÖÁ¬Óû§,ÔÙ֪ͨÆä×ÔÐжϿª.
ËùÓеÄÓû§¶¼¶Ï¿ªÁ¬½Ó£¬Êý¾Ý¿â²Å½øÐйرղÙ×÷£¬¼´¹Ø±ÕÊý¾Ý¿â¡¢Ð¶ÔØÊý¾Ý¿â¡¢ÖÕÖ¹Àý³Ì¡£ÔÚÕâÖÖÇé¿öϹرյÄÊý¾Ý¿âÔÚÖØÐÂÆô¶¯ºó£¬²»»á³öÏÖÎÊÌâ¡£Æô¶¯Ê±²»ÐèҪʵÀý»Ö¸´¡£
¶þ:
shutdown transactional
×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó¡£µÈ´ýËùÓе±Ç°Á¬½ÓÓû§µÄδµÝ½»µÄ»î¶¯ÊÂÎñÌá½»Íê±Ï£¬È»ºóÁ¢¼´¶Ï¿ªÓû§µÄÁ¬½Ó¡£ËùÓеÄÓû§¶¼¶Ï¿ªÁ¬½ÓÔòÁ¢¼´¹Ø±ÕÊý¾Ý¿â£¬½øÐйرÕÊý¾Ý¿â¡¢Ð¶ÔØÊý¾Ý¿â¡¢ÖÕÖ¹½ø³ÌµÈ²Ù×÷¡£ÕâÖÖ·½Ê½,Óû§ÓпÉÄÜÕýÔÚËãÕË,×ö¸´ÔÓ±¨±í!Ò»´ÎÊý¾Ý¿â²Ù×÷×ö²»ÍêµÄ,ÔÚ¸Õ×öÁËÒ»´ÎÊý¾Ý¿â²Ù×÷ºó,½«±»¶Ï¿ª,ÕâÑù¶ÔÓû§ÓÐÒ»¶¨Ó°Ïì.Æô¶¯Ê±²»ÐèҪʵÀý»Ö¸´¡£
Èý:
shutdown immediate
×èÖ¹ÈκÎÓû§ÐµÄÁ¬½Ó£¬Í¬Ê±ÏÞÖƵ±Ç°Á¬½ÓÓû§¿ªÊ¼ÐµÄÊÂÎñ¡£Èç¹ûÒÑÁ¬½ÓÓû§ÓÐδÍê³ÉµÄÊÂÎñ£¬ÔòÊý¾Ý¿âϵͳ²»»áµÈ´ýËûÃÇÍê³É£¬¶øÊÇÖ±½Ó°Ñµ±Ç°Î´µÝ½»µÄÊÂÎñ»ØÍË¡£Êý¾Ý¿âϵͳ²»ÔٵȴýÓû§Ö÷¶¯¶Ï¿ªÁ¬½Ó£¬µ±Î´µÝ½»µÄÊÂÎñ»ØÍ˳ɹ¦ºó£¬ÏµÍ³»áÖ±½Ó¹Ø±Õ¡¢Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕÖ¹Êý¾Ý¿â½ø³Ì¡£Æô¶¯Ê±²»ÐèҪʵÀý»Ö¸´¡£
ËÄ:
shutdown abort
µ±Êý¾Ý¿â³öÏÖ¹ÊÕÏʱ£¬¿ÉÄÜÒÔÉÏÈýÖÖ·½Ê½¶¼ÎÞ·¨Õý³£¹Ø±ÕÊý¾Ý¿â,ÔòʹÓÃÕâÖÖ·½·¨.Ç¿ÖƽáÊøµ±Ç°ÕýÔÚÖ´ÐеÄSQLÓï¾ä;ÈκÎδµÝ½»µÄÊÂÎñ¶¼²»±»»ØÍË! ÕâÖÖ·½·¨»ù±¾Éϲ»»á¶Ô¿ØÖÆÎļþ»òÕß²ÎÊýÎļþÔì³ÉÆÆ»µ¡£Õâ±ÈÇ¿ÖƹػúÒªºÃÒ»µã(ÔÚÎÞ·¨Õý³£¹Ø±ÕÊý¾Ý¿âµÄʱºò).Æô¶¯Ê±×Ô¶¯½øÐÐʵÀý»Ö¸´¡£
¶ÔÓÚnormal¡¢transactional¡¢immediate£¬db bUFFER cACHEµÄÄÚÈÝдÈëÁËÊý¾ÝÎļþ£¬Ã»ÓÐÌá½»µÄÊÂÎñ±»»Ø¹ö£¬ËùÓеÄ×ÊÔ´±»ÊÍ·Å£¬Êý¾Ý¿â±»“¸É¾»”µÄ¹Ø±Õ¡£
¶ÔÓÚabort£¬db bUFFER cACHEµÄÄÚÈÝûÓÐдÈëÊý¾ÝÎļþ£¬Ã»ÓÐÌá½»µÄÊÂÎñҲûÓлعö¡£Êý¾Ý¿âûÓÐDISMOUNTºÍ¹Ø±Õ£¬Êý¾ÝÎļþҲûÓйرա£µ±Êý¾Ý¿âÆô¶¯Ê±£¬ÐèҪͨ¹ýREDO LOG»Ö¸´Êý¾Ý£¬Í¨¹ý»Ø¹ö¶Î¶ÔÊÂÎñ»Ø¹ö£¬¶Ô×ÊÔ´½øÐÐÊÍ·Å¡£
²âÊÔʱ·¢ÏÖÈçÏÂÎÊÌâ(ÓÃsysdbaµÇ½)
ORA-00106: ÎÞ·¨ÔÚÁ¬½Óµ½µ÷¶È³ÌÐòʱÆô¶¯/¹Ø±ÕÊý¾Ý¿â
½â¾ö·½·¨
&nb
Ïà¹ØÎĵµ£º
²éѯÐÇÆÚ¼¸:
select to_char(sysdate,'day') from dual;
²éѯ¼¸ºÅ:
select to_char(sysdate,'dd') from dual;
²éѯСʱÊý:
select to_char(sysdate,'hh24') from dual;
²éѯʱ¼ä:
select to_char(sysdate,'hh24:mi:ss') from dual;
²éѯÈÕÆÚʱ¼ä:
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
²é ......
•±í·ÖÇø¼¼ÊõÊÇÔÚ³¬´óÐÍÊý¾Ý¿â(VLDB)Öн«´ó±í¼°ÆäË÷Òýͨ¹ý·ÖÇø£¨patition£©µÄÐÎʽ·Ö¸îΪÈô¸É½ÏС¡¢¿É¹ÜÀíµÄС¿é£¬²¢ÇÒÿһ·ÖÇø¿É½øÒ»²½»®·ÖΪ¸üСµÄ×Ó·ÖÇø£¨sub partition£©
•Í¨¹ý¶Ô±í½øÐзÖÇø£¬¿ÉÒÔ»ñµÃÒÔϵĺô¦
–¼õÉÙÊý¾ÝË𻵵ĿÉÄÜÐÔ
–¸÷·ÖÇø¿ÉÒÔ¶ÀÁ¢±¸·ÝºÍ»Ö¸´£¬ÔöÇ¿ÁËÊý¾Ý¿âµÄ¿É¹ÜÀíÐÔ
......
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M');
¡¡¡¡-- °´²¿Ê×ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_STROKE_M');
¡¡¡¡-- °´±Ê»ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_RADICAL_M');
¡¡¡¡--ÅÅÐòºó»ñÈ¡µÚ ......
Ò»Ö±ÏëѧϰÈçºÎµÃµ½Êý¾Ý¿âµÄIOÊý¾Ý£¬ORIONÊÇÒ»¸ö²»´íµÄ·ÂÕæ²âÊÔOracle IOµÄ¹¤¾ß¡£
ÏÂÃæÊÇÎҵIJâÊԵIJ½Ö裺
1 ´ÓoracleµÄÍøÕ¾ÉÏÏÂÔØORIONµÄÈí¼þ£¨11.1.0.7£©
2 ½âѹorion_linux_x86-64.gz
3 ½¨Á¢²ÎÊýÎļþ mytest.lun£¬ ÕâÀïµÄÁгöµÄÊÇ·ÖÇøÉ豸£¬ÎÒÔÚÉÏÃ潨Á¢ÁËasmÎļþϵͳ¡£ÒòΪÓÐÊý¾ÝÔÚÀïÃ棬ËùÒÔÎÒÓÃwrite=0Ö»²âÊ ......