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

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 and Rpad Function

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 ......

ÔÚlinuxÖÐʹÓÃcrontabʵÏÖ¶ÔoracleµÄ¶¨Ê±±¸·Ý

¼ÙÉèÊý¾Ý¿âµÄÓµÓÐÕßΪ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= ......

oracleÊÂÎñµÄÖ´Ðйý³Ì

1.¿Í»§¶ËÁ¬½ÓÖÁoralce:
             Ê×ÏÈ¿Í»§¶ËÁ¬½ÓÖÁoracleµÄ¼àÌýÆ÷,È»ºó¼àÌýÆ÷·ÖÅäÒ»¸öÊý¾Ý¿âʵÀý(ÕâÀïµÄÊÇʵÀý)¸ø¿Í»§¶Ë,È»ºó¿Í»§¶ËÒÔºó¾ÍÖ±½ÓÓëÕâ¸öÊý¾Ý¿âʵÀý½øÐÐÁ¬½Ó,Ö±ÖÁ¶Ï¿ªÓëoracleµÄÁ¬½Ó.
 
2.Ìá½»sql:
  (1)¿Í»§¶ËÓû§Ìá½»Ò»¸ösql ......

ÈçºÎÓ¦¶ÔORACLEÊý¾Ý¿âµÄ²¿·ÖÃæÊÔÌâÄ¿

ÈçºÎÓ¦¶ÔORACLEÊý¾Ý¿âµÄ²¿·ÖÃæÊÔÌâÄ¿
1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð:Èȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ