oracle 10gÈÕÖ¾²é¿´·½·¨ - Oracle / ¿ª·¢
ÏêϸµÄ²½Öè¡£¡£ ÍùÉÏÕҵͼÊDZðÈ˵½´¦¿½±´µÄ¡£¡£
ÎÒµÄoracle°æ±¾Îª10g
Êý¾ÝÎļþ£¬¿ØÖÆÎļþ£¬ÈÕÖ¾ÎļþµÄµØÖ·Îª£ºE:\oracle\product\10.2.0\oradata\orcl
²ÎÊýÎļþÔÚ E:\oracle\product\10.2.0\admin\orcl\pfile
ллÁË¡£¡£
¾±¾ÈËÈ·ÈϺó½áÌù¸ø·Ö¡£¡£
http://blog.csdn.net/tianlesoftware/archive/2010/05/19/5604497.aspx
ÎÒÏàÐÅËûµÄBOLG....Äã¿´¿´ÄÇ..ÓÐÎÊÌâ¿ÉÒÔÎÊËû...
1¡¢
Èç¹ûÂ¥Ö÷ÏëÒª²é¿´µÄÊDZ¨¾¯ÈÕÖ¾£¨alert log£©µÄ»° ¿ÉÒÔÔÚÈçÏ·¾¶²é¿´ Ö±½ÓÓÃÎı¾±à¼Æ÷¾Í¿ÉÒÔ´ò¿ª
E:\oracle\product\10.2.0\admin\orcl\bdump
ÀïÃæÓ¦¸ÃÓиöalert_orcl.log
2¡¢
Èç¹ûÂ¥Ö÷Ïë²é¿´µÄÊÇÁª»úÖØ×öÈÕÖ¾£¨online redo log£©µÄ»° ¿ÉÒÔʹÓÃlogminerÈ¥²é¿´ ʹÓ÷½·¨ÍøÉϺܶà Ëæ±ãËÑһϾÍÓÐ
ÕâλÈÊÐֵIJ©¿Í¹ûÈ»²»´í!
û´íû´í ÎÒ¾ÍÒª¿´redolog
¾ÍÏëÓÃlogminer Õâ¸ö¡£
ѧϰÁË
1¡¢
Èç¹ûÂ¥Ö÷ÏëÒª²é¿´µÄÊDZ¨¾¯ÈÕÖ¾£¨alert log£©µÄ»° ¿ÉÒÔÔÚÈçÏ·¾¶²é¿´ Ö±½ÓÓÃÎı¾±à¼Æ÷¾Í¿ÉÒÔ´ò¿ª
E:\oracle\product\10.2.0\admin\orcl\bdump
ÀïÃæÓ¦¸ÃÓиöalert_orcl.log
2¡¢
Èç¹ûÂ¥Ö÷Ïë²é¿´µÄÊÇÁª»úÖØ×öÈÕÖ¾£¨online redo log£©µÄ»° ¿ÉÒÔʹÓÃlogminerÈ¥²é¿´ ʹÓ÷½·¨ÍøÉϺܶà Ëæ±ãËÑһϾÍÓÐ
LogMinerµÄʹÓà : ÎÒǰ²»¾Ã²Åʱ¼äʵÑéºó×ܽáµÄ,Äã¿´¿´°É:
http://blog.sina.com.cn/s/blog_3fb41b900100h497.html
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......
ÎÒÓÃmyeclipseÁ¬½ÓOracleÒ»Ö±±¨´í£¬Ò»ÏÂÊDZ¨´í½ØÍ¼£¬
Çó¸ßÈËÏàÖú¡£
ÎÞͼÎÞÕæÏà....
file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/SF/Oracle%20JDBCÁ¬½Ó´íÎó.png
....
Äã¿´¿´Çý¶¯ºÍORACLEµÄ°æ ......