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
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
1¡¢select TIMESTAMP'2009-11-03 09:26:50.124' from dual --ĬÈϺÁÃë±£´æÁùλ
2¡¢´ËÓï¾äÖ»ÄÜÔÚ·þÎñÆ÷¶ËÔËÐУ¬Èç¹ûÖ´ÐÐÒÔϲÙ×÷£¬ÔòÔÚ²åÈëoracleʱ£¬¿ÉÒÔÖ±½Óдnls_date_formatÉ趨µÄ¸ñʽ£¬µ«ÊÇÖ»ÄÜÕë¶ÔÒ»´Î»æ»£¬Èç¹û¹Øµô´°¿ÚÔòʧЧ¡£
alter session set nls_d ......
½ñÌìÔÚnet managerÅäÖñ¾µØ·þÎñʱ³öÏÖÕâÑùµÄÎÊÌâ
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
ÔÚgoogleÉÏËÑË÷µÃµ½Èô¸É´ð°¸£¬×ÜÊDz»¶Ô£¬ºóÀ´ÔÚͬʵİïÖúϽâ¾öÁËÎÊÌ⣬ÏÖÔÚ×ܽáһϸú´ó¼Ò·ÖÏí¡£
1¡¢Ñ¡Öб¾µØ——·þÎñÃüÃû£¬ÔÚ±à¼Öд´½¨
2¡¢ÊäÈënet·þÎñÃû£¬×¢ÒâÕâÊÇ ......
ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓк ......