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ÓÃ
Ïà¹ØÎĵµ£º
Êý¾Ý¿â´¥·¢Æ÷
´¥·¢Æ÷Óï¾ä
Öƶ¨´¥·¢Æ÷¶¨Ê±¡¢Ê¼þ¡¢±íÃû¼°ÀàÐÍ
´¥·¢Æ÷Ö÷Ìå
ÊÇpl/sql¿ì»ò¶Ô¹ý³ÌµÄµ÷ÓÃ
´¥·¢Æ÷ÏÞÖÆ
¿ÉÒÔͨ¹ýwhen×Ó¾äʵÏÖ
DML(insert update delete)
DDL(create alter drop)
Êý¾Ý¿â²Ù×÷(servererror logo ......
Õâ´ÎµÄ¾ÀúÊÇ×Ô¼ºÕÒÀ´µÄ£¬ÔÚ°²×°ÁË10gµÄÄÇ̨»úÉÏÉý¼¶ÏÂÄÚ´æÒ²±ãÄܺöÓÆÄÇȺÓÑ£¬²»¹ýÏëÏ뻹ÊÇÕÛÌÚÏ°ɣ¬¸øÒƵ½ÅäÖúõãµÄServerÉÏÃ棬ËûÃÇÓÃÆðÀ´Ë³ÐÄ£¬ÎÒ×Ô¼ºÒ²ÄÜÕÛÌÚµã¾Ñé¡£
132µÄϵͳÊÇSuSE10.2µÄ£¬Ö®Ç°ÒѾ°²×°ÁËOracle 9i£¬Õâ¾ÍÒâζ×űØÐëÏÈжÔصô9i£¬±¾ÒÔΪ°²×°10gµÄrunInstallerÄܹ»Ð¶Ôصô9i£¬¿É³¢ÊÔÁ˺þö¼ÊdzöÏÖex ......
Ò» Êý¾Ý¿âµÄÊÂÎñ´¦Àí
¶¨Ò壺ÊÂÎñÊÇÒ»×éÏà¹ØµÄÊý¾Ý¸Ä±äµÄÂß¼¼¯ºÏ¡£ÔÚÒ»¸öÊÂÎñÖеÄÊý¾Ý¸Ä±ä£¨DML£©±£³Ö×ÅÒ»ÖµÄ״̬£¬Êý¾ÝµÄ¸Ä±äͬʱ³É¹¦»òÕßͬʱʧ°Ü¡£
¶þ Êý¾Ý¿âµÄÊÂÎñÓÉÏÂÁÐÓï¾ä×é³É
Ò»×éDMLÓï¾ä£¬Ð޸ĵÄÊý¾ÝÔÚËûÃÇÖб£³ÖÒ»ÖÂ
Ò»¸ö DDL (Data Define Language) Óï¾ä
Ò»¸ö DCL (Data Control Language)Óï¾ä
1¡¢¿ª ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
Ò»¡¢Óï·¨
´óÖÂд·¨£º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] ......