VVR¶ÔOracleÊý¾Ý¿â½øÐÐÈÝÔÖ
Ëæ×ÅÈ«ÇòÐÅÏ¢»¯Ê±´úµÄµ½À´£¬ÐÅÏ¢Êý¾ÝÔ½À´Ô½³ÉΪÆóÒµ¹Ø×¢µÄ½¹µã£¬¼´ÔÚ¸÷ÖÖ×ÔÈ»ÔÖº¦»òÕßÈËΪÆÆ»µµÄÇé¿öÏ£¬ÈçºÎ±£Ö¤Éú²úÊý¾ÝµÄ°²È«ºÍ¹Ø¼üÒµÎñµÄ²»ÖжÏÔËÐС£
´«Í³µÄ±£»¤·½·¨ÀëÏß±¸·Ý¡¢±¸·Ý½éÖÊÒìµØ±£´æÔÚÒ»¶¨³Ì¶ÈÉÏ¿ÉÒÔ½â¾öÉÏÊöÎÊÌ⣬µ«ÎªÁËÄܹ»¶ÔÒµÎñϵͳÌṩ¸ü¸ßµÄʵʱÐԺͿɿ¿ÐÔ£¬±£Ö¤¹Ø¼üÒµÎñ7x24²»Öжϣ¬
Ó¦¶Ô¼¤ÁÒµÄÊг¡¾ºÕùºÍÌá¸ß¿Í»§ÂúÒâ¶È£¬ÆóÒµ±ØÐëÔÚITϵͳΧÈÆ“Á¬Ðø”£¨BC£©Ö÷Ìâ½øÐй¹½¨£¬ÊµÊ©ÒµÎñÁ¬Ðø/ÈÝÔÖ±¸·Ý¼Æ»®£¬°üÀ¨ÒµÎñÁ¬ÐøÐÔ¡¢¸ß¿ÉÓÃÐÔ¹Ü
Àí¡¢ÈÝÔÖ¡¢Êý¾Ý¸´Öƺͻָ´·½°¸¡¢°²È«µÈ£¬ÏÂÃæ¾Í¶ÔÊý¾Ý¸´ÖƼ¼Êõ×öÒ»¸ö¼òµ¥µÄ½éÉÜ¡£
¸ù¾ÝÊý¾Ý¸´ÖÆÔËÐеÄλÖ㬿ÉÒÔ½«Êý¾Ý¸´ÖÆ·½Ê½·ÖΪÒÔÏÂËÄÖÖ£º
»ù
ÓÚ´æ´¢(Storage-Based)£º´ú±í³§ÉÌÓÐEMC SRDF¡¢IBM PPRC/GDPS ¡¢HP BusinessCopy¡¢HDS
TrueCopyµÈ£¬Ìصã¶ÔÖ÷»ú͸Ã÷£¬¶ÔÓ¦ÓÃϵͳµÄÓ°Ïì½ÏС£¬¼¼Êõ³ÉÊ죬Óн϶àµÄ³É¹¦°¸Àý£¬µ«ÊÇͶ×ʽϴ󣬶ÔÍøÂçÁ¬½ÓµÄÒªÇóÒ²½Ï¸ß¡£
»ùÓÚ·þÎñÆ÷£¨Host-based£©£º´ú±í³§ÉÌÖ÷ÒªÊÇSymantec¹«Ë¾µÄVeritas Volume Replicator (VVR)£¬ÊÇ´æ´¢¾íµÄ¸´ÖƼ¼Êõ¡£ÐèÒªÕ¼ÓÃÖ÷»úÒ»¶¨µÄϵͳ×ÊÔ´¡£
»ù
ÓÚ´æ´¢½»»»»ú(SAN-Based)£ºÔËÐÐÓÚ¹Ò½ÓÔÚ´æ´¢ÍøÂçÉϵÄרÓÃÉ豸ÖУ¬´ú±í³§ÉÌÓÐCISCOµÄSANTap£¬FalconStor
IPStor£¬Topio SANsafe£¬DataCore SANsymphony, Asynchronous Internet
Mirroring (AIM)µÈ¡£
»ùÓÚÊý¾Ý¿â/Èí¼þÓ¦Óà :´ú±í³§ÉÌÓÐOracle DataGuard£¬Quest
SharePlex£¬IBM-DB2µÄÔ¶³ÌQ¸´ÖÆ£¬SYBASEµÄ¸´ÖÆ·þÎñÆ÷(Replication Server)
µÈ£¬ÕâЩ¼¼Êõ¶¼ÊǶÔÊý¾ÝÂß¼²Ù×÷µÄ¸´ÖÆ£¬ÊôÓÚÂß¼Êý¾Ý¸´ÖÆ£¬¶øÆäËü3ÖÖ¸´ÖƵÄÊÇÊý¾Ý¾íÖеÄÊý¾Ý±ä»¯£¬ÊôÓÚÎïÀíÊý¾Ý¸´ÖÆ¡£µäÐ͵ÄÂß¼Êý¾Ý¸´ÖÆÊÇͨ¹ýÊý¾Ý¿âÈÕ
־ʵÏֵģ¬ÓŵãÊÇÓ²¼þͶ×ÊС£¬¶ÔÉú²úϵͳµÄÓ°Ïì±È½ÏС£¬¶ÔÖ÷¡¢±¸ÓÃϵͳµÄÓ²¼þƽ̨ûÓÐÑ¡ÔñÐÔ£»¿ÉÒÔÔÚ¹ãÓòÍø·¶Î§ÄÚʹÓᣵ«Ëü¶ÔÊý¾Ý¿âϵͳÓÐÑϸñµÄÒªÇ󣬲¢
ÇÒÖ÷¡¢±¸ÓÃϵͳ±ØÐëʹÓÃÏàͬµÄÊý¾Ý¿â°æ±¾¡£
ÉÏÃæ½éÉܵÄÖ÷ÒªµÄ¸÷³§ÉÌ·½°¸ºÍ²úÆ·¿ÉÒԲμûÏÂͼ£º
±¾ÎÄÖ÷Òª½éÉÜ»ùÓÚÖ÷»úºÍÂß¼¾íµÄÊý¾Ý¸´ÖÆVVR¡£
VERITASµÄVVR£¨Veritas Volume
Replicator£©ÊÇÓÃÓÚÓÐЧµÄÔÖÄѻָ´µÄÊý¾Ý¸´ÖÆÈí¼þ£¬¿ÉÒÔÁ¬Ðø¶ÔÓ¦ÓÃÊý¾Ý½øÐÐÒ»¸ö»òÕ߶à¸öµÄ¿½±´±£»¤¡£¾ßÓеÄÓŵãÖ÷ÒªÓУº¸ßÐÔÄÜ£¬¾àÀë²»ÏÞ£¬Ö§³Ö
Òì¹¹µÄ´æ´¢ºÍ²Ù×÷ϵͳ£¬¶ÔÊý¾ÝµÄÁ¬Ðø±£
Ïà¹ØÎĵµ£º
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
¸ø³öÕ ......
SQL SERVERÁÙʱ±í
Ò²¿ÉÒÔ´´½¨ÁÙʱ±í¡£ÁÙʱ±íÓëÓÀ¾Ã±íÏàËÆ£¬µ«ÁÙʱ±í´æ´¢ÔÚ tempdb ÖУ¬µ±²»ÔÙʹÓÃʱ»á×Ô¶¯É¾³ý¡£
Óб¾µØºÍÈ«¾ÖÁ½ÖÖÀàÐ͵ÄÁÙʱ±í£¬¶þÕßÔÚÃû³Æ¡¢¿É¼ûÐԺͿÉÓÃÐÔÉϾù²»Ïàͬ¡£±¾µØÁÙʱ±íµÄÃû³ÆÒÔµ¥¸öÊý×Ö·ûºÅ (#) ´òÍ·£»
ËüÃǽö¶Ôµ±Ç°µÄÓû§Á¬½ÓÊǿɼûµÄ£»µ±Óû§´Ó Microsoft? SQL Server? 2000 ʵÀý¶Ï ......
ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓк ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿ ......
ÔÚOracle8i»òÒÔÉÏ°æ±¾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
ON COMMIT PRESERVE ROWS£»
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
CREATE GL ......