Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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£©ÊÇÓÃÓÚÓÐЧµÄÔÖÄѻָ´µÄÊý¾Ý¸´ÖÆÈí¼þ£¬¿ÉÒÔÁ¬Ðø¶ÔÓ¦ÓÃÊý¾Ý½øÐÐÒ»¸ö»òÕ߶à¸öµÄ¿½±´±£»¤¡£¾ßÓеÄÓŵãÖ÷ÒªÓУº¸ßÐÔÄÜ£¬¾àÀë²»ÏÞ£¬Ö§³Ö
Òì¹¹µÄ´æ´¢ºÍ²Ù×÷ϵͳ£¬¶ÔÊý¾ÝµÄÁ¬Ðø±£


Ïà¹ØÎĵµ£º

Oracle×Ö·û´®º¯Êý

 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 
¸ø³öÕ ......

ORACLEÁÙʱ±íºÍSQLSERVERÁÙʱ±íÒìͬ

 SQL SERVERÁÙʱ±í
Ò²¿ÉÒÔ´´½¨ÁÙʱ±í¡£ÁÙʱ±íÓëÓÀ¾Ã±íÏàËÆ£¬µ«ÁÙʱ±í´æ´¢ÔÚ tempdb ÖУ¬µ±²»ÔÙʹÓÃʱ»á×Ô¶¯É¾³ý¡£
Óб¾µØºÍÈ«¾ÖÁ½ÖÖÀàÐ͵ÄÁÙʱ±í£¬¶þÕßÔÚÃû³Æ¡¢¿É¼ûÐԺͿÉÓÃÐÔÉϾù²»Ïàͬ¡£±¾µØÁÙʱ±íµÄÃû³ÆÒÔµ¥¸öÊý×Ö·ûºÅ (#) ´òÍ·£»
ËüÃǽö¶Ôµ±Ç°µÄÓû§Á¬½ÓÊǿɼûµÄ£»µ±Óû§´Ó Microsoft? SQL Server? 2000 ʵÀý¶Ï ......

OracleÖеÄNullÖµ½âÎö

         ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓк ......

Óà Navicat for Oracle ¹ÜÀí Oracle10g/11g Êý¾Ý¿â

    Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
    °²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿ ......

oracleÁÙʱ±íÏà¹Ø֪ʶ

 ÔÚOracle8i»òÒÔÉÏ°æ±¾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
    CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
    ON COMMIT PRESERVE ROWS£»
  
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
    CREATE GL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ