ÓÃORACLE½¨Á¢Êý¾Ý¿â£¨Ïê½â£©
Êý¾Ý¿â½á¹¹ºÍ¿Õ¼ä¹ÜÀí£¨Êý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢±í¿Õ¼ä¡¢¶Î¡¢Ä£Ê½ºÍģʽ¶ÔÏó£©
Ò»¸öORACLEÊý¾Ý¿âÊÇÊý¾ÝµÄ¼¯ºÏ,±»´¦Àí³ÉÒ»¸öµ¥Î»¡£Ò»¸öORACLEÊý¾Ý¿âÓÐÒ»¸öÎïÀí½á¹¹ºÍÒ»¸öÂß¼½á¹¹¡£
ORACLEÂß¼Êý¾Ý¿â½á¹¹ÊÇÓû§ËùÉæ¼°µÄÊý¾Ý¿â½á¹¹¡£Ò»¸öORACLEÊý¾Ý¿âµÄÂß¼½á¹¹ÓÉÏÂÁÐÒòËؾö¶¨:
£®Ò»¸ö»ò¶à¸ö±í¿Õ¼ä£»
£®Êý¾Ý¿âģʽ¶ÔÏ󣨼´±í¡¢ÊÓͼ¡¢Ë÷Òý¡¢¾Û¼¯¡¢ÐòÁС¢´æ´¢¹ý³Ì£©¡£
ORACLE Âß¼´æ´¢½á¹¹Èç±í¿Õ¼ä(tablespace)¡¢¶Î(segment)ºÍ·¶Î§½«Ö§ÅäÒ»¸öÊý¾Ý¿âµÄÎïÀí¿Õ¼äÈçºÎʹÓá£Ä£Ê½¶ÔÏó(schema object)¼°ËüÃÇÖ®¼äµÄÁªÏµ×é³ÉÁËÒ»¸öÊý¾Ý¿âµÄ¹ØϵÉè¼Æ¡£
1. ÎïÀí½á¹¹
(1) Êý¾ÝÎļþ
ÿһ¸öORACLEÊý¾Ý¿âÓÐÒ»¸ö»ò¶à¸öÎïÀíµÄÊý¾ÝÎļþ(data file)¡£Ò»¸öÊý¾Ý¿âµÄÊý¾ÝÎļþ°üº¬È«²¿Êý¾Ý¿âÊý¾Ý¡£Âß¼Êý¾Ý¿â½á¹¹(Èç±í¡¢Ë÷Òý)µÄÊý¾ÝÎïÀíµØ´æ´¢ÔÚÊý¾Ý¿âµÄÊý¾ÝÎļþÖС£Êý¾ÝÎļþÓÐÏÂÁÐÌØÕ÷£º
£®Ò»¸öÊý¾ÝÎļþ½öÓëÒ»¸öÊý¾Ý¿âÏàÁªÏµ¡£
£®Ò»µ©½¨Á¢£¬Êý¾ÝÎļþ²»Äܸıä´óС¡£
£®Ò»¸ö±í¿Õ¼ä£¨Êý¾Ý¿â´æ´¢µÄÂß¼µ¥Î»£©ÓÉÒ»¸ö»ò¶à¸öÊý¾ÝÎļþ×é³É¡£
Êý¾ÝÎļþÖеÄÊý¾ÝÔÚÐèҪʱ¿ÉÒÔ¶ÁÈ¡²¢´æ´¢ÔÚORACLEÄÚ´æ´¢ÇøÖС£ÀýÈ磺Óû§Òª´æÈ¡Êý¾Ý¿âÒ»±íµÄijЩÊý¾Ý£¬Èç¹ûÇëÇóÐÅÏ¢²»ÔÚÊý¾Ý¿âµÄÄÚ´æ´æ´¢ÇøÄÚ£¬Ôò´ÓÏàÓ¦µÄÊý¾ÝÎļþÖжÁÈ¡²¢´æ´¢ÔÚÄÚ´æ¡£µ±Ð޸ĺͲåÈëÐÂÊý¾Ýʱ£¬²»±ØÁ¢¿ÌдÈëÊý¾ÝÎļþ¡£ÎªÁ˼õÉÙ´ÅÅÌÊä³öµÄ×ÜÊý£¬Ìá¸ßÐÔÄÜ£¬Êý¾Ý´æ´¢ÔÚÄڴ棬ȻºóÓÉORACLEºǫ́½ø³ÌDBWR¾ö¶¨ÈçºÎ½«ÆäдÈëµ½ÏàÓ¦µÄÊý¾ÝÎļþ¡£
(2) ÈÕÖ¾Îļþ
ÿһ¸öÊý¾Ý¿âÓÐÁ½¸ö»ò¶à¸öÈÕÖ¾Îļþ(redo log file)µÄ×é,ÿһ¸öÈÕÖ¾Îļþ×éÓÃÓÚÊÕ¼¯Êý¾Ý¿âÈÕÖ¾¡£ÈÕÖ¾µÄÖ÷Òª¹¦ÄÜÊǼǼ¶ÔÊý¾ÝËù×÷µÄÐ޸ģ¬ËùÒÔ¶ÔÊý¾Ý¿â×÷µÄÈ«²¿ÐÞ¸ÄÊǼǼÔÚÈÕÖ¾ÖС£ÔÚ³öÏÖ¹ÊÕÏʱ£¬Èç¹ûδÄܽ«ÐÞ¸ÄÊý¾ÝÓÀ¾ÃµØдÈëÊý¾ÝÎļþ£¬Ôò¿ÉÀûÓÃÈÕÖ¾µÃµ½¸ÃÐ޸ģ¬ËùÒÔ´Ó²»»á¶ªÊ§ÒÑÓвÙ×÷³É¹û¡£
ÈÕÖ¾ÎļþÖ÷ÒªÊDZ£»¤Êý¾Ý¿âÒÔ·ÀÖ¹¹ÊÕÏ¡£ÎªÁË·ÀÖ¹Á¬ÈÕÖ¾Îļþ±¾ÉíµÄ¹ÊÕÏ£¬ORACLEÔÊÐí¾µÏóÈÕÖ¾(mirrored redo log),ÒÔÖ¿ÉÔÚ²»Í¬´ÅÅÌÉÏά»¤Á½¸ö»ò¶à¸öÈÕÖ¾¸±±¾¡£
ÈÕÖ¾ÎļþÖеÄÐÅÏ¢½öÔÚϵͳ¹ÊÕÏ»ò½éÖʹÊÕϻָ´Êý¾Ý¿âʱʹÓã¬ÕâЩ¹ÊÕÏ×èÖ¹½«Êý¾Ý¿âÊý¾ÝдÈëµ½Êý¾Ý¿âµÄÊý¾ÝÎļþ¡£È»¶øÈκζªÊ§µÄÊý¾ÝÔÚÏÂÒ»´ÎÊý¾Ý¿â´ò¿ªÊ±£¬O
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204²¹¶¡ÔöÇ¿ÁËϵͳµÄ°²È«ÐÔ£¬È±Ê¡µÄÃÜÂëÖØÊÔ´ÎÊý¸ÄΪÁË10´Î£¬ÕâÔںܶàÇé¿öÏ£¬»áµ¼ÖÂһЩ¿Í»§±»Ëø¶¨£¬Èç¹ûÏëÐÞ¸ÄÃÜÂëÖØÊÔ´ÎÊý£¬¿ÉÒÔÐÞ¸ÄÏìÓ¦µÄ¸ÅÒªÎļþ£¬Èç¹ûûÓд´½¨Óû§¸ÅÒªÎļþ£¬È±Ê¡µÄ¾ÍÊÇÓÃoracleµÄ¸ÅÒªÎļþ£¬ÐÞ¸ÄÕâ¸ö¸ÅҪΠ......
ɾ³ýORACLE FOR windows µÄoci.dll´íÎóµÄ½â¾ö·½·¨
ɾ³ýORACLE FOR windows µÄoci.dll´íÎóµÄ½â¾ö·½·¨
½ñÌì·¢ÏÖ×Ô¼ºÌ¨Ê½»úÉϵÄORACLEÓÐÎÊÌ⣬´òËãÖØװһϣ¬·¢ÏÖÕû¸öORACLEĿ¼ɾ³ý£¬±¨OCI.DLLÎÞ·¨É¾³ý´íÎó£¬Ñо¿ÁËһϣ¬
·¢ÏֹصôMSDTC·þÎñ¾Í¿ÉÒÔÁË£¬MSDTC·þÎñÔÚϵͳÖеķþÎñÃûΪ
Distributed T ......
oracleÈçºÎ½«Êý¾Ýµ¼Èëµ½ÁíÒ»¸ö±í¿Õ¼ä
ij¸öÓû§µÄÊý¾ÝÔÚUSER±í¿Õ¼äÀÈç¹û¶à¸öÓû§µÄÊý¾Ý¶¼ÔÚUSERS±í¿Õ¼äÄÚ£¬½«ÑÏÖØÓ°ÏìϵͳÐÔÄÜ£¬Ò»°ãÔÚϵͳǨÒƵÄʱºò£¬ÔÚеÄϵͳÀïÏ£Íûµ¼ÈëÒ»¸ö¶ÀÁ¢µÄÓû§±í¿Õ¼ä£¬µ«ÊǾ³£ÎÞ·¨µ¼ÈëÓû§Ö¸¶¨µÄȱʡ±í¿Õ¼ä£¬Õâ¸öÎÊÌâ²úÉúµÄÔÒòÊÇÈç¹ûÒ»¸öÓû§ÓÐDBAµÄȨÏÞ£¬µ¼ÈëÊý¾Ýµ ......
oracle¶ÔʱÇøµÄÖ§³Ö±È½ÏÍêÃÀÁË£¬ÓÐtimestamp with time zoneºÍtimestamp with local time zoneÁ½ÖÖÊý¾ÝÀàÐÍ¡£Ëùνtimestamp with time zone£¬Ò²¾ÍÊÇ°ÑʱÇøÐÅÏ¢±£´æÔÚÁÐÊý¾ÝÖУ¬¶øtimestamp with local time zone£¬»á½«Óû§ÊäÈëµÄʱ¼äת»»ÎªÊý¾Ý¿â·þÎñÆ÷ËùÔÚʱÇøµÄʱ¼ä£¬±£´æÔÚÁÐÖУ¬ÕâÑùÄÜÉÔÉÔ¼õÉÙÒ»µã±£´æµÄÊý¾ÝÁ¿¡£ÒòΪt ......