Oracle Stream Replication¼¼Êõ
Stream ÊÇOracle µÄÏûÏ¢¶ÓÁÐ(Ò²½ÐOracle Advanced Queue)¼¼ÊõµÄÒ»ÖÖÀ©Õ¹Ó¦ÓᣠOracle µÄÏûÏ¢¶ÓÁÐÊÇͨ¹ý·¢²¼/¶©Ôĵķ½Ê½À´½â¾öʼþ¹ÜÀí¡£Á÷¸´ÖÆ(Stream replication)Ö»ÊÇ»ùÓÚËüµÄÒ»¸öÊý¾Ý¹²Ïí¼¼Êõ£¬Ò²¿ÉÒÔ±»ÓÃ×÷Ò»¸ö¿ÉÁé»î¶¨ÖƵĸ߿ÉÓÃÐÔ·½°¸¡£ Ëü¿ÉÒÔʵÏÖÁ½¸öÊý¾Ý¿âÖ®¼äÊý¾Ý¿â¼¶£¬schema¼¶£¬Table¼¶µÄÊý¾Ýͬ²½£¬²¢ÇÒÕâÖÖͬ²½¿ÉÒÔÊÇË«ÏòµÄ¡£ Oracle StreamÒ²ÊÇͨ¹ýÊý¾ÝÈßÓàÀ´Ìá¸ß¿ÉÓÃÐÔ£¬ÕâÒ»µãºÍData Guard ÀàÐÍ¡£
Oracle ¸ß¼¶¸´ÖÆ(Oracle advanced Replication) ºÍÁ÷¸´ÖÆ(Stream Replication) ÊÇ´ÓÃû³ÆºÍ¹¦ÄÜÉ϶¼ÏàËƵÄÁ½ÖÖ¼¼Êõ¡£ µ«Ç°ÕßÊÇ»ùÓÚ´¥·¢Æ÷µÄ£¬ºóÕßÊÇ»ùÓÚÈÕÖ¾ÍÚ¾ò(Logminer)¼¼Êõ¡£
1. Stream µÄ¹¤×÷ÔÀí
Stream ÊÇOracle Advanced Queue¼¼ÊõµÄÒ»ÖÖÀ©Õ¹Ó¦Ó㬠ÕâÖÖ¼¼Êõ×î»ù±¾µÄÔÀí¾ÍÊÇÊÕ¼¯Ê¼þ£¬°Ñʱ¼ä±£´æÔÚ¶ÓÁÐÖУ¬È»ºó°ÑÕâЩʼþ·¢²¼¸ø²»Í¬µÄ¶©ÔÄÕß¡£ ´ÓDBAµÄ½Ç¶ÈÀ´Ëµ£¬ ¾ÍÊǰѲ¶»ñOracleÊý¾Ý¿â²úÉúµÄRedoÈÕÖ¾£¬È»ºó°ÑÕâЩÈÕ־ͨ¹ýÍøÂç´«²¥µ½¶à¸öÊý¾Ý¿â£¬ÆäËûÊý¾Ý¿âͨ¹ýÓ¦ÓÃÕâЩÈÕÖ¾£¬´ïµ½¸´ÖƱ仯µÄ×÷Óá£
ÔÚStream »·¾³Ï£¬ ¸´ÖƵÄÆðµãÊý¾Ý¿â½Ð×÷Source Database£¬ ¸´ÖƵÄÖÕµãÊý¾Ý¿â½Ð×÷Target Database¡£ ÔÚÕâÁ½¸öÊý¾Ý¿âÉ϶¼Òª´´½¨Ò»¸ö¶ÓÁУ¬ÆäÖеÄSource DatabaseÉϵÄÊÇ·¢ËͶÓÁУ¬¶øTarget DatabaseÉϵÄÊǽÓÊÕ¶ÓÁС£
Êý¾Ý¿âµÄËùÓвÙ×÷¶¼»á±»¼Ç¼ÔÚÈÕÖ¾ÖС£ ÅäºÃStream»·¾³ºó£¬ ÔÚSource DatabaseÉÏ»áÓÐÒ»¸ö²¶»ñ½ø³Ì(Capture Process), ¸Ã½ø³ÌÀûÓÃLogminer¼¼Êõ´ÓÈÕÖ¾ÖÐÌáÈ¡DDL,DMLÓï¾ä£¬ÕâЩÓï¾äÓÃÒ»ÖÖÌØÊâµÄ¸ñʽ±í´ï£¬½Ð×÷Âß¼±ä¸ü¼Ç¼(Logical Change Record, LCR). Ò»¸öLCR¶ÔÓ¦Ò»¸öÔ×ÓµÄÐбä¸ü£¬Òò´ËÔ´Êý¾Ý¿âÉϵÄÒ»¸öDMLÓï¾ä£¬¿ÉÄܶÔÓ¦Èô¸É¸öLCR¼Ç¼¡£ ÕâЩLCR»á±£´æµ½Sourece DatabaseµÄ±¾µØ·¢ËͶÓÁÐÖС£È»ºó´«²¥½ø³Ì(Propagation Process)°ÑÕâЩ¼Ç¼ͨ¹ýÍøÂç·¢Ë͵½Target DatabaseµÄ½ÓÊÕ¶ÓÁС£ ÔÚTarget DatabaseÉÏ»áÓÐÒ»¸öÓ¦Óýø³Ì(Apply Process)£¬ Õâ¸ö½ø³Ì´Ó±¾µØµÄ½ÓÊÕ¶ÓÁÐÖÐÈ¡³öLCR¼Ç¼£¬È»ºóÔÚ±¾µØÓ¦Óã¬ÊµÏÖÊý¾Ýͬ²½
2. Data Guard ºÍStream Çø±ð
Date GuardÓÐÁ½ÖÖÀàÐÍ£ºphysical sta
Ïà¹ØÎĵµ£º
1. SQL Óï¾äÓëSQL*Plus ÃüÁî
SQL
SQL*Plus
Ò»ÖÖÓïÑÔ
Ò»ÖÖ»·¾³
ANSI±ê×¼
Oracle µÄÌØÐÔÖ®Ò»
¹Ø¼ü×Ö²»ÄÜËõд
¹Ø¼ü×Ö¿ÉÒÔËõд
ʹÓÃÓï¾ä¿ØÖÆÊý¾Ý¿âÖеıíµÄ¶¨ÒåÐÅÏ¢
ºÍ±íÖеÄÊý¾Ý
ÃüÁî²»ÄܸıäÊý¾Ý¿âÖеÄÊý¾ÝµÄÖµ
¼¯ÖÐÔËÐÐ
2.ÒÔϼ¸¸ö²éѯºÜÖØÒª£¬×ÐϸÌå»á
1 (ÓÐÔ±¹¤µÄ³ ......
Oracle±¸·Ý¹ÜÀí
×î¼òµ¥µÄOracle Âß¼±¸·ÝÈí¼þ£¬Ç¿´óµÄ¼Æ»®±¸·Ý¼°ÈßÓ౸·Ý¹¦ÄÜ
Èí¼þÌØÉ«£º
1.ÂéȸËäС£¬ÎåÔà¾ãÈ«¡£±¾×ÅʵÓõĽǶȿª·¢Õâ¸öÈí¼þ£¬Í¬Ê±¼æ¹Ë½çÃæÓ빦ÄÜ
2.ÖÇÄÜ»¯±¸·Ý¹¦ÄÜ£¬µ÷ÓÃOracle µÄexp±¸·Ý¹¦ÄÜ£¬ÖÇÄܼì²â±¸·Ý²ÎÊý
3.ÖÇÄÜѹËõ±¸·ÝÎļþ£¬²»Óõ£Ðı¸·ÝÊý¾Ý¹ý´ó¶øÓ²Å̳ÔÁ¦
4.¼°Æä¼òµ¥µÄ²Ù×÷½çÃ棬¼¸·ÖÖÓ¼ ......
°´ÕÕOracleDocumentÖеÄÃèÊö£¬v$sysstat´æ´¢×ÔÊý¾Ý¿âʵÀýÔËÐÐÄÇ¿ÌÆð¾Í¿ªÊ¼ÀÛ¼ÆȫʵÀý(instance-wide)µÄ×ÊԴʹÓÃÇé¿ö¡£
ÀàËÆÓÚv$sesstat£¬¸ÃÊÓͼ´æ´¢ÏÂÁеÄͳ¼ÆÐÅÏ¢£º
1>.ʼþ·¢Éú´ÎÊýµÄͳ¼Æ(È磺user commits)
2>.Êý¾Ý²úÉú£¬´æÈ¡»òÕß²Ù×÷µÄtotalÁÐ(È磺redo size)
3>.Èç¹ûTIMED_STATISTICSֵΪtrue,Ôòͳ¼Æ»¨·Ñ ......
Oracle OFS FS10755 ±¨´íÎÊÌâµÄ½â¾ö·½·¨
ÔÚijЩÇé¿öÏ£¬ÖØ×°»òÖØÅä OFS ʱ£¬±ÈÈçÑé֤Ⱥ¼¯£¬»òÒƶ¯Èº¼¯×éʱ£¬»á±¨ FS10755 ´í£¬ ´íÎóÐÅÏ¢ÈçÏ£º
Oracle OFS error - FS10755: Error Creating the OracleFsWorker COM object After Oracle OFS installed, the verification could not pa ......
¾³£ÓÐͬÊÂ×ÉѯoracleÊý¾Ý¿â×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬ÈçÔÚ²»Í¬Êý¾Ý¿â×öÊý¾ÝǨÒÆ¡¢Í¬ÆäËüϵͳ½»»»Êý¾ÝµÈ£¬³£³£ÒòΪ×Ö·û¼¯²»Í¬¶øµ¼ÖÂǨÒÆʧ°Ü»òÊý¾Ý¿âÄÚÊý¾Ý±ä³ÉÂÒÂë¡£ÏÖÔÚÎÒ½«oracle×Ö·û¼¯Ïà¹ØµÄһЩ֪ʶ×ö¸ö¼òµ¥×ܽᣬϣÍû¶Ô´ó¼Ò½ñºóµÄ¹¤×÷ÓÐËù°ïÖú¡£
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯
¡¡¡¡Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊÍ ......