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

linuxÖØÆôºóoracleÎÞ·¨Æô¶¯

ÈçÌ⣡

ûÓÐÕâ¸öÎļþ°¡

$ORACLE_BASE\ADMIN\SID\
ÀïÃæÖ»ÓÐadump,dpump,pfileÈý¸öÎļþ¼Ð

ÎÒÊÇÖØÐ°²×°µÄÊý¾Ý¿â


ûÓÐÈÕÖ¾Îļþ£¿Ò»°ãÔÚbdump Ŀ¼ÏÂ..


------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716

±¨ÁËʲô´íÎó°¡


lsnrctl status ÏÔʾʲô£¿

ûÓÐbdumpÕâ¸öÎļþ¼Ð£¬
´íÎóÈçÏ£ºora-01034£¬ora-27101£¬¼àÌýʲô¶¼¿ÉÒÔÆô¶¯£¬ÎÒÓÃ/ as sysdba½øÈëÊý¾Ý¿âºó£¬Ö´ÐÐstartup forceÈ»ºó±¨´í£ºora-01078  ora-00109 ÎÞ·¨´ò¿ª$oracle_home/dbs/initorcl,ÎÒµÄsidÊÇorcl£¬ºóÀ´ÎÒ·¢ÏÖÎÒµÄÄǸöÎļþ¼ÐÏÂÃæÃ»ÓÐinitorclÕâ¸öÎļþ£¬²»ÖªµÀÊDz»ÊÇÕâ¸öÎÊÌ⣿


ÒýÓÃ
ûÓÐbdumpÕâ¸öÎļþ¼Ð£¬
´íÎóÈçÏ£ºora-01034£¬ora-27101£¬¼àÌýʲô¶¼¿ÉÒÔÆô¶¯£¬ÎÒÓÃ/ as sysdba½øÈëÊý¾Ý¿âºó£¬Ö´ÐÐstartup forceÈ»ºó±¨´í£ºora-01078  ora-00109 ÎÞ·¨´ò¿ª$oracle_home/dbs/initorcl,ÎÒµÄsidÊÇorcl£¬ºóÀ´ÎÒ·¢ÏÖÎÒµÄÄǸöÎļþ¼ÐÏÂÃæÃ»ÓÐinitorclÕâ¸öÎļþ£¬²»ÖªµÀÊDz»ÊÇÕâ¸öÎÊÌ⣿




²»ÖªµÀÂ¥Ö÷Æô¶¯Óà startup force Æô¶¯µÄÄ¿µÄÊÇʲô£¿¸ÃÃüÁîÆäʵÊÇÇ¿ÐйرÕÊý¾Ý¿â£¨shutdown abort£©ºÍÆô¶¯Êý¾Ý¿â£¨startup£©Á½ÌõÃüÁîµÄÒ»¸ö×ۺϡ£¸ÃÃüÁî½öÔڹرÕÊý¾Ý¿âÓöµ½ÎÊÌâ²»ÄܹرÕÊý¾Ý¿âʱ²ÉÓᣠÈç¹ûÊý¾Ý¿â»¹Ã»ÓÐÆô¶¯£¬shutdown abort¾Í»á±¨´íÁË..


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ