Oracle 9i LogMiner¹¤¾ßʹÓÃ˵Ã÷
ÔÎĵØÖ·£ºhttp://oracle.chinaitlab.com/induction/725752.html
Ò»¡¢logminerµÄÓÃ;
¡¡¡¡ÈÕÖ¾ÎļþÖдæ·Å×ÅËùÓнøÐÐÊý¾Ý¿â»Ö¸´µÄÊý¾Ý£¬¼Ç¼ÁËÕë¶ÔÊý¾Ý¿â½á¹¹µÄÿһ¸ö±ä»¯£¬Ò²¾ÍÊǶÔÊý¾Ý¿â²Ù×÷µÄËùÓÐDMLÓï¾ä¡£
¡¡¡¡logminer ¹¤¾ß¼´¿ÉÒÔÓÃÀ´·ÖÎöÔÚÏߣ¬Ò²¿ÉÒÔÓÃÀ´·ÖÎöÀëÏßÈÕÖ¾Îļþ£¬¼´¿ÉÒÔ·ÖÎö±¾Éí×Ô¼ºÊý¾Ý¿âµÄÖØ×÷ÈÕÖ¾Îļþ£¬Ò²¿ÉÒÔÓÃÀ´·ÖÎöÆäËûÊý¾Ý¿âµÄÖØ×÷ÈÕÖ¾Îļþ¡£
¡¡¡¡×ܵÄ˵À´£¬logminer¹¤¾ßµÄÖ÷ÒªÓÃ;ÓУº
¡¡¡¡¡¡1£® ¸ú×ÙÊý¾Ý¿âµÄ±ä»¯£º¿ÉÒÔÀëÏߵĸú×ÙÊý¾Ý¿âµÄ±ä»¯£¬¶ø²»»áÓ°ÏìÔÚÏßϵͳµÄÐÔÄÜ¡£
¡¡¡¡¡¡2£® »ØÍËÊý¾Ý¿âµÄ±ä»¯£º»ØÍËÌض¨µÄ±ä»¯Êý¾Ý£¬¼õÉÙpoint-in-time recoveryµÄÖ´ÐС£
¡¡¡¡¡¡3£® ÓÅ»¯ºÍÀ©Èݼƻ®£º¿Éͨ¹ý·ÖÎöÈÕÖ¾ÎļþÖеÄÊý¾ÝÒÔ·ÖÎöÊý¾ÝÔö³¤Ä£Ê½¡£
¶þ¡¢°²×°logminer
¡¡¡¡Òª°²×°logminer¹¤¾ß£¬±ØÐëÊ×ÏÈÒªÔËÐÐÏÂÃæÕâÑùÁ½¸ö½Å±¾£¬
¡¡¡¡¡¡l¡¢ $ORACLE_HOME/rdbms/admin/dbmslm.sql
¡¡¡¡ 2 ¡¢$ORACLE_HOME/rdbms/admin/dbmslmd.sql
¡¡¡¡ 3¡¢ $ORACLE_HOME/rdbms/admin/dbmslms.sql
¡¡¡¡ÕâÁ½¸ö½Å±¾±ØÐë¾ùÒÔSYSÓû§Éí·ÝÔËÐС£ÆäÖеÚÒ»¸ö½Å±¾ÓÃÀ´´´½¨DBMS_LOGMNR°ü£¬¸Ã°üÓÃÀ´·ÖÎöÈÕÖ¾Îļþ¡£µÚ¶þ¸ö½Å±¾ÓÃÀ´´´½¨DBMS_LOGMNR_D°ü£¬¸Ã°üÓÃÀ´´´½¨Êý¾Ý×ÖµäÎļþ¡£
Èý¡¢Ê¹ÓÃlogminer¹¤¾ß
¡¡¡¡ÏÂÃ潫Ïêϸ½éÉÜÈçºÎʹÓÃlogminer¹¤¾ß¡£
¡¡¡¡1¡¢´´½¨Êý¾Ý×ÖµäÎļþ£¨data-dictionary£©
¡¡¡¡Ç°ÃæÒѾ̸µ½£¬logminer¹¤¾ßʵ¼ÊÉÏÊÇÓÉÁ½¸öеÄPL/SQLÄÚ½¨°ü£¨(DBMS_LOGMNR ºÍ DBMS_ LOGMNR_D)ºÍËĸöV$¶¯Ì¬ÐÔÄÜÊÓͼ£¨ÊÓͼÊÇÔÚÀûÓùý³ÌDBMS_LOGMNR.START_LOGMNRÆô¶¯logminerʱ´´½¨£©×é³É¡£ÔÚʹÓÃlogminer¹¤¾ß·ÖÎöredo logÎļþ֮ǰ£¬±ØÐëʹÓÃDBMS_LOGMNR_D °ü½«Êý¾Ý×ֵ䵼³öΪһ¸öÎı¾Îļþ¡£¸Ã×ÖµäÎļþÊÇ¿ÉÑ¡µÄ£¬µ«ÊÇÈç¹ûûÓÐËü£¬logminer½âÊͳöÀ´µÄÓï¾äÖйØÓÚÊý¾Ý×ÖµäÖеIJ¿·Ö£¨Èç±íÃû¡¢ÁÐÃûµÈ£©ºÍÊýÖµ¶¼½«ÊÇ16½øÖƵÄÐÎʽ£¬ÎÒÃÇÊÇÎÞ·¨Ö±½ÓÀí½âµÄ¡£ÀýÈ磬ÏÂÃæµÄsqlÓï¾ä£º INSERT INTO dm_dj_swry (rydm, rymc) £¦#118alueS (00005, 'ÕÅÈý'); logminer½âÊͳöÀ´µÄ½á¹û½«ÊÇÏÂÃæÕâ¸öÑù×Ó£¬ insert into Object#308(col#1, col#2) £¦#118alues (hextoraw('c30rte567e436'), hextoraw('4a6f686e20446f65'));
¡¡¡¡´´½¨Êý¾Ý×ÖµäµÄÄ¿µÄ¾ÍÊÇÈÃlogminerÒýÓÃÉæ¼°µ½ÄÚ²¿Êý¾Ý×ÖµäÖеIJ¿·ÖʱΪËûÃÇʵ¼ÊµÄÃû×Ö£¬¶ø²»ÊÇϵͳÄÚ²¿µÄ16½øÖÆ¡£Êý¾Ý×ÖµäÎļþÊÇÒ»¸öÎı¾Îļþ£¬Ê¹ÓðüDBMS_LOGMNR_DÀ´´´½¨¡£Èç¹ûÎÒÃÇÒª·ÖÎöµÄÊý¾Ý¿âÖеıíÓб仯£¬Ó°Ïìµ½¿âµÄÊý¾
Ïà¹ØÎĵµ£º
C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®
http://developer.51cto.com
2009-08-20 17:55 ØýÃû °Ù¶È¿Õ¼ä ÎÒÒªÆÀÂÛ(
0
)
C#Á¬½ÓOracleÊý¾Ý¿âÒÔ¼°C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®µÈÄÚÈݽ«ÔÚ±¾ÎÄÖÐÕ¹ÏÖ£¬Ï£Íû±¾ÎÄÄܶԴó¼ÒÁ˽âC#Á¬½ÓÊý¾Ý¿âÓÐËù°ïÖú¡£
C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®£¨²éѯÊý¾Ý£©
using
Syst ......
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿â
ϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQL
µÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
j8m ......
ÖØ×öÈÕÖ¾ÎļþÊÇOracleÊý¾Ý¿âÖÐÒ»Öַdz£ÖØÒªµÄÈÕÖ¾Îļþ£¬Ò²ÊÇÆäÒ»¸öºÜÓÐÌØÉ«µÄ¹¦ÄÜ¡£ÖØ×öÈÕÖ¾Îļþ»á¼Í¼¶ÔÓÚÊý¾Ý¿âµÄÈκβÙ×÷£¬ÈçÀûÓÃDMLÓï¾ä»òÕßDDLÓï¾ä¶ÔÊý¾Ý½øÐиü¸Ä£¬»òÕßÊý¾Ý¿â¹ÜÀíÔ±¶ÔÊý¾Ý¿â½á¹¹½øÐиü¸Ä£¬¶¼»áÔÚÖØ×öÈÕÖ¾ÖнøÐмǼ¡£
¡¡¡¡¿É¼û£¬µ±Êý¾Ý±»ÒâÍâµÄɾ³ý»òÕßÐ޸ģ¬ÎÒÃÇ¿ÉÒÔÀûÓÃÖØÐÂÈÕÖ¾Îļþ½øÐлָ´; µ±³ö ......
Ò»¸öÓû§¿ÉÒÔʹÓÃÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¬Ò»¸ö±í¿Õ¼äÒ²¿ÉÒÔ¹©¶à¸öÓû§Ê¹Óá£Óû§ºÍ±í¿Õ¼äûÓÐÁ¥Êô¹Øϵ£¬±í¿ÕÊÇÒ»¸öÓÃÀ´¹ÜÀíÊý¾Ý´æ´¢Âß¼¸ÅÄ±í¿Õ¼äÖ»ÊǺÍÊý¾ÝÎļþ·¢Éú¹Øϵ£¬Êý¾ÝÎļþÊÇÎïÀíµÄ£¬Ò»¸ö±í¿Õ¼ä¿ÉÒÔ°üº¬¶à¸öÊý¾ÝÎļþ£¬¶øÒ»¸öÊý¾ÝÎļþÖ»ÄÜÁ¥ÊôÒ»¸ö±í¿Õ¼ä¡£
Óû§ÊôÓÚÊý¾Ý¿âʵÀýµ ......