Oracle ASM¾¿¾¹ÊÇ×öʲôµÄ ´ðÒÉÆß
¸Ðл¶ÁÕß¿´¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIXUNIXÉϵÄʵսÏê½â¡·Õâ±¾Ê飬ÕâÀï»Ø´ðһЩ¶ÁÕßÓʼþÌá³öµÄÒ»¸ö½ÏΪ¹«¹²µÄÎÊÌ⣺ASMÓÐʲôÓã¿ÎªÊ²Ã´Óã¿ ASMÊÇOracle´Ó10g¿ªÊ¼ÌṩµÄÒ»ÖÖ´æ´¢¹ÜÀí¼¼Êõ£¬Ö¸µÄÊÇÒ»¸öÔÚÎïÀí¾í£¨»òÕß´ÅÅÌ·ÖÇø£©ÉÏÌرðΪOracleÊý¾ÝÎļþ¶ø´´½¨µÄ¡°×¨Óá±Îļþϵͳ¡£¸ÃÎļþϵͳÓÉOracleÄÚºËά»¤£¬²¢¹ÜÀíÕâЩλÖ㬽ø¶ø»ñµÃÊÊÓÃÓÚÊý¾Ý¿âµÄ×î¸ßÐÔÄܺÍ×î´ó¿ÉÓÃÐÔ¡£ ÔÚASMÖ®ÉÏ£¬¹ÜÀíÔ±²»²»ÖªµÀºÍ¹ØÐÄOracle½«ÕâЩ¸÷¸öÇø¼ä£¨extent£©·ÅÔÚ´ÅÅÌÉÏÄĸöλÖã¬ASMÒÑ×öºÃÁËËùÓеĹÜÀí¹¤×÷¡£Í¨¹ýASM£¬¾í¹ÜÀíÈí¼þ¡¢Îļþϵͳ¶¼²»ÔÙÐèÒª£¬ÈçÏÂͼËùʾ£º ÈçÉÏͼËùʾ£¬ÏµÍ³ÖдæÔÚÈô¸É´ÅÅÌ¡£ÆäÖÐһЩ´ÅÅÌÓû§°²×°AIX£¬³ÉΪrootvg¸ù¾í×é¡£ÁíÍâһЩ´ÅÅ̱»ÉèÖóÉÁíÍâµÄAIX¾í×飬´æ·ÅÓ¦ÓÃÊý¾Ý¡£³ý´ËÖ®Í⣬»¹ÓÐһЩ´ÅÅÌ£¨ÓҲࣩ£¬ËûÃDZ»Oracle ASMʵÀýËù¹ÜÀí£¬±»»®·ÖΪÈô¸É´ÅÅÌ×飨ÉÏͼÖеĴÅÅÌ×éºÍ´ÅÅÌ×é¶þ£©¡£ Oracle¿ÉÒÔ½«OracleµÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþ¡¢ÈÕÖ¾Îļþ¡¢¹éµµÈÕÖ¾µÈÎļþ·ÅÖÃÔÚASM´ÅÅÌ×éÖУ¬ÒÔASMÎļþµÄÐÎʽ´æÔÚ¡£Ã¿¸öASMÎļþ¿ÉÄÜ·Ö²¼´æ·ÅÔÚ¶à¿éASMÅÌÉÏ£¬Ã¿¿éASM´ÅÅÌÉÏÒ²ÓÐÈô¸ÉASMÎļþ¡£ ËùÒÔ£¬²ÉÓÃASM·½Ê½´æ´¢OracleÊý¾Ý£¬Ò²ÊÇOracleÌṩµÄÒ»ÖÖ´æ´¢¹ÜÀí·½°¸£¬ÊÇÓÐÆ乤³ÌÒâÒåµÄ¡£
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ÓÃtg4mssqlÁ´½Óoracle.
¹ý³Ì²»ÔÚÃèÊö£¬googleºÜ¶à¡£
ÎÊÌ⣺
1¡¢mssql expressµÄʱºò£¬Ê§°Ü
½«serverÓÃתÒå×Ö·ûд³ö£¬³É¹¦¡£
HS_FDS_CONNECT_INFO="SERVER=SHAM0415\\SQLEXPRESS;DATABASE=GMT_KJ"
2¡¢½¨¶à¸öµÄʱºò£¬²»ÄܽâÎö¡£ tnsping ÃüÁî×ܲ»Í¨¹ý¡£
ÕÒÁ˺ܶ࣬ͬһ¸öÌû×Ó£¬×ªÁËÎÞÊý´Î¡£¡£
°¦¡£¡£ÖйúµÄ ......
ÖØ×öÈÕÖ¾ÎļþÊÇOracleÊý¾Ý¿âÖÐÒ»Öַdz£ÖØÒªµÄÈÕÖ¾Îļþ£¬Ò²ÊÇÆäÒ»¸öºÜÓÐÌØÉ«µÄ¹¦ÄÜ¡£ÖØ×öÈÕÖ¾Îļþ»á¼Í¼¶ÔÓÚÊý¾Ý¿âµÄÈκβÙ×÷£¬ÈçÀûÓÃDMLÓï¾ä»òÕßDDLÓï¾ä¶ÔÊý¾Ý½øÐиü¸Ä£¬»òÕßÊý¾Ý¿â¹ÜÀíÔ±¶ÔÊý¾Ý¿â½á¹¹½øÐиü¸Ä£¬¶¼»áÔÚÖØ×öÈÕÖ¾ÖнøÐмǼ¡£
¡¡¡¡¿É¼û£¬µ±Êý¾Ý±»ÒâÍâµÄɾ³ý»òÕßÐ޸ģ¬ÎÒÃÇ¿ÉÒÔÀûÓÃÖØÐÂÈÕÖ¾Îļþ½øÐлָ´; µ±³ö ......
ʵÀý£º
1¡¢Í¨¹ýDBLINKµÄ·½Ê½£º±í¿Õ¼ä²»Ò»Ñù
impdp logfile=DUP_MCMDB.LOG network_link=to_crm_7 schemas=MCMDB REMAP_TABLESPACE=table_space11:table_space12,table_space21:table_space22
2¡¢Í¨¹ýDBLINKµÄ·½Ê½£º·½°¸£¨schemas£©²»Ò»Ñù
impdp logfile=DUP_MCMDB.LOG net ......