Oracle Logminer
LogminerÊÇoracle´Ó8i¿ªÊ¼ÌṩµÄÓÃÓÚ·ÖÎöÖØ×öÈÕÖ¾ÐÅÏ¢µÄ¹¤¾ß£¬Ëü°üÀ¨DBMS_LOGMNRºÍDBMS_LOGMNR_DÁ½¸öpackage£¬ºó±ßµÄDÊÇ×ÖµäµÄÒâ˼¡£Ëü¼ÈÄÜ·ÖÎöredo log file£¬Ò²ÄÜ·ÖÎö¹éµµºóµÄarchive log file¡£ÔÚ·ÖÎöÈÕÖ¾µÄ¹ý³ÌÖÐÐèҪʹÓÃÊý¾Ý×ֵ䣬һ°ãÏÈÉú³ÉÊý¾Ý×ÖµäÎļþºóʹÓã¬10gÒÔºóµÄ°æ±¾»¹¿ÉÒÔʹÓÃÔÚÏßÊý¾Ý×ֵ䡣
Logminer¿ÉÒÔ·ÖÎöÆäËüÊý¾Ý¿âµÄÖØ×öÈÕÖ¾Îļþ£¬µ«ÊDZØÐëʹÓÃÖØ×öÈÕÖ¾ËùÔÚÊý¾Ý¿âµÄÊý¾Ý×ֵ䣬·ñÔò»á³öÏÖÎÞ·¨Ê¶±ðµÄÂÒÂë¡£ÁíÍâ±»·ÖÎöÊý¾Ý¿âµÄ²Ù×÷ϵͳƽ̨×îºÃºÍµ±Ç°LogminerËùÔÚÊý¾Ý¿âµÄÔËÐÐÆ½Ì¨Ò»Ñù£¬ÇÒblock sizeÏàͬ¡£
LogMinerÓÃÓÚ·ÖÎöÖØ×öÈÕÖ¾ºÍ¹éµµÈÕÖ¾Ëù¼ÇÔØµÄÊÂÎñ²Ù×÷¡£
Ò»¡¢È·¶¨Êý¾Ý¿âµÄÂß¼Ëð»µÊ±¼ä¡£¼Ù¶¨Ä³¸öÓû§Ö´ÐÐdrop tableÎóɾ³ýÁËÖØÒª±ísales£¬Í¨¹ýLogMiner¿ÉÒÔ׼ȷ¶¨Î»¸ÃÎó²Ù×÷µÄÖ´ÐÐʱ¼äºÍSCNÖµ£¬È»ºóͨ¹ý»ùÓÚʱ¼ä»Ö¸´»òÕß»ùÓÚSCN»Ö¸´¿ÉÒÔÍêÈ«»Ö¸´¸Ã±íÊý¾Ý¡£
¶þ¡¢È·¶¨ÊÂÎñ¼¶ÒªÖ´Ðеľ«Ï¸Âß¼»Ö¸´²Ù×÷¡£¼Ù¶¨Ä³Ð©Óû§ÔÚij±íÉÏÖ´ÐÐÁËһϵÁÐDML²Ù×÷²¢Ìá½»ÁËÊÂÎñ£¬²¢ÇÒÆäÖÐij¸öÓû§µÄDML²Ù×÷´æÔÚ´íÎó¡£Í¨¹ýLogMiner¿ÉÒÔÈ¡µÃÈκÎÓû§µÄDML²Ù×÷¼°ÏàÓ¦µÄUNDO²Ù×÷£¬Í¨¹ýÖ´ÐÐUNDO²Ù×÷¿ÉÒÔÈ¡ÏûÓû§µÄ´íÎó²Ù×÷¡£
Èý¡¢Ö´ÐкóÐøÉ󼯡£Í¨¹ýLogMiner¿ÉÒÔ¸ú×ÙOracleÊý¾Ý¿âµÄËùÓÐDML¡¢DDLºÍDCL²Ù×÷£¬´Ó¶øÈ¡µÃÖ´ÐÐÕâЩ²Ù×÷µÄʱ¼ä˳Ðò¡¢Ö´ÐÐÕâЩ²Ù×÷µÄÓû§µÈÐÅÏ¢¡£
1¡¢LogMiner»ù±¾¶ÔÏó
¡¡Ô´Êý¾Ý¿â£¨source database£©£º¸ÃÊý¾Ý¿âÊÇÖ¸°üº¬ÁËÒª·ÖÎöÖØ×öÈÕÖ¾ºÍ¹éµµÈÕÖ¾µÄ²úÆ·Êý¾Ý¿â¡£
·ÖÎöÊý¾Ý¿â£¨mining database£©£º¸ÃÊý¾Ý¿âÊÇÖ¸Ö´ÐÐLogMiner²Ù×÷ËùҪʹÓõÄÊý¾Ý¿â¡£¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
LogMiner×ֵ䣺LogMiner×ÖµäÓÃÓÚ½«ÄÚ²¿¶ÔÏóIDºÅºÍÊý¾ÝÀàÐÍת»»Îª¶ÔÏóÃûºÍÍⲿÊý¾Ý¸ñʽ¡£Ê¹ÓÃLogMiner·ÖÎöÖØ×öÈÕÖ¾ºÍ¹éµµÈÕ־ʱ£¬Ó¦¸ÃÉú³ÉLogMiner×ֵ䣬·ñÔò½«ÎÞ·¨¶Á¶®·ÖÎö½á¹û¡£
2¡¢LogMinerÅäÖÃÒªÇó
£¨1£©Ô´Êý¾Ý¿âºÍ·ÖÎöÊý¾Ý¿â(Ô´Êý¾Ý¿âºÍ·ÖÎöÊý¾Ý¿â¿ÉÒÔÊÇͬһ¸öÊý¾Ý¿â£©
Ô´Êý¾Ý¿âºÍ·ÖÎöÊý¾Ý¿â±ØÐëÔËÐÐÔÚÏàͬӲ¼þƽ̨ÉÏ£»
·ÖÎöÊý¾Ý¿â¿ÉÒÔÊǶÀÁ¢Êý¾Ý¿â»òÔ´Êý¾Ý¿â£»
·ÖÎöÊý¾Ý¿âµÄ°æ±¾²»ÄܵÍÓÚÔ´Êý¾Ý¿âµÄ°æ±¾£»
·ÖÎöÊý¾Ý¿âÓëÔ´Êý¾Ý¿â±ØÐë¾ßÓÐÏàͬµÄ×Ö·û¼¯¡£
£¨2£©LogMiner×ֵ䣺LogMiner×ֵ䱨ÐëÔÚÔ´Êý¾Ý¿âÖÐÉú³É¡£
£¨3£©ÖØ×öÈÕÖ¾Îļþ
µ±·ÖÎö¶à¸öÖØ×öÈÕÖ¾ºÍ¹éµµÈÕ־ʱ£¬ËüÃDZØÐëÊÇͬһ¸öÔ´Êý¾Ý¿âµÄÖØ×öÈÕÖ¾ºÍ¹éµµÈÕÖ¾£»
µ±·ÖÎö¶à¸öÖØ×öÈÕÖ¾ºÍ¹éµµÈÕ־ʱ£¬ËüÃDZØÐë¾ßÓÐÏàͬµÄresetlogs scn£»
µ±·ÖÎöµÄÖØ×öÈÕÖ¾ºÍ¹éµµÈÕÖ¾±ØÐë
Ïà¹ØÎĵµ£º
¶ÔÓÚÍâÁ¬½Ó£¬OracleÖпÉÒÔʹÓÓ(+)”À´±íʾ£¬9i¿ÉÒÔʹÓÃLEFT/RIGHT/FULL OUTER JOIN£¬ÏÂÃæ½«ÅäºÏʵÀýÒ»Ò»½éÉÜ¡£
1. LEFT OUTER JOIN£º×óÍâ¹ØÁª
SELECT e.last_name, e.department_id, d.department_name
from employees e
LEFT OUTER JOIN department ......
//ʹÓÃ×Ô¶¨Ò庯Êý¶¨ÒåÈÕÆÚ¸ñʽ
to_date('1982-11-11','yyyy-mm-dd')
to_date('1982/11/11','yyyy/mm/dd')
//Ï£ÍûÔ±¹¤scottµÄ¸Ú룬¹¤×Ê£¬²¹ÖúÓësmithÔ±¹¤Ò»Ñù
update emp set (job,sal,comm)=(select job,sal,comm from emp where ename='SMITH') where ename='SCOTT';
||------- javaʹÓÃoracle &nbs ......
AIX Oracle RAC Éý¼¶µ½10.2.0.4.0¹ý³ÌÓÐÈçϱ¨´í(Ö±½ÓÉý¼¶µ½10.2.0.4²»ÐèÒªÓ¦ÓÃPatch:6160398)£º
root@bwgl_db2:/u01/app/oracle/crs_1/bin# /u01/app/oracle/crs_1/install/root102.sh
Error : Please change the CRS_ORACLE_USER id <oracle> to have the following OS capabilities :
<CAP_BYP ......
1.oracle»·¾³
create table test
(
id number(4),
name varchar2(20)
)
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯû±»×èÈû
2.sqlserver»·¾³
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯ±»×èÈû(Ê ......