oracle¸ß¼¶¸´ÖÆÖ®Ò»—ÈýÖÖ¸´ÖƼ¼ÊõÌصã
oracleÌṩÈýÖָ߼¶±¸·Ý¹¦ÄÜ
¸ß¼¶¸´ÖÆ£¨Advanced Replication£©
Á÷¸´ÖÆ£¨Streams Replication£©
±¸¿â£¨Dataguard£©
Ò» dataguard£º
dataguardÔڸ߿ÉÓü°ÈÝÔÖ·½ÃæÒ»°ãÊÇdbaµÄÊ×Ñ¡£¬²»¹ÜÊÇÎïÀí±¸Óÿ⣨physical standby database£©»¹ÊÇÂß¼±¸Óÿ⣨logical standby database£©£¬ËüÃǶ¼¾ßÓÐһЩ¹²Í¬µÄ´ýÕ÷¡£
ÅäÖú͹ÜÀí·½ÃæµÄ³É±¾£ºdataguard±Èstream replication¼òµ¥·½±ã£»
°²È«ÓëÎȶ¨·½ÃæµÄ³É±¾£ºdataguard±Èstream replicationÎȶ¨¿É¿¿¡£
¶þ Á÷¸´ÖÆ£º
ÊÊÓÃÓÚÈçÏÂÇé¿ö£º
1¡¢¾Ö²¿¸´ÖÆ stream¿ÉÒÔÖ»¸´ÖÆijЩ±í»òijЩģʽ
2¡¢Òì¹¹»·¾³ ³ä·ÖÀûÓÃÏÖÓеÄÉ豸Óë¼¼Êõ
3¡¢Ô¶³ÌÈÝÔÖ stream¶ÔÍøÂçµÄÒªÇó½ÏdataguardµÍ
stream replicationÓÐÁé»îµÄ¸´ÖƲßÂÔ£¬²»½ö¿ÉÒÔÅäÖÃÖ»¸´ÖÆijЩ±í£¬»¹¿ÉÒÔÅäÖýö¸´ÖÆijЩ±íÉϵÄddl»òdml£¬Ïà±Èdataguard±ØÐëÕû¸öÊý¾Ý¿â¸´ÖƶøÑÔ£¬¿ÉÒÔ½ÚÊ¡Ï൱µÄ´æ´¢Í¶×Ê¡£
Èç¹ûÔÚÒì¹¹»·¾³£¬¼´²»Í¬µÄ²Ù×÷ϵͳ£¬ÄÇdataguard½«»áÊøÊÖÎ޲ߣ¬·Çstream replicationĪÊô£¬ÕâÑù¿ÉÒÔ³ä·ÖÀûÓÃÏÖÓеĻ·¾³£¬ÅäÖøßÓÿɷ½°¸£¬ÔÚÒì¹¹»·¾³£¬stream replication½«»áÊÇadvanced replicationµÄÇ¿¾¢¶ÔÊÖ¡£
stream replication´«²¥µÄÊǾ¹ýlogmnrÍÚ¾ò²¢°ü×°µÄÂß¼¸Ä±ä¼Ç¼£¨LCRs£©£¬Ïà±Èdataguard´«ËÍarchived redo log¡¢advanced replicationµÄmview logÓëmviewˢеķ½Ê½£¬stream replication¶ÔÍøÂçµÄÐèÇó½µµÍÁ˺ܶ࣬
Èý ¸ß¼¶¸´ÖÆ£º
advanced replicationÏà¶ÔÓÚdataguard£¬È±µãÊÇ£ºÅäÖÃÓë¹ÜÀí½Ï¸´ÔÓ¡¢°²È«ÓëÎȶ¨ÐÔ²»¹»£»Óŵ㣺¾Ö²¿¸´ÖÆ¡¢Òì¹¹»·¾³µÈ¡£
advanced replicationÊÇÒ»ÖÖÏ൱³ÉÊìµÄ¼¼Êõ£¬ÔÚÐí¶à¹Ø¼üϵͳÖеõ½³É¹¦µÄÔËÓã¬Ïà¶ÔÓÚ9iR2ÍƳöµÄstream replication¶øÑÔ£¬Ë«·½ÊÊÓõĻ·¾³ËäÈ»Ï൱£¬±ÈÈ綼¿ÉÒÔ½øÐоֲ¿¸´ÖÆ¡¢Òì¹¹¸´ÖÆ¡¢Ô¶³ÌÈÝÔֵȣ¬advanced replicationÄ¿Ç°ÔÚÎȶ¨ÐÔÓ밲ȫÐÔ·½Ãæ¸ü¾µÃÆð¿¼Ñé¡£
¶Ô±Èstream replicationÓëadvanced replicationµ×²ãµÄʵÏÖ¼¼Êõ£¬stream replicationÔÚʵʱÐÔ¡¢Îȶ¨ÐÔ¡¢¸ßЧÂÊ¡¢µÍÏûºÄ£¨½ÏÉÙµÄcpu/network×ÊÔ´£©µÈ·½Ãæ¸üÓÐÓÅÊÆ£¬µ«·²Ò»Ð©ÐÂÍƳöµÄ¹¦ÄÜ£¬¶¼»ò¶à»òÉÙ´æÔÚһЩ²»È·¶¨µÄÒòËØ¡£
ÔÚ10gR1ÖУ¬oracleÕë¶ÔÄ¿Ç°stream replication´æÔÚµÄÈõµã½øÐÐÁËÔöÇ¿£¬²»½öÌṩÁË´Óadvanced replicationǨÒƵ½stream replicationµÄ½Å±¾£¬»¹ÌṩÁËstream replicationµÄÅäÖÃÓë¼à¿Ø¹¤¾ß£¬stream replicationÔÚÅäÖÃÓë¹ÜÀí·½Ãæ±Ø½«ÖÇÄÜ»¯¡¢¼òµ¥»¯£¬µ£¸ºÆðÓëshareplexÕù¶áÆóÒµÊý¾Ý¸´ÖÆÊг¡µÄÖØÈΡ£
ËÄ ¸ß¼¶¸´ÖÆÓëÁ
Ïà¹ØÎĵµ£º
k ˵(14:52):
ÎʸöÎÊÌâ ²éѯÊý¾Ý¿â±íµÄʱºò ¸Ã±í»¹ÄÜдÊý¾ÝÂð ÊÇ°´ÕÕÅŶӵÄ˳Ðò »¹ÊÇ°´ÕÕ²Ù×÷µÄʱ¼ä˳Ðò(²»ÖªµÀoracleÈçºÎ´¦ÀíÕâ¸öÎÊÌ⣩ ¼ÙÉèÒ»¸öÇé¿ö£ºÎÒÏÖÔÚÔÚ²éѯ¼Æ·Ñ±í£¨Õâ¸öʱ¼ä¿ÉÄÜÒª»¨10·ÖÖÓ£© 10·ÖÖÓÓкܶà¼Æ·ÑÊý¾ÝÒªÈë¼Æ·Ñ±í£¨ÄÇÕâ¸öдÊý¾ÝÊÇÒªµÈÎÒ²éѯÍêÁËÖ®ºó²ÅÄÜдÂ𣩠дÊý¾Ý¿â¿Ï¶¨º ......
´´½¨OracleÊý¾Ý¿â£¨ÒÔOracle10gΪÀý£©
ÓÐÁ½ÖÖ´´½¨Êý¾Ý¿âµÄ·½Ê½£¬Ò»ÖÖÊÇÒÔÃüÁîÐнű¾·½Ê½£¬¼´ÊÖ¶¯·½Ê½´´½¨£»ÁíÒ»ÖÖÊÇÀûÓÃOracleÌṩµÄÊý¾Ý¿âÅäÖÃÏòµ¼À´´´½¨¡£±¾ÆªÖ÷Òª½éÉÜÔÚUnixºÍWindowsÏÂÒÔÃüÁîÐнű¾·½Ê½´´½¨OracleÊý¾Ý¿â¡£
Ò»¸öÍêÕûµÄÊý¾Ý¿âϵͳ£¬Ó¦°üÀ¨Ò»¸öÎïÀí½á¹¹¡¢Ò»¸öÂß¼½á¹¹¡¢Ò»¸öÄÚ´ ......
ÉîÈëÁ˽âOracle SCN (1)
--------------------------------------------------------------------------------
£Û˵Ã÷£Ý±¾À´ÔÚÑо¿Backup and Recovery£¬¿ÉÊÇÔÚ×öʵÑéµÄʱºòÓöµ½Ò»Ð©ÎÊÌâ²»ÊǺÜÀí½â£¬½ø¶ø×·¸ùÇóÔ´£¬Ïë¸ãÇå³þ£¬ÓÚÊDZØÐë¸ãÇå³þSCNºÍRecoveryÖ®¼äµÄ¹Øϵ¡£ÓÚÊǺõת¶øÑо¿SCN£¬ÕâÁ½Ìì¿´Á˺ܶàÎÄÕ£¬°üÀ¨EygleÍ ......
* ¼ì²é¼àÌýÆ÷״̬£º
C:\>lsnrctl status
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-6ÔÂ -2009 21:08
:04
Copyright (c) 1991, 2002, ......