OracleÖг£ËµµÄHA¡¢RAC¡¢DataguradµÄÇø±ð
HA
ÊÇHigh Availability
µÄÊ××Öĸ×éºÏ£¬·Òë¹ýÀ´£¬¿ÉÒÔ½Ð×ö¸ß¿ÉÓ㬻ò¸ß¿ÉÓÃÐÔ£¬¸ß¿ÉÓ㨻·¾³£©¡£ÎÒ¾õµÃÓ¦¸Ã˵HAÊÇÒ»¸ö¹ÛÄî¶ø²»ÊÇÒ»Ïî»òһϵÁоßÌå¼¼Êõ£¬¾ÍÏóÍø¸ñÒ»Ñù¡£×÷¹ýϵͳ
·½°¸¾ÍÖªµÀÁË£¬ÆÀ¼ÛϵͳµÄÐÔÄܵ±ÖоÍÓÐÒ»Ïî¸ß¿ÉÓ᣹ãÒåµÄ¸ß¿ÉÓÃÉæ¼°µ½ÏµÍ³µÄ¸÷¸ö·½Ã棬¼òµ¥À´Ëµ£¬ÈÃϵͳ²»»áÖжÏ
ÔËÐУ¬¾ÍÊǸ߿ÉÓᣰüÀ¨Èí¼þµÄ¸ß¿ÉÓã¬Ó²¼þµÄ¸ß¿ÉÓã¬ÍøÂçµÄ¸ß¿ÉÓõȵȡ£¾ßÌåʵÏֵķ½°¸°üÀ¨²Ù×÷ϵͳµÄ¼¯Èº£¬Êý¾Ý¿âµÄ¼¯Èº£¬Ó²¼þµÄÈßÓà£¬ÍøÂçµÄÈßÓàµÈµÈ¡£
×öHA·½ÃæµÄÈí¼þ£¬ÓÐIBMµÄHACMP£¨ºÜ¶à³£ÓÃAIXµÄÈË£¬³£ËµµÄHA¾ÍÖ¸HACMP£¬ÂÒ°¡£©¡¢SUNµÄSun
Cluster¡¢HPµÄMC/SGµÈ¡£
ÔÚ2000ÄêÒÔǰ£¬´ó¼Ò̸HA£¬´ó²¿·Öʱºò˵µÄÊDzÙ×÷ϵͳһ¼¶µÄË«»úÈȱ¸£¬Ö÷Á÷²úÆ·µ±Ê±ÓÐIBM
HACMP4.1£¬HPµÄMC/SGɶ°æ±¾ÍüÁË£¬sunµÄϵͳºÜ¶àÈ˲»ÓÃVCS£¬ÓõÄÊÇÒ»¸ö½ÐdatawareµÄ¶«Î÷¡£ÏÖÔںܶàÈËÑÛÖеÄHAÒ²»¹ÊÇÕâÑù¡£
ʱÖÁ½ñÈÕ£¬HA°üÀ¨µÄ¶«Î÷¿É¾Í¶àÁË£¬ÏȲ»ËµÆäËû·½Ã棬µ¥¾ÍÊý¾Ý¿â£¬µ¥¾ÍOracle£¬ÓëHAÏà¹ØµÄ²úÆ·ÏȺóÓУº¸ß¼¶¸´ÖÆ
£¨AdvanceRepication)¡¢OPS/RAC(Real Application Cluster£©¡¢Êý¾ÝÎÀÊ¿£¨Data
Guard£©¡¢oracleÁ÷£¨Oracle Streams£©¡¢·ÖÇø£¨Oracle
Partition£©ÕâÑùÊý¿î²úÆ·¡£ÕÕÕâô˵£¬RACÖ»ÊÇHAÕâ¸ö¸ÅÄîϵÄÒ»¸ö¾ßÌå²úÆ·¶øÒÑ£¡Ä¿Ç°ÎªÖ¹£¬Ö»ÓÐRACºÍ·ÖÇøÊÇOracleÒªÊÕÈ¡
licenceµÄ£¬ÆäËûµÄ£¬Ö»Òª¸ø¾Ñé·á¸»µÄµÚÈý·½ÊµÊ©·½¸¶Ò»¶¨µÄ¹æ»®/Éè¼Æ¼°²¿Êð·ÑÓþͿÉÒÔÁË£»µ±È»£¬Ò²¿ÉÒÔ×Ô¼ºÕÕ×ÅÎĵµÒÀºù«»Æ°£¬µ«ÊÇÕâÑùŪ³öµÄ»·
¾³ÊÇ·ñÄÜ´ïµ½¸ß¿ÉÓþÍÄÑ˵ÁË¡£ÊÂʵÉÏ£¬´ó²¿·ÖÈËËù˵µÄHA£¬»¹ÊÇÏÁÒåÉϵÄHA£¬Ò²¾ÍÊÇOSÒ»¼¶µÄË«»úÈȱ¸¡£
RAC
ÊÇreal application
clusterµÄ¼ò³Æ£¬ËüÊÇÔÚ¶à¸öÖ÷»úÉÏÔËÐÐÒ»¸öÊý¾Ý¿âµÄ¼¼Êõ£¬¼´ÊÇÒ»¸ödb¶à¸öinstance¡£ËüµÄºÃ´¦ÊÇ
¿ÉÒÔÓɶà¸öÐÔÄܽϲîµÄ»úÆ÷¹¹½¨³öÒ»¸öÕûÌåÐÔÄܺܺõļ¯Èº£¬²¢ÇÒʵÏÖÁ˸ºÔؾùºâ£¬ÄÇôµ±Ò»¸ö½Úµã³öÏÖ¹ÊÕÏʱ£¬ÆäÉϵķþÎñ»á×Ô¶¯×ªµ½ÁíÍâµÄ½ÚµãÈ¥Ö´ÐУ¬Óû§Éõ
ÖÁ¸Ð¾õ²»µ½Ê²Ã´¡£
Ë«»úÈȱ¸£¨HA£©ºÍRACÓÐÉ¶Çø±ðÄØ?
1¡¢¶ÔÓÚÓ²¼þÀ´Ëµ£¬»ù±¾ÉÏÒ»Ñù£¬¹²Ïí´æ´¢¡¢¹âÏËÏߣ¨Ò²Óл¹ÓÃSCSIÏߵģ©¡¢¶ą̀СÐÍ»ú£¨¿ÉÒÔ×ö¶à½ÚµãµÄÏ໥Èȱ¸£¬Ò²¿ÉÒÔ×ö¶à½ÚµãµÄRAC£©¡¢¹âÏ˽»»»»ú
£¨Èç¹ûÊÇÓùâÏË¿¨µÄ»°£©£»µ«×öRAC£¬ÔÚÖ÷»úÖ®¼ä£¬×îºÃʹÓøߴø¿íÍøÂç½»»»»ú£¨ËäÈ»²»ÓÃÒ²¿ÉÒÔ×ö³É£©£»Òò´ËÓ²¼þ³É±¾Ïà²î²»´ó¡£
2¡¢Èí¼þÄØ£¬²î±ð¿É²»Ð¡¡£Èç¹ûÊÇË«»úÈȱ¸£¬±ØÐëÂò²Ù×÷ϵͳ¼¶µÄË«»ú¹ÜÀíÈí¼þ£»Èç¹ûÊÇRAC£¬Ä¿Ç°»¹Êǽ¨Ò鹺ÂòË«»ú¹ÜÀíÈí¼þ£¨¾¡¹Ü10gµÄcrs+asm¿É
Ïà¹ØÎĵµ£º
ÕâÆªÂÛ̳ÎÄÕ£¨ÈüµÏÍø¼¼ÊõÉçÇø£©Õë¶ÔDBMS_SCHEDULERµÄʹÓ÷½·¨½øÐÐÁËÏ꾡µÄ½éÉÜ£¬¸ü¶àÄÚÈÝÇë²Î¿¼ÏÂÎÄ£º
DBMS_SCHEDULERÊÇOracle 10GÖÐÐÂÔöµÄÒ»¸ö°ü£¬ÓëÀϰ汾µÄdbms_job°üÏà±È£¬dbms_schedulerÓкܶàÐÂÌØÐÔ£¬ÎÒ½«Í¨¹ýһϵÁеÄÎÄÕÂÀ´½éÉÜÒ»ÏÂÈçºÎʹÓÃÕâ¸ö°ü.
1. ´´½¨job
job ......
1.2 ¹ÜÀíJobs
1.2.1 ÆôÓÃJobs
¡¡¡¡Ç°Ãæ´´½¨JOBʱ£¬ÓÉÓÚδÏÔʽµÄÖ¸¶¨ENABLED²ÎÊý£¬Òò´Ë¼´Ê¹Ö¸¶¨ÁËSTART_DATE£¬²»¹ýĬÈÏÇé¿öÏÂJOB²»»á×Ô¶¯Ö´ÐС£¶ÔÓÚÕâÖÖÇé¿ö£¬DBMS_SCHEDULER°üÖÐÌṩÁËÒ»¸ö¹ý³ÌENABLE£¬¿ÉÒÔÓÃÀ´ÐÞ¸ÄJOBµÄÆôÓÃ״̬£¬µ÷Ó÷½Ê½·Ç³£¼òµ¥£¬ÀýÈ磺
SQL> exec dbms_scheduler.enable(¨INSERT_TEST_TBL& ......
¶þ¡¢Ê¹ÓÃPrograms
¡¡¡¡ÔÚÂÛ̳ÖÐż¶û¼û¹ýÓÐÈËÌÖÂÛÈçºÎÔÚORACLEÖÐÖ´ÐвÙ×÷ϵͳÃüÁ»òÊÇORACLEÊý¾Ý¿âÍâµÄÓ¦Óá£Ó¦¸Ã˵ÔÚ9i¼°Ö®Ç°µÄ°æ±¾ÖУ¬ËäȻ˵²¢·ÇÍêÈ«ÎÞ·¨ÊµÏÖ£¨Æäʵ»¹ÊÇÓжàÖÖ·½Ê½Äܹ»±äÏàʵÏֵģ©£¬²»¹ý¸´ÔÓµÄʵÏÖ·½Ê½ÈÃDBAʹ¾¢ÁËÁ¦£¬ÉË͸ÁËÐÄ£¬·Ñ¾¢ÁËʶù¡£
¡¡¡¡½øÈë10g°æ±¾Ö®ºó£¬¾ÍÍêÈ«²»±ØÈç´Ë·ÑÉñ£¬ÒòΪÓÐÁËDBMS ......
Èý¡¢Ê¹ÓÃSchedules
¡¡¡¡10g ÖÐÐÂÍÆ³öµÄSCHEDULER¿ÉÄÜȷʵ»áÈúܶà³õ½Ó´¥µÄÅóÓѸоõÔÎÍ·ÔÎÄÔ£¬Ïà±È֮ǰµÄjobs£¬SCHEDULERÖÐÐÂÔöµÄ¸ÅÄîÌ«¶à¡£±ÈÈç˵jobs£¬ÈÔÈ»¿ÉÒÔÀí½â³É֮ǰ°æ±¾ÖеÄjobs£¬²»¹ý¹¦Äܸü¼ÓÇ¿´ó(×¢Òâ10gÖÐÒ²ÈÔÈ»¿ÉÒÔʹÓÃÆÕͨjobs£¬ÕâÊÇ·Ï»°£¬ÏàÐÅ¿´±¾ÆªÎÄÕµÄÅóÓÑĿǰӦ¸Ã»¹ÊÇÕâÑùÔÚÓÃ)£¬±ÈÈç˵program£¬Ö¸µÄÊÇÔ ......
¾ßÌåʵÏÖÈçÏ£º
SQL> select count(*) from v$session #Á¬½ÓÊý
SQL> Select count(*) from v$session where status='ACTIVE'¡¡#²¢·¢Á¬½ÓÊý
SQL> show parameter processes #×î´óÁ¬½Ó
SQL> alter system set processes = value scope = spfile;ÖØÆôÊý¾Ý¿â #ÐÞ¸ÄÁ¬½Ó ......