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
Ïà¹ØÎĵµ£º
•±í·ÖÇø¼¼ÊõÊÇÔÚ³¬´óÐÍÊý¾Ý¿â(VLDB)Öн«´ó±í¼°ÆäË÷Òýͨ¹ý·ÖÇø£¨patition£©µÄÐÎʽ·Ö¸îΪÈô¸É½ÏС¡¢¿É¹ÜÀíµÄС¿é£¬²¢ÇÒÿһ·ÖÇø¿É½øÒ»²½»®·ÖΪ¸üСµÄ×Ó·ÖÇø£¨sub partition£©
•Í¨¹ý¶Ô±í½øÐзÖÇø£¬¿ÉÒÔ»ñµÃÒÔϵĺô¦
–¼õÉÙÊý¾ÝË𻵵ĿÉÄÜÐÔ
–¸÷·ÖÇø¿ÉÒÔ¶ÀÁ¢±¸·ÝºÍ»Ö¸´£¬ÔöÇ¿ÁËÊý¾Ý¿âµÄ¿É¹ÜÀíÐÔ
......
[root@GISDB ~]$ su - oracle
[oracle@GISDB ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 13 11:03:03 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
To ......
ÔÚ
Oracle
Êý
¾Ý¿â
ÖУ¬
Ö÷ÒªÓÐÁ½ÖÖ
ÈÕÖ¾
²Ù×÷ģʽ£¬·Ö±ðΪ·Ç¹é
µµÄ£Ê½Óë¹éµµÄ£Ê½¡£Ä¬ÈÏÇé¿öÏ£¬Êý¾Ý¿â
²É
ÓõÄÊǷǹ鵵ģʽ
¡£×÷Ϊһ¸öºÏ¸ñµÄÊý¾Ý¿â¹Ü
Àí
Ô±£¬Ó¦µ±ÉîÈëÁ˽âÕâÁ½ÖÖÈÕÖ¾²Ù×÷ģʽµÄÌص㣬²¢ÇÒÔÚÊý¾Ý¿â½¨Á¢Ê±£¬Ñ¡
ÔñºÏÊʵIJÙ×÷ģʽ¡£
¡¡¡¡±ÊÕß
½ñÌì¾Í̸̸×Ô¼º¶ÔÕâÁ½ÖÖ²Ù×÷ģʽµÄÀí½â£¬²¢ÇÒ¸ø³ö ......
/**
*
*/
package com.huawei.widget.util;
import java.math.BigDecimal;
/**
* @author tanjixuan
* @since 2008-12-20
*
*/
public final class DatabaseUtil
{
// oracleתÒå×Ö·û
public static final char ORACLE_ESCAPE_CHAR = '\\';
// orac ......
ʲôÊÇË®Ïß(High Water Mark)?
----------------------------
ËùÓеÄoracle¶Î(segments£¬ÔÚ´Ë£¬ÎªÁËÀí½â·½±ã£¬½¨Òé°Ñsegment×÷Ϊ±íµÄÒ»¸öͬÒå´Ê) ¶¼ÓÐÒ»¸öÔÚ¶ÎÄÚÈÝÄÉÊý¾ÝµÄÉÏÏÞ£¬ÎÒÃÇ°ÑÕâ¸öÉÏÏÞ³ÆΪ"high water mark"»òHWM¡£Õâ¸öHWMÊÇÒ»¸ö±ê¼Ç£¬ÓÃÀ´ËµÃ÷ÒѾÓжàÉÙûÓÐʹÓõÄÊý¾Ý¿é·ÖÅä¸øÕâ¸ösegment¡£HWMͨ³£Ôö³¤µÄ·ù¶ ......