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/PLSQL: Lpad Function£º
http://www.techonthenet.com/oracle/functions/lpad.php
RPAD and LPAD [Oracle SQL]£º
http://www.adp-gmbh.ch/ora/sql/rpad.html
ÒýÊö
In Oracle/PLSQL, the lpad function pads the left-side of a string with a specific set of characters.
The syntax for the lpad funct ......
¼ÙÉèÊý¾Ý¿âµÄÓµÓÐÕßΪoracle£¬Êý¾Ý¿âµÄÓû§Îªscott£¬Æä¿ÚÁîΪtrigger£¬
OracleÊý¾Ý¿âµÄ²ÎÊý$ORACLE_HOMEΪ/usr/oracle£¬$ORACLE_SIDΪoracle1£¬ÔòʵÏÖ²½ÖèÈçÏ£º
1¡¢½¨Á¢ÊµÏÖ±¸·ÝµÄshell
ÔÚ/usr/oracleÖÐÓÃviÃüÁÁ¢Îļþbackup.sh£¬ÆäÄÚÈÝΪ:
ORACLE_HOME=/usr/oracle; <br>export ORACLE_HOME;
ORACLE_SID= ......
1.¿Í»§¶ËÁ¬½ÓÖÁoralce:
Ê×ÏÈ¿Í»§¶ËÁ¬½ÓÖÁoracleµÄ¼àÌýÆ÷,È»ºó¼àÌýÆ÷·ÖÅäÒ»¸öÊý¾Ý¿âʵÀý(ÕâÀïµÄÊÇʵÀý)¸ø¿Í»§¶Ë,È»ºó¿Í»§¶ËÒÔºó¾ÍÖ±½ÓÓëÕâ¸öÊý¾Ý¿âʵÀý½øÐÐÁ¬½Ó,Ö±ÖÁ¶Ï¿ªÓëoracleµÄÁ¬½Ó.
2.Ìá½»sql:
(1)¿Í»§¶ËÓû§Ìá½»Ò»¸ösql ......
ÈçºÎÓ¦¶ÔORACLEÊý¾Ý¿âµÄ²¿·ÖÃæÊÔÌâÄ¿
1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð:Èȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸· ......