oracle´¥·¢redoдµÄËĸöÌõ¼þ
µ±LGWR´¦ÓÚ¿ÕÏÐ״̬ʱ£¬ËüÒÀÀµÓÚrdbms rpc messageµÈ´ýʼþ£¬´¦ÓÚÐÝÃß״̬£¬Ö±µ½ÈýÃëʱ¼äµ½£¬Èç¹ûÕâ¸öʱºòLGWR·¢ÏÖÓÐRedoÐÅÏ¢ÐèҪд³öµÄ»°£¬ÄÇôLGWR½«Ö´ÐÐдµÄ²Ù×÷£¬log file parallel writeµÈ´ýʼþ½«»á³öÏÖ¡£
¡¡¡¡×ܽáÒ»ÏÂRedoдµÄ´¥·¢Ìõ¼þ£º
¡¡¡¡1£¬Ã¿ÈýÃëÖÓ³¬Ê±(timeout)£º
µ±LGWR´¦ÓÚ¿ÕÏÐ״̬ʱ£¬ËüÒÀÀµÓÚrdbms rpc messageµÈ´ýʼþ£¬´¦ÓÚÐÝÃß״̬£¬Ö±µ½ÈýÃëʱ¼äµ½£¬Èç¹ûÕâ¸öʱºòLGWR·¢ÏÖÓÐRedoÐÅÏ¢ÐèҪд³öµÄ»°£¬ÄÇôLGWR½«Ö´ÐÐдµÄ²Ù×÷£¬log file parallel writeµÈ´ýʼþ½«»á³öÏÖ¡£
¡¡¡¡2.·§ÖµµÄ´ïµ½£º
¡¡¡¡Redo log buffer 1/3 Âú;
¡¡¡¡Redo log buffer ÓµÓÐ 1MB µÄÔàÊý¾Ý;
²ÎÊý_log_io_sizeµÄÉèÖúÜÖØÒª£¬Ò»°ãΪlog_bufferµÄ1/3´óС
¡¡¡¡3.Óû§Ìá½»£º
µ±Ò»¸ötransactionÌá½»µÄʱºò£¬ÔÚRedo streamÖн«¼Ç¼һ¸öÌá½»±êÖ¾¡£ÔÚÕâЩRedo±»Ð´µ½´ÅÅÌÉÏ֮ǰ£¬Õâ¸ötransactionÊDz»Äָܻ´µÄ¡£ËùÒÔ£¬ÔÚtransaction·µ»Ø³É¹¦±ê־֮ǰ£¬±ØÐëµÈ´ýLGWRдµÄÍê³É¡£½ø³Ì֪ͨLGWRд£¬²¢ÇÒÒÔlog file syncʼþ¿ªÊ¼ÐÝÃß¡£³¬Ê±Îª1Ãë
¡¡¡¡4.ÔÚDBWnд֮ǰ£º
¡¡¡¡Èç¹ûDBWR½«ÒªÐ´³öµÄÊý¾ÝµÄ¸ßRBA³¬¹ýLGWRµÄon-disk RBA£¬ÔòDBWR½«Í¨ÖªLGWRÖ´ÐÐдµÄ²Ù×÷£¬ÔÚOracle8i֮ǰ£¬´ËʱDBWR½«µÈ´ýLog file syncʼþ¡£´ÓOracle8i¿ªÊ¼£¬DBWR°ÑÕâЩblock(½«ÒªÐ´³öµÄblock£¬ÕâÖÖblockµÄ¸ßRBA³¬¹ýÁËLGWRµÄon-disk RBA)·ÅÈëdefer¶ÓÁÐÖУ¬Í¬Ê±Í¨ÖªLGWRÖ´ÐÐRedoд³ö¡£
¡¡¡¡×¢£ºlog buffer spaceµÈ´ýʼþ˵Ã÷log buffer¿Õ¼ä²»¹»ÓÃÁË¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
OracleÓ¦ÓÃϵͳµÄÓÅ»¯Ëĸö·½Ãæ
1.¡¡¡¡¡¡ Ó¦ÓóÌÐòSQLÓï¾äÓÅ»¯;
2.¡¡¡¡¡¡ ORACLEÊý¾Ý¿â²ÎÊýµ÷Õû;
3.¡¡¡¡¡¡ ²Ù×÷ϵͳ²ÎÊýµ÷Õû;
4.¡¡¡¡¡¡ ÍøÂçÐÔÄܵ÷Õû.
oracleÓ¦ÓÃϵͳµÄÐÔÄÜÖ¸±ê
1.¡¡¡¡¡¡ Êý¾Ý¿âÍÌÍÂÁ¿;
2.¡¡¡¡¡¡ Êý¾Ý¿âÓû§ÏìӦʱ¼ä.
ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯µÄ¼¸¸ö²¿·Ö
Êý¾Ý¿âÐÔÄÜÓÅ»¯°üÀ¨Èçϼ¸¸ö²¿·Ö£º
1¡¢1¡¢µ÷Õ ......
¡¡
¡¡
DML Data manipulation language
SELECT
SELECT [DISTINCT] *|ÁÐxx [AS] "±ðÃûxx"[,ÁÐxx "±ðÃûxx"...]
×Ö·û´®Á¬½Ó·û ||, ×Ö·û»òÈÕÆÚÀàÐ͵Ä×Ö·û´®Óõ¥ÒýºÅ’’, ÁбðÃûÓÃË«ÒýºÅ“”¡£Èç¹û±ðÃûÖÐÓпոñ¡¢ÌØÊâ×Ö·û»òÕßÒªÇóÇø·Ö´óСд£¬±ØÐëÓÃË«ÒýºÅ¡£Ä¬ÈÏÇé¿öÏÂÁбêÌâΪ´óд£¬ ......
±¾´Îoracle dataguard
»·¾³£º
²Ù×÷ϵͳ£ºwindows 2003 server
Êý¾Ý¿â£ºoracle 10g 10.2.0.1
ORACLE_HOME£ºD:\oracle\product\10.2.0\db_1
archive_dest£ºD:\archivelog
rman_dest£ºd:\rman_backup
»úÆ÷£º1̨
Ö÷¿âÃû³Æ£ºlearn
±¸¿âÃû³Æ£ºlearndg
ʵÑé²½Ö裺Ð޸ĺÃtnsnames¡¢listener¡¢pfileÎļþ£¬Í¨¹ýrmanµÄduplic ......