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£¨ÓÃÓÚÖØ×öÈÕÖ¾£©
Ïà¹ØÎĵµ£º
Oracle 10.2.0.1µÄPatchµµÖð½¥ÐγÉÁ˼Ò×åÌåϵÁË,ÏÖÔÚÈôó¼ÒÀ´ÈÏʶһÏÂÕâ¸öÌåϵ°É!µ½Ä¿Ç°Ëù·¢²¼µÄÖ÷ÒªµÄPatchÓÐ10.2.0.2,10.2.0.3,10.2.0.4,10.2.0.4.1,10.2.0.4.2,10.2.0.4.3,10.2.0.5.
֮ǰÔÚ32λºÍ64λLinuxÏ°²×°Á˽ÏΪÎȶ¨µÄOracle 10G for Linux x86º ......
Ò»¡¢Oracle PackageµÄ×÷ÓÃ
1¡¢¶¨ÒåÓë˵Ã÷
a. Ïà¹Ø¶ÔÏó£¨×Ô¶¨ÒåÀàÐÍ¡¢º¯Êý¡¢´æ´¢¹ý³ÌµÈ£©µÄ·â×°
b. ³ÌÐò°üµÄ¸÷²¿·Ö
- ³ÌÐò°ü¹æ¸ñ˵Ã÷
ÉùÃ÷×Ó³ÌÐò
- ³ÌÐò°üÖ÷Ìå
&n ......
½ñÌì¿Í»§µÄÒ»Ì×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 ×öϱȽ ......