oracleÓйصÄ4¸öÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÈçÌâ: 1.OracleµÄȱʡÊý¾ÝÎļþ¸öÊý?²»Í¬µÄ°æ±¾ÊÇÒ»ÑùÂ𣿶¼ÊÇ30Â𣿠2.expdpºÍimpdpµÄ²Ù×÷ȨÏÞ£¬ÊÇexp_full_database/imp_full_databaseÂ𣿠3.ÁÙʱ±í¿Õ¼äÓÐʲôÓã¿ 4.н¨Êý¾Ý¿â,Èç¹û×¢²á±íûÓÐ...oracle/HOMExxxÕâ¸öÏÐèÒªÊÖ¶¯¼ÓÂ𣿲»¼ÓÓÐʲôӰÏ죿
»ù´¡ÖªÊ¶ ºÃºÃÕÆÎÕ ´ø¸öµÊ×ÓµÈÈ˻ظ´ 1, ²»Í¬°æ±¾µÄȱʡÎļþ¸öÊý¿Ï¶¨²»Í¬£¬ÒòÎªËæ×Ű汾µÄÌá¸ß£¬oracle»áÐÂÔöһЩ¸¨ÖúµÄtablespace£¬Ò²¾Í»áÔö¼ÓһЩÊý¾ÝÎļþ£¬ÁíÍ⣬30Õâ¸öÊý×ÖÂ¥Ö÷ÔõôµÃµ½µÄ£¿ºÃÏñûÄÇô¶à¡£ 2£¬²»ÊìϤ£» 3£¬ÅÅÐòʱ»áÓõ½ÁÙʱ±í¿Õ¼ä 4£¬³ý·ÇÄãÊÖ¹¤É¾³ý£¬Ò»°ã×¢²á±í¶¼ÓжÔӦѡÏÒýÓà 1, ²»Í¬°æ±¾µÄȱʡÎļþ¸öÊý¿Ï¶¨²»Í¬£¬ÒòÎªËæ×Ű汾µÄÌá¸ß£¬oracle»áÐÂÔöһЩ¸¨ÖúµÄtablespace£¬Ò²¾Í»áÔö¼ÓһЩÊý¾ÝÎļþ£¬ÁíÍ⣬30Õâ¸öÊý×ÖÂ¥Ö÷ÔõôµÃµ½µÄ£¿ºÃÏñûÄÇô¶à¡£ 4£¬³ý·ÇÄãÊÖ¹¤É¾³ý£¬Ò»°ã×¢²á±í¶¼ÓжÔӦѡÏ 1.¼ÇµÃ²»ÊǺÜÇå³þÁË£¡²»ÖªÊÇ10g»¹ÊÇ11g£¬Ä¬ÈϵÄÊý¾ÝÎļþ¸öÊýÊÇ30£¬µ±È»Ëæ×ÅÒµÎñµÄÔö³¤£¬¿ÉÒÔÔÚ¿ØÖÆÎļþÖУ¬»¹¿ÉÒÔÐÞ¸Ä×î´óÊý¾ÝÎļþµÄ¸öÊý¡£ 4.²»ÊÇɾ³ý£¬ÊÇÎÒ´´½¨µÄÊý¾Ý¿âÍêºó£¬×¢²á±íÖÐûÓÐÕâ¸ö¶ÔÓ¦Ï ×Ô¼º¶¥Ï£¡ 1.OracleµÄȱʡÊý¾ÝÎļþ¸öÊý?²»Í¬µÄ°æ±¾ÊÇÒ»ÑùÂ𣿶¼ÊÇ30Â𣿠2.expdpºÍimpdpµÄ²Ù×÷ȨÏÞ£¬ÊÇexp_full_database/imp_full_databaseÂ𣿠3.ÁÙʱ±í¿Õ¼äÓÐʲôÓã¿ 4.н¨Êý¾Ý¿â,Èç¹û×¢²á±íûÓÐ...oracle/HOMExxxÕâ¸öÏÐèÒªÊÖ¶¯¼ÓÂ𣿲»¼ÓÓÐʲôӰÏ죿 tangren ÒѾ»Ø´ðÁËÄãµÄÎÊÌâÁËѽ Ö§³Ö tangren ·¹ý ·¢Ò»Ï ¶¥Ò»Ï oracle QQȺºÅ£º54775466 »¶ÓÕâ·½Ã
Ïà¹ØÎÊ´ð£º
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......