Oracle RACÈëÃÅ
=================================================================================
Oracle RAC ²úÆ·¸ÅÊö
Oracle Real Application Server£¬ÕæÕýÓ¦Óü¯Èº£¬¼ò³ÆOracle RAC £¬ÊÇOracleµÄ²¢Ðм¯Èº£¬Î»ÓÚ²»Í¬·þÎñÆ÷ϵͳµÄOracleʵÀýͬʱ·ÃÎÊͬһ¸öOracleÊý¾Ý¿â£¬½ÚµãÖ®¼äͨ¹ý˽ÓÐÍøÂç½øÐÐͨÐÅ£¬ËùÓеĿØÖÆÎļþ¡¢Áª»úÈÕÖ¾ºÍÊý¾ÝÎļþ´æ·ÅÔÚ¹²ÏíµÄÉ豸ÉÏ£¬Äܹ»±»¼¯ÈºÖеÄËùÓнڵãͬʱ¶Áд¡£Æäϵͳ¼Ü¹¹ÈçÏÂͼ£º
RACÌṩµÄºÃ´¦°üÀ¨£º
(1)¶à½Úµã¸ºÔؾùºâ;
(2)Ìṩ¸ß¿ÉÓ㺹ÊÕÏÈÝ´íºÍÎÞ·ìÇл»¹¦ÄÜ£¬½«Ó²¼þºÍÈí¼þ´íÎóÔì³ÉµÄÓ°Ïì×îС»¯£¬Ï±íÊÇRACÓ봫ͳµÄË«»úÈȱ¸·½Ê½Çл»Ê±¼äµÄ¶Ô±È£º
(3)ͨ¹ý²¢ÐÐÖ´Ðм¼ÊõÌá¸ßÊÂÎñÏìӦʱ¼ä----ͨ³£ÓÃÓÚÊý¾Ý·ÖÎöϵͳ;
(4)ͨ¹ýºáÏòÀ©Õ¹Ìá¸ßÿÃë½»Ò×ÊýºÍÁ¬½ÓÊý ;----ͨ³£¶ÔÓÚÁª»úÊÂÎñϵͳ;
(5)½ÚÔ¼Ó²¼þ³É±¾£¬¿ÉÒÔÓöà¸öÁ®¼ÛPC·þÎñÆ÷´úÌæ°º¹óµÄСÐÍ»ú»ò´óÐÍ»ú£¬Í¬Ê±½ÚÔ¼ÏàӦά»¤³É±¾;
(6)¿ÉÀ©Õ¹ÐԺ㬿ÉÒÔ·½±ãÌí¼Óɾ³ý½Úµã£¬À©Õ¹Ó²¼þ×ÊÔ´;
RACµÄȱµãÓУº
Ïà¶Ôµ¥»ú£¬¹ÜÀí¸ü¸´ÔÓ£¬ÒªÇó¸ü¸ß;
ÔÚϵͳ¹æ»®Éè¼Æ½Ï²îʱÐÔÄÜÉõÖÁ²»Èçµ¥½Úµã;
¿ÉÄÜ»áÔö¼ÓÈí¼þ³É±¾(Èç¹ûʹÓøßÅäÖõÄpc·þÎñÆ÷£¬OracleÒ»°ã°´ÕÕCPU¸öÊýÊÕ·Ñ)
ÔÚOracle9i֮ǰ£¬RACµÄÃû³ÆÊÇOPS (Oracle parallel Server)¡£RAC Óë OPS Ö®¼äµÄÒ»¸ö½Ï´óÇø±ðÊÇ£¬RAC²ÉÓÃÁËCache Fusion(¸ßËÙ»º´æºÏ²¢)¼¼Êõ¡£ÔÚ OPS ÖУ¬½Úµã¼äµÄÊý¾ÝÇëÇóÐèÒªÏȽ«Êý¾ÝдÈë´ÅÅÌ£¬È»ºó·¢³öÇëÇóµÄ½Úµã²Å¿ÉÒÔ¶ÁÈ¡¸ÃÊý¾Ý¡£Ê¹ÓÃCache fusionʱ£¬RACµÄ¸÷¸ö½ÚµãµÄÊý¾Ý»º³åÇøͨ¹ý¸ßËÙ¡¢µÍÑÓ³ÙµÄÄÚ²¿ÍøÂç½øÐÐÊý¾Ý¿éµÄ´«Êä¡£
Oracle RAC/ClusterwareµÄ½á¹¹ºÍ×é¼þ
Ò»¡¢RACÖ÷Òª×é¼þ, ÈíÓ²¼þÁ½²¿·Ö
(1) ·þÎñÆ÷ >= 2
(2) ²Ù×÷ϵͳ£¬ÍƼöʹÓÃOracleÈÏÖ¤µÄϵͳ;°æ±¾²»ÒªÌ«ÀÏ£¬Ò²²»ÒªÌ«ÐÂ
(3) CPU/ÄÚ´æ ¸ù¾ÝÒµÎñÐèÒª£¬ÄÚ´æÖÁÉÙ1G
(4) ±¾µØ´ÅÅ̿ռ䣬>=30G
(5) Íø¿¨ >=2 £¬ÍƼö4¸öÒÔÉÏǧÕ×Íø¿¨
(6) ˽ÓÐÒÔÌ«ÍøÂ磬ÍƼöǧÕ×½»»»»úÒÔÉÏ
(7) HBA¿¨ £¬Èç¹ûÊÇSAN£¬ÍƼö2¸öÈßÓàHBA
(8) ¹²Ïí´æ´¢É豸£¬ÍƼöSANÉ豸
(9) ´æ´¢¹ÜÀí£¬ ASM/Cluster LV/Âã·ÖÇø/CFS£¬²»ÍƼöÓÃOCFS£¬¾í¹ÜÀíÈí¼þ¡¢¶à·¾¶Èí¼þµÈ
(10) µÚÈý·½¼¯ÈºÈí¼þ: ¿ÉÑ¡
(11) Oracle Clusterware Èí¼þ
(12) Oracle RDBMS Èí¼þ
¶þ¡¢ClusterwareÖ÷Òª½ø³Ì
(1)crsd£º ¸ºÔð¹ÜÀí¼¯ÈºµÄ¸ß¿ÉÓòÙ×÷¡£¹ÜÀíµÄcrs×ÊÔ´°üÀ¨Êý¾Ý¿â¡¢ÊµÀý¡¢¼àÌý¡¢ÐéÄâIP£¬ons£¬gds»òÕßÆäËû£¬²Ù×÷°üÀ¨Æô¶¯¡¢¹Ø±Õ¡¢¼à¿Ø¼°¹ÊÕÏÇл»¡£¸Ä½ø³ÌÓÉrootÓÃ
Ïà¹ØÎĵµ£º
ÏÂÃæÁ½ÆªÎÄÕÂÈ«²¿ÊÇתÌû~
ÔµØÖ·£ºhttp://www.im80hou.com/html/oracle/2009/0722/824.html
ÀíÂÛ£º
ÄÚ´æÓëÓ²Å̵ÄËٶȲîÒ죬´ÓÄÚ´æÖжÁÈ¡Êý¾ÝÒª±È´ÓÓ²ÅÌÖжÁÈ¡Êý¾Ý¿ì10000±¶
ÖÚËùÖÜÖª£¬´ÓÄÚ´æÖжÁÈ¡Êý¾ÝÒª±È´ÓÓ²ÅÌÖжÁÈ¡Êý¾Ý¿ì10000±¶¡£ÕâÖ÷ÒªÊÇÄÚ´æÓëÓ²Å̵ÄËٶȲîÒìËùÔì³ÉµÄ¡£Îª´ËÔÚOracleÊý¾Ý¿âÖÐÌá³öÒ»¸öÊý¾Ý»º´æµÄ ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
select nvl2(replace(translate('69584.00.00','.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber from dual;
select id,nvl2(replace(translate(id,'.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber
from tbl2 ......
Ò»¡¢Óï·¨
´óÖÂд·¨£ºselect * from some_table [where Ìõ¼þ1] connect by [Ìõ¼þ2] start with [Ìõ¼þ3];
ÆäÖÐ connect by Óë start with Óï¾ä°Ú·ÅµÄÏȺó˳Ðò²»Ó°Ïì²éѯµÄ½á¹û£¬[where Ìõ¼þ1]¿ÉÒÔ²»ÐèÒª¡£
[where Ìõ¼þ1]¡¢[Ìõ¼þ2]¡¢[Ìõ¼þ3]¸÷×Ô×÷Óõķ¶Î§¶¼²»Ïàͬ£º
[where Ìõ¼þ1]ÊÇÔÚ¸ù¾Ý“connect by [Ìõ¼þ2] ......