Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

oracle µÝ¹é²éѯ


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

Oracle PackageÖд洢¹ý³Ì·µ»ØÓαê

Ò»¡¢Oracle PackageµÄ×÷ÓÃ
1¡¢¶¨ÒåÓë˵Ã÷
  a. Ïà¹Ø¶ÔÏó£¨×Ô¶¨ÒåÀàÐÍ¡¢º¯Êý¡¢´æ´¢¹ý³ÌµÈ£©µÄ·â×°
  b. ³ÌÐò°üµÄ¸÷²¿·Ö
    - ³ÌÐò°ü¹æ¸ñ˵Ã÷
          ÉùÃ÷×Ó³ÌÐò
   - ³ÌÐò°üÖ÷Ìå
      &n ......

oracle wait event:PX Deq Credit: send blkd

Just a few days ago a got to two Oracle DBAs discussing why the have so much “PX Deq Credit : send blkd” on a system. And if that is causing their performance problems.
The are some blog on the internet claiming it has to do with qc distribution and what ever.
But in many cases, especi ......

¹ØÓÚ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ºÅ