Data Guard æ¯Oracleçè¿ç¨å¤å¶ææ¯ï¼å®æç©çåé»è¾ä¹åï¼ä½æ¯æ»çæ¥è¯´ï¼å®éè¦å¨å¼å°æä¸å¥ç¬ç«çç³»ç»ï¼è¿æ¯ä¸¤å¥ç¡¬ä»¶é
ç½®å¯ä»¥ä¸åçç³»ç»ï¼ä½æ¯è¿ä¸¤å¥ç³»ç»ç软件ç»æä¿æä¸è´ï¼å
æ¬è½¯ä»¶ççæ¬ï¼ç®å½åå¨ç»æï¼ä»¥åæ°æ®çåæ¥ï¼å
¶å®ä¹ä¸æ¯å®æ¶åæ¥çï¼ï¼è¿ä¸¤å¥ç³»ç»ä¹é´åªè¦ç½ç»æ¯éçå°±å¯ä»¥äºï¼æ¯ä¸ç§å¼å°å®¹ç¾ç解å³æ¹æ¡ãè对äºRACï¼åæ¯æ¬å°çé«å¯ç¨é群ï¼æ¯ä¸ªèç¹ç¨æ¥åæ
ä¸ç¨æç¸åçåºç¨ï¼ä»¥è§£å³è¿ç®æçä½ä¸ï¼åèç¹æ
éè¿æ ·çé®é¢ï¼å®æ¯å å°ç¡¬ä»¶ç¸åæä¸ç¸åçæå¡å¨ï¼å ä¸ä¸ªSANï¼å
±äº«çåå¨åºåï¼æ¥ææçã
Data Guardç±ä¸¤ä¸ªå¤ä¸¤ä¸ªä»¥ä¸çç¬ç«çæ°æ®åºææï¼ä»ä»¬åèªæåèªçåå¨ï¼Oracleè´è´£ä»ä»¬ä¹é´çåæ¢åæ°æ®åæ¥
åæºçå¤ç±ä¸¤å°è®¡ç®æºåä¸ä¸ªå
±äº«åå¨è®¾å¤ææï¼éè¿ç¬¬ä¸æ¹è½¯ä»¶ï¼HA Roseçï¼å®ç°åæ¢ï¼ä¸éè¦åæ°æ®åæ¥
建议åºç¨RAC+Dataguard ï¼RACä¿è¯å¯ç¨æ§ï¼Dataguardå¨RACç»ç¬ç«ç£çä¸åå¦å¤ä¸å°ä¸»æºä¸ï¼ä¿è¯å¯é æ§ã
åæºå°±æ¯äººä»¬æ说çåæºçå¤,æ°æ®åºæ¾å¨å
±äº«è®¾å¤ä¸ï¼åä¸æ¶å»åªè½æä¸å°ä¸»æºæ¥ç®¡ï¼å¦ä¸å°å¾
ç¨ï¼è¿ç§æ¹å¼åªè½ä¿æ¤å®ä¾ï¼ä¸è½ä¿æ¤dbï¼èä¸å¤æºé¿æå¤äºé²ç½®ï¼å¯¹èµæºæ¯ä¸ç§æ大ç浪费ï¼
å¦æåæ¬æ¯åæºï¼å»ºè®®è½¬æ¢ä¸ºRAC
è§å好åºç¨ï¼DMLæä½ä»ä¸ä¸ªèç¹è·ï¼æ¥è¯¢æä½ä»å¦ä¸ä¸ªèç¹è·ï¼é常ä¸éè¦å¤ªå¤è°ä¼å°±å¯ä»¥å©ç¨é²ç½®çå¦å¤ä¸å°æºå¨äº
RACæå¡å¨å
±ç¨ä¸å¥åå¨,åæ¶æä¾æå¡,没æ主å¤ä¹å.å®ä¸ä¸ªå
¶å®çå¯ä»¥ç»§ç»æå¡.
åæºçå¤,å
±ç¨ä¸å¥åå¨,ä¸ä¸ªæä¾æå¡ä¸ä¸ªå¤ä»½,主æºå®äºåæ¢å°å¤ä»½æå¡å¨æä¾æå¡.
data guard å®å
¨ä¸¤å¥ç³»ç»,åå¨æ¯åç¬ç,ç¨æ¥å¿åæ¥.
RACï¼ å®ä¾å±åä½
DG ï¼æ°æ®åºå±åä½
çå¤ï¼ä»
ä»
åªæ¯æ°æ®åä½
个人ç解ï¼
RAC ï¼å®ä¾åä½ï¼èä¸è¿å¯ä»¥åå°æ°æ®åºçloadbalanceã
DG ï¼å¤ä»½æ°æ®ï¼æ以è½åå°æ°æ®åä½ï¼ä½æ¯åªæ主èç¹æä¾æå¡ã
çå¤ï¼ä¸RACæ大çå·®å¼å¯è½å°±æ¯RACæå¤ä¸ªå®ä¾ï¼ä¸ä¸ªæ°æ®åºãèçå¤åªæ¯ä¸ä¸ªå®ä¾ï¼ä¸ä¸ªæ°æ®åºãæ以åä¸äºå¹¶ååloadbalanceã
Oracle RACåªæ¯åOracleçåºç¨ï¼roseï¼legatoè¿å¯ä»¥åå
¶å®ç
HA:æ¯High Availability çé¦åæ¯ç»åï¼ç¿»è¯è¿æ¥ï¼å¯ä»¥å«åé«å¯ç¨ï¼æé«å¯ç¨æ§ï¼é«å¯ç¨ï¼ç¯å¢ï¼ãæè§å¾åºè¯¥è¯´HAæ¯ä¸ä¸ªè§å¿µèä¸æ¯ä¸é¡¹æä¸ç³»åå
·ä½ææ¯ï¼å°±è±¡ç½æ ¼ä¸æ ·ãä½è¿ç³»ç»æ¹æ¡å°±ç¥éäºï¼è¯ä»·ç³»ç»çæ§è½å½ä¸å°±æä¸é¡¹é«å¯ç¨ã广ä¹çé«å¯ç¨æ¶åå°ç³»ç»çå个æ¹é¢ï¼ç®åæ¥è¯´ï¼è®©ç³»ç»ä¸ä¼ä¸æ è¿è¡ï¼å°±æ¯é«å¯ç¨ãå
æ¬è½¯ä»¶çé«å¯ç¨ï¼ç¡¬ä»¶çé«å¯ç¨ï¼ç½ç»çé«å¯ç¨ççãå
·ä½å®ç°çæ¹æ¡å
æ¬æä½ç³»ç»çé群ï¼æ°æ®åºçé群ï¼ç¡¬ä»¶çåä½ï¼ç½ç»çåä½ççãåHAæ¹é¢ç软件ï¼æIBMçHACMPï¼å¾å¤å¸¸ç¨AIXç人ï¼å¸¸è¯´çHAå°±æHACMPï¼ä¹±åï¼ãSUNçSun ClusterãHPçMC/SGçã
å¨2000年以åï¼å¤§å®¶è°HAï¼å¤§é¨åæ¶å说çæ¯æä½ç³»ç»ä¸çº§çåæºçå¤ï¼ä¸»æµäº§åå½æ¶æ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å¯ä»¥æè±åæºè½¯ä»¶äºï¼ä½ASMç®åå®å¨å¤ªé¾ä¼ºåäºï¼ï¼å½ç¶è¿å¾ä¹°RAC licenseã
3ãæ¥å¸¸ç»´æ¤ãRACè¦æ±çææ¯å«éæ´é«ï¼ä¹åºè¯¥æ´å¤å¿«ãæå
³é®çæ¯å¾ä¹°oracleæå¡ï¼å¦åéå°æäºé®é¢ï¼bugï¼ï¼ä½ å°±æ¯åæºè¿ä¸é«å¯ç¨äºã
4ãä¼ç¼ºç¹ãè¿ä¸ªï¼ççRACçå®æ¹è®ºè¿°å§ãå¦æè½ç¨å¥½ï¼ç¡®å®æ¯å¾æ好å¤çãç®åæ们ç40å¤ä¸ªå®¢æ·ç使ç¨æ
åµæ¥çï¼RACç¡®å®å¤§å¤§éä½äºä»ä»¬çdowntimeï¼å¦ä¸æ¹é¢å¯ä»¥è¯´å°±æ¯æé«äºç产åå¯ã
Dataguard:ä¸è¬æ¯åºäºå®¹ç¾çç®çãæ¯ä¸»æ°æ®åºçå¤ç¨åºï¼standby åºï¼éè¿èªå¨ä¼ éåæ¥åarchivelogï¼å¹¶ä¸å¨dataguardåºèªå¨apply è¿äºlogï¼ä»èè¾¾å°å主æ°æ®åºåæ¥çç®çï¼å¯è½dataguard åºæ¯å»ºç«çå¼å°çï¼å½ä¸»åºæå¨çåºååºç°äºè´å½æ§çç¾é¾æ¶(ç«ç¾ãå°éç)ï¼ä¸»åºæ²¡æ³ä¿®å¤æ¶ï¼è¿æ¶å¯ä»¥åæ¢dataguard 为主åºç模å¼ï¼å¯¹å¤æä¾æå¡ï¼èå®çæ°æ®åºæ¬æ¯å½åææ°çãç®åå¯è½å¤§å®¶å¯¹äº dataguard åºç使ç¨å·²ç»æå±åºäºå
¶ä»æ´å¤çç¨éï¼æ¯å¦å¤ä»½ï¼è·æ¥è¡¨ççã
温馨提示:答案为网友推荐,仅供参考