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

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 NLS_LANG²ÎÊýÏê½â

NLS_LANG²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG= <Language>_ <Territory>. <Clients Characterset>
ÆäÖУº
LANGUAGEÖ¸¶¨:
-OracleÏûϢʹÓõÄÓïÑÔ
-ÈÕÆÚÖÐÔ·ݺÍÈÕÏÔʾ
TERRITORYÖ¸¶¨
-»õ±ÒºÍÊý×Ö¸ñʽ
-µØÇøºÍ¼ÆËãÐÇÆÚ¼°ÈÕÆÚµÄÏ°¹ß
CHARACTERSET:
-¿ØÖÆ¿Í»§¶ËÓ¦ÓóÌÐòʹÓõÄ×Ö·û¼¯ ......

oracle µÝ¹é²éѯ


Start with...Connect By×Ó¾äµÝ¹é²éѯһ°ãÓÃÓÚÒ»¸ö±íά»¤Ê÷ÐνṹµÄÓ¦Óá£
´´½¨Ê¾Àý±í£º
CREATE TABLE TBL_TEST
(
  ID    NUMBER,
  NAME  VARCHAR2(100 BYTE),
  PID   NUMBER             &nbs ......

oracle wait event:reliable message

½ñÌì¿Í»§µÄÒ»Ì×RAC»·¾³³öÏÖÎÊÌâ
Ë«½ÚµãRAC»·¾³ÖУ¬Ò»¸ö½ÚµãÒòΪËø¾ºÕù¶ø¹ÒÆð£¬shutdownÖ®ºóÎÞ·¨Æô¶¯¡£
¹ÊÕϳöÏÖʱÎÒÕýÔÚ·ÉÏ£¬´Ò´Ò»Øµ½¼ÒÖУ¬´¦Àí¹ÊÕÏ¡£
½â¾öÖ®ºó²éÕÒ¹ÊÕÏÔ­Òò¡£
¼ì²éµ±Ê±µÄAWRÐÅÏ¢·¢ÏÖTop 5 Timed EventsÏÔʾÈçÏÂÐÅÏ¢£º
Top 5 Timed Events         &nb ......

oracleʵÏÖºº×Ö°´ÕÕÆ´Òô¡¢±Ê»­ºÍ²¿Ê×ÅÅÐò

oracleʵÏÖºº×Ö°´ÕÕÆ´Òô¡¢±Ê»­ºÍ²¿Ê×ÅÅÐò
ÕÒÁËÏà¹ØµÄһЩ×ÊÁÏ£¬¶¼ËµµÄ²»ÊǺÜÇå³þ£¬×Ô¼ºÒ²Ñо¿ÁËÏ£¬ÖÕÓÚ¸ãÃ÷°×ÁË£¬Ï£Íû¶Ô´ó¼ÒÓаïÖú¡£
ÐèҪ˵Ã÷µÄÊÇÏÂÃæµÄ·½·¨ÐèÒªORACLE9iºÍÒÔÉϵİ汾²ÅÖ§³Ö¡£
Oracle9i֮ǰ£¬ÖÐÎÄÊÇ°´ÕÕ¶þ½øÖƱàÂë½øÐÐÅÅÐòµÄ¡£
ÔÚoracle9iÖÐÐÂÔöÁË°´ÕÕÆ´Òô¡¢²¿Êס¢±Ê»­ÅÅÐò¹¦ÄÜ¡£ÉèÖÃNLS_SORTÖµ
......

¹ØÓÚoracle mutexºÍlatchµÄÎÊÌâ

¹ØÓÚlatchºÍmutexµÄÎÊÌâ
from:http://www.itpub.net/thread-1004815-1-1.html
A:
latchÊÇãÅËø£¬ÊÇÒ»ÖÖ´®Ðл¯»úÖÆ£¬ÓÃÀ´±£»¤SGAÖеÄÄÚ´æ½á¹¹¡£
mutexÊÇʲô£¬Ò²ÊÇÒ»ÖÖ´®Ðл¯»úÖÆ£¬ÊÇ»¥³âËø£¿
¸öÈ˶ÔmutexûÓÐʲô¸ÅÄî¡£Õâ¸öÊÇ10GÐÂÒý½øµÄ£¿9IºÃÏñûÓа¡¡£
ÄÄλÃ÷°×ÈË£¬¸ø°ïæÏêϸ½âÊÍÏÂmutex£¬×îºÃ»¹ÄܺÍlatch ×öϱȽ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ