ÈçÌ⣡
ûÓÐÕâ¸öÎļþ°¡
$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¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......