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

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©¿Í¹ûÈ»²»´í!

ÒýÓÃ

http://blog.csdn.net/tianlesoftware/archive/2010/05/19/5604497.aspx
ÎÒÏàÐÅËûµÄBOLG....Äã¿´¿´ÄÇ..ÓÐÎÊÌâ¿ÉÒÔÎÊËû...


û´íû´í ÎÒ¾ÍÒª¿´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¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

oracle ÈçºÎµ÷ÓÃmssql´æ´¢¹ý³Ì - Oracle / ¸ß¼¶¼¼Êõ

oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......

½«OracleµÄÊý¾Ýµ¼Èëµ½MDBÖгöÏÖ´íÎó - Oracle / ¿ª·¢

ÎÒÔÚ³ÌÐòÖн«oracleÊý¾Ý¿âµÄ¶«Î÷select³öÀ´ ÔÙ²åÈëµ½MDBÖÐ £¬È»ºóÔÙMDBÖв鿴µÄʱºò·¢ÏÖÓкܶà×Ö¶ÎÖµ¶¼Ëð»µÁËÎÞ·¨ÏÔʾ£¬ÔÚµ¼³ö¹ý³ÌÖÐûÓгöÏÖ´íÎ󣬲»ÖªµÀÊÇʲôԭÒòÔì³ÉµÄ°¡£¿

ÀàÐÍ¿ÉÊÇÒ»Öµģ¿

ÒýÓÃ
ÀàÐÍ¿É ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ