Oracle 10g ÌØÐÔ: ͨ¹ý±¸·ÝʵÏÖ¿É´«Êä±í¿Õ¼ä
Oracle 10g ÌØÐÔ: ͨ¹ý±¸·ÝʵÏÖ¿É´«Êä±í¿Õ¼ä
Oracle8i ÖÐÒýÈëµÄ¿É´«Êä±í¿Õ¼äΪʵÏÖ¸ü¿ìµÄ¿çÊý¾Ý¿âÊý¾Ý´«ÊäÌṩÁËÆÈÇÐÐèÒªµÄÖ§³Ö¡£Ê¹ÓôËÌØÐÔ£¬Äú¿ÉÒÔÖ»µ¼³ö±í¿Õ¼äµÄÔªÊý¾Ý¡¢´«ÊäÊý¾ÝÎļþ²¢½«×ª´¢Îļþµ¼³öµ½Ä¿±êÊý¾Ý¿âÖ÷»úÒÔ¼°µ¼ÈëÔªÊý¾ÝÒÔ½«±í¿Õ¼ä“²åÈ딵½Ä¿±êÊý¾Ý¿âÖС£¸Ã±í¿Õ¼äÖеÄÊý¾ÝÔÚÄ¿±êÊý¾Ý¿âÖÐËæ¼´¿ÉÓ᣸÷½·¨½â¾öÁËÊý¾Ý²Ö¿âÖÐÔøÒ»¶È´æÔÚµÄÒ»¸öºÜ¼¬ÊÖµÄÎÊÌ⣺¿ìËÙ¡¢¸ßЧµØ¿çÊý¾Ý¿âÒƶ¯Êý¾Ý¡£
µ«ÔÚ OLTP Êý¾Ý¿âÖУ¬¸ÃÌõ¼þͨ³£ÊDz»¿ÉÄÜ´æÔڵģ¬Òò´Ë´«Êä±í¿Õ¼äÒ²ÊDz»¿ÉÄܵġ£Èç¹û OLTP Êý¾Ý¿âÊÇÊý¾Ý²Ö¿âµÄÊý¾ÝÔ´£¬ÔòÄú¿ÉÄÜʼÖÕÎÞ·¨Ê¹Óÿɴ«Êä±í¿Õ¼ä¼ÓÔØËü¡£
ÔÚ Oracle Êý¾Ý¿â 10g µÚ 2 °æÖУ¬¿ÉÒÔ´«Êä±í¿Õ¼ä²¢´ÓÁíÒ»¸öÊý¾ÝÔ´£¨¼´±¸·Ý£©ÖвåÈëËü¡£ÀýÈ磬Èç¹ûÒª´«Êä±í¿Õ¼ä ACCDATA£¬Ôò¿ÉÒÔ·¢³ö RMAN ÃüÁî
RMAN> transport tablespace accdata
2> TABLESPACE DESTINATION = '/home/oracle'
3> auxiliary destination = '/home/oracle';
¸ÃÃüÁîÔÚλÖà /home/oracle Öд´½¨Ò»¸ö¸¨ÖúʵÀý£¬²¢´ÓÆäÖеı¸·Ý»Ö¸´Îļþ¡£´Ë¸¨ÖúʵÀýµÄÃû³ÆÊÇËæ»úÉú³ÉµÄ¡£´´½¨ÊµÀýºó£¬¸Ã¹ý³Ì½«»ùÓÚĿ¼´´½¨Ò»¸öĿ¼¶ÔÏ󣬲¢»Ö¸´±í¿Õ¼ä ACCDATA£¨ÎÒÃÇÕýÔÚ´«ÊäµÄ±í¿Õ¼ä£©µÄÎļþ - ËùÓвÙ×÷¾ù×Ô¶¯Íê³É£¬Äú²»±Ø·¢³öÈκÎÃüÁ
Ŀ¼ /home/oracle ½«°üº¬±í¿Õ¼ä ACCDATA µÄËùÓÐÊý¾ÝÎļþ¡¢±í¿Õ¼äÔªÊý¾ÝµÄת´¢ÎļþÒÔ¼°½Å±¾ impscrpt.sql£¨×îÖØÒªµÄ£©¡£¸Ã½Å±¾°üº¬½«´Ë±í¿Õ¼ä²åÈëÄ¿±ê±í¿Õ¼äËù±ØÐèµÄËùÓÐÃüÁî¡£¸Ã±í¿Õ¼ä²¢·ÇÓÉ impdp ÃüÁî½øÐд«Ê䣬¶øÊÇͨ¹ý¶Ô dbms_streams_tablespace_adm.attach_tablespaces ³ÌÐò°üµÄµ÷ÓýøÐд«Êä¡£¿ÉÒÔÔڸýű¾ÖÐÕÒµ½ËùÓбØÒªµÄÃüÁî¡£
Äú¿ÉÄÜ»áÎÊ£¬Èç¹û³öÏÖ´íÎó¸ÃÔõô°ì£¿ÕâÖÖÇé¿öÏ£¬¿ÉÒÔÇáËɵؽøÐÐÕï¶Ï¡£Ê×ÏÈ£¬¸Ã¸¨ÖúʵÀýÔÚ $ORACLE_HOME/rdbms/log Öд´½¨¾¯±¨ÈÕÖ¾Îļþ£¬ÒÔ±ãÄú¿ÉÒÔ¼ì²é¸ÃÈÕÖ¾ÒÔ²éÃ÷DZÔÚµÄÎÊÌâ¡£Æä´Î£¬ÔÚÌṩ RMAN ÃüÁîʱ£¬Äú¿ÉÒÔͨ¹ý·¢³ö RMAN ÃüÁ¸ÃÃüÁËùÓÐÊä³öÖÃÓÚÎļþ tts.log ÖУ©½«ÃüÁîºÍÊä³öÖض¨Ïòµ½ÈÕÖ¾Îļþ
rman target=/ log=tts.log
È»ºó£¬Äú±ã¿ÉÒÔ¼ì²é¸ÃÎļþÀ´²éÃ÷¹ÊÕϵÄÈ·ÇÐÔÒò¡£
×îºó£¬½«°ÑÕâЩÎļþ»Ö¸´µ½ /home/oracle µÄ TSPITR_<SourceSID>_<AuxSID> Ŀ¼ÖС£ÀýÈ磬Èç¹ûÖ÷Êý¾Ý¿âµÄ SID Ϊ ACCT£¬RMAN ´´½¨µÄ¸¨ÖúʵÀýµÄ SID Ϊ KYED£¬ÔòĿ¼ÃûΪ TSPITR_ACCT_KYED¡£¸ÃĿ¼»¹°üº¬Á½¸öÆäËû×ÓĿ¼£ºdatafile£¨ÓÃÓÚÊý¾ÝÎļþ£©ºÍ onlinelog£¨ÓÃÓÚÖØ×öÈÕÖ¾£©
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
ͨ¹ýJAVAµ÷ÓÃORACLEµÄ´æ´¢¹ý³Ì£¬ÔÚORACLEµÄ´æ´¢¹ý³ÌÄÚ²¿×öÁËÒ»¸ö²éѯÔÚJAVAÖлñÈ¡¸Ã²éѯ½á¹û£¬Õâ¸öºÍSYBASE¡¢SQLSERVERµÄ»ñÈ¡²»Ò»Ñù£¬µÈÎÒµÄÏÂһƪÎÄÕÂÎÒ»á½éÉÜÈçºÎ»ñÈ¡SYBASE¡¢SQLSERVERÔÚ´æ´¢¹ý³ÌÖÐÖ´ÐÐÁ˲éѯºóÈçºÎ»ñÈ¡Æä½á¹û¼°´æ´¢¹ý³ÌµÄ±àд¡£
ÔÚOracleÖÐÐèÒª·µ»Ø²éѯ½á¹û¼¯£¬±ØÐ뽫ÆäÒÔÓαêµÄÐÎʽ·µ»Ø£¬µ«ÓαêÓÖ²»ÊÇ ......
½ñÌì¿Í»§µÄÒ»Ì×RAC»·¾³³öÏÖÎÊÌâ
Ë«½ÚµãRAC»·¾³ÖУ¬Ò»¸ö½ÚµãÒòΪËø¾ºÕù¶ø¹ÒÆð£¬shutdownÖ®ºóÎÞ·¨Æô¶¯¡£
¹ÊÕϳöÏÖʱÎÒÕýÔÚ·ÉÏ£¬´Ò´Ò»Øµ½¼ÒÖУ¬´¦Àí¹ÊÕÏ¡£
½â¾öÖ®ºó²éÕÒ¹ÊÕÏÔÒò¡£
¼ì²éµ±Ê±µÄAWRÐÅÏ¢·¢ÏÖTop 5 Timed EventsÏÔʾÈçÏÂÐÅÏ¢£º
Top 5 Timed Events &nb ......
¹ØÓÚlatchºÍmutexµÄÎÊÌâ
from:http://www.itpub.net/thread-1004815-1-1.html
A:
latchÊÇãÅËø£¬ÊÇÒ»ÖÖ´®Ðл¯»úÖÆ£¬ÓÃÀ´±£»¤SGAÖеÄÄÚ´æ½á¹¹¡£
mutexÊÇʲô£¬Ò²ÊÇÒ»ÖÖ´®Ðл¯»úÖÆ£¬ÊÇ»¥³âËø£¿
¸öÈ˶ÔmutexûÓÐʲô¸ÅÄî¡£Õâ¸öÊÇ10GÐÂÒý½øµÄ£¿9IºÃÏñûÓа¡¡£
ÄÄλÃ÷°×ÈË£¬¸ø°ïæÏêϸ½âÊÍÏÂmutex£¬×îºÃ»¹ÄܺÍlatch ×öϱȽ ......