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À´´´½¨¡£Èç¹ûÎÒÃÇÒª·ÖÎöµÄÊý¾Ý¿âÖеıíÓб仯£¬Ó°Ïìµ½¿âµÄÊý¾
Ïà¹ØÎĵµ£º
oracleµÄÌåϵ̫ÅÓ´óÁË£¬¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÄÑÃâ»áÓÐЩÎÞ´ÓÏÂÊֵĸоõ£¬Ê²Ã´¶¼Ïëѧ£¬½á¹ûʲô¶¼Ñ§²»ºÃ£¬ËùÒÔ°Ñѧϰ¾Ñé¹²Ïíһϣ¬Ï£ÍûÈøոÕÈëÃŵÄÈ˶ÔoracleÓÐÒ»¸ö×ÜÌåµÄÈÏʶ£¬ÉÙ×ßһЩÍä·¡£
Ò»¡¢¶¨Î»
oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracleµÄDevel ......
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿â
ϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQL
µÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
j8m ......
Ä¿Ç°£¬ÕýÔò±í´ïʽÒѾÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ Öظ´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
Oracle 10gÖ§³ÖÕýÔò±í´ïʽµÄËĸöк¯Êý ......
OS :RHEL AS 4 oracle 10g
0±¸·Ý½Å±¾
#!/bin/bash
# incremental level 0 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`
mkdir /home/ora ......
ÔÎĵØÖ·£ºhttp://www.phontol.com/20090719_525808_1.html
1 LogMiner µÄÓÃ;
¡¡¡¡Oracle LogMiner ÊÇ Oracle¹«Ë¾´Ó²úÆ· 8iÒÔºóÌṩµÄÒ»¸öʵ¼Ê·Ç³£ÓÐÓõķÖÎö¹¤¾ß£¬Ê¹Óøù¤¾ß¿ÉÒÔÇáËÉ»ñµÃ OracleÖØ×÷ÈÕÖ¾Îļþ£¨¹éµµÈÕÖ¾Îļþ£©ÖеľßÌåÄÚÈÝ£¬ÌرðÊÇ£¬¸Ã ¹¤¾ß¿ÉÒÔ·ÖÎö³öËùÓжÔÓÚÊý¾Ý¿â²Ù×÷µÄ DML£¨insert¡¢update¡¢ ......