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

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·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracleµÄDevel ......

Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ

¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿â
ϵͳǰ,ÓÐË­¶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQL
µÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
j8m ......

oracleµÄÕýÔò±í´ïʽ(regular expression)¼òµ¥½éÉÜ

Ä¿Ç°£¬ÕýÔò±í´ïʽÒѾ­ÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
 
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ Öظ´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
 
Oracle 10gÖ§³ÖÕýÔò±í´ïʽµÄËĸöк¯Êý ......

oracle ÔöÁ¿±¸·Ý½Å±¾


    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 ......

oracle LogMiner¼ò½é

Ô­ÎĵØÖ·£ºhttp://www.phontol.com/20090719_525808_1.html
1  LogMiner µÄÓÃ;
¡¡¡¡Oracle LogMiner ÊÇ Oracle¹«Ë¾´Ó²úÆ· 8iÒÔºóÌṩµÄÒ»¸öʵ¼Ê·Ç³£ÓÐÓõķÖÎö¹¤¾ß£¬Ê¹Óøù¤¾ß¿ÉÒÔÇáËÉ»ñµÃ OracleÖØ×÷ÈÕÖ¾Îļþ£¨¹éµµÈÕÖ¾Îļþ£©ÖеľßÌåÄÚÈÝ£¬ÌرðÊÇ£¬¸Ã ¹¤¾ß¿ÉÒÔ·ÖÎö³öËùÓжÔÓÚÊý¾Ý¿â²Ù×÷µÄ DML£¨insert¡¢update¡¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ