oracle asm ´´½¨Óë¹ÜÀí
ASM
ASM¿ÉÒÔÌõ´ø»¯ºÍ¾µÏñ´ÅÅÌ£¬Òò´Ë¿ÉÒÔÔÚÊý¾Ý¿â±¸¼ÓÔØµÄÇé¿öÏÂÌí¼Ó¡¢É¾³ý´ÅÅÌ¡¢ÒÔ¼°×Ô¶¯Æ½ºâIO¡£
ASM²»ÊÇÒ»¸öÎļþϵͳ£¬ËùÒÔÎÞ·¨´Ó²Ù×÷ϵͳ·ÃÎÊASM´æ´¢µÄÎļþ£¬¶ÔÓÚʹÓÃASMµÄÊý¾Ý¿âÖ»ÄÜÓÃRMAN½øÐб¸·ÝºÍ»Ö¸´¡£
ASM×÷Ϊµ¥¶ÀµÄORACLEʵÀýʵʩ£¬Ö»ÓÐASMÔËÐÐʱÊý¾Ý¿â²ÅÄÜ·ÃÎÊ¡£
Ò»¡¢´ÅÅÌ×é
ASMÌṩÁËÈýÖдÅÅÌ×éÀàÐÍ
1 normal redundacy Ö§³ÖµÄÓ³ÏñµÈ¼¶ÓÐ 2-WAY¡¢3-WAY¡¢²»±£»¤ £¬È±Ê¡µÄ2-WAY
±ê×¼ÈßÓà¶ÈÒªÇóÌṩ˫Ïò¾µÏñ£¬²¢ÇÒÒªÇóÔÚÒ»¸ö´ÅÅÌ×éÖУ¬ÖÁÉÙÓÐ2¸ö¹ÊÕÏ×飨failure groups)£¬¹ÊÕÏ×éÖеÄÒ»¸ö´ÅÅ̳öÏÖ¹ÊÕϲ»
²»»áµ¼Ö´ÅÅ̹ÊÍ£Ö¹¹¤×÷£¬Ò²²»»á¶ªÊ§Êý¾Ý£¬¶Ô²éѯ´ÅÅÌ×éµÄ¶ÔÏóÓÐЩÐÔÄÜÓ°Ï죬Õâ¸öʱºò¾ÍÐèÒª¹ÜÀíÔ±µ÷Õû
2 high redundancy Ö§³ÖµÄÓ³ÏñµÈ¼¶ 3-WAY
¸ßÈßÓà¶ÈÌṩÈýÏòÓ³Ïñ£¬²¢ÇÒÔÚÒ»¸ö´ÅÅÌ×éÖÁÉÙÓÐ3¸ö¹ÊÕÏ×é¡£¹ÊÕÏ×éÖÐÈÎºÎÆäÖÐÁ½×é³öÏÖ¹ÊÕÏ£¬¶ÔÓû§À´Ëµ¾ÍÏó±ê×¼ÈßÓàÒ»Ñù
3 external redundancy ²»±£»¤
±íÃæÈßÓ࣬½ôÒªÇóÓÐÒ»¸ö¹ÊÕÏ×飬
ÔÚÅäÖôÅÅÌ×éʱ£¬¾¡Á¿°ÑͬһÀàÐ͵ĴÅÅ̷ŵ½Ò»¸ö×éÀ±ÜÃⲻͬÀàÐ͵ĴÅÅÌÔÚÒ»¸ö×éÀïÒÔÃâÓ°ÏìÐÔÄÜ
¶þ¡¢Îļþ
дÔÚASM´ÅÅÌÉϵÄÎļþ³ÆÖ®ÎªASMÎļþ£¬ËûÃǵÄÃû×ÖÊÇÓÉASM×Ô¶¯Éú³ÉµÄ£¬Äã¿ÉÒÔÖ¸¶¨Ò»¸ö±ðÃû¶ÔÒ»¸öASMÎļþ£¬Äã¿ÉÒÔ´´½¨Ò»¸öĿ¼
SQL> select name,type,total_mb,free_mb from v$asm_diskgroup;
NAME TYPE TOTAL_MB FREE_MB
—————————— —— ———- ———-
DATA EXTERN 7248 5489
±ÈÈç˵ÎÒÔÚDATA´ÅÅÌ×éÉÏ´´½¨Ò»¸öBOSONĿ¼
alter diskgroup data add directory ‘+data/boson’;
SQL> alter diskgroup data add directory ‘+data/boson’;
Diskgroup altered.
¿´Ò»ÏÂÎÒµÄÊý¾ÝÎļþ
SQL&g
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Êýѧº¯Êý
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as in ......
declare
STR VARCHAR2(400);
begin
-- ÖØ½¨ORACLEË÷Òý
FOR TMP_IDX IN (SELECT TABLESPACE_NAME, OWNER, TABLE_NAME, INDEX_NAME
&nb ......
Ò».Ëø
Êý¾Ý¿âʹÓÃËø£¨lock£© À´±£Ö¤Èκθø¶¨Ê±¿Ì×î¶àÖ»ÓÐÒ»¸öÊÂÎñÔÚÐ޸ĸø¶¨µÄÒ»¶ÎÊý¾Ý¡£ÊµÖÊÉϽ²£¬
ÕýÊÇËø»úÖÆ²Åʹ²¢·¢¿ØÖƳÉΪ¿ÉÄÜ¡£ÀýÈ磬Èç¹ûûÓÐijÖÖËø¶¨Ä£ÐÍÀ´×èÖ¹¶ÔͬһÐеIJ¢·¢¸üУ¬Êý¾Ý¿â¾Í
²»¿ÉÄÜÌṩ¶àÓû§·ÃÎÊ¡£²»¹ý£¬Èç¹ûÀÄÓûòÕßʹÓò»µ±£¬Ëø·´µ¹»á×è°²¢·¢ÐÔ¡£Èç¹ûÄã»òÊý¾Ý¿â±¾Éí²»±Ø
ÒªµØ¶ÔÊý¾Ý ......