oracleÐÔÄÜ¼à¿ØÎÊÌâ - Oracle / ¿ª·¢
1.¹ØÓÚoracleµÄÐÔÄÜ¼à¿ØÖ¸±ê£¬ÓÐÖÖ·½·¨ÊÇ´ÓSGAÖвɼ¯ÐÅÏ¢£¬ÕâÓë´Ó¶¯Ì¬ÐÔÄÜÊÓͼÖÐÊÕ¼¯ÓÐʲô²»Í¬Â𣿴Ӷ¯Ì¬ÊÓͼÖвɼ¯»áÔö¼ÓÊý¾Ý¿âÒýÇæ¸ºÔØÂ𣿠2.Èç¹ûÊý¾Ý¿â¹ÒÆðºó£¬Ôõô´ÓϵͳµÄ½ø³ÌÖз¢ÏÖ£¿ Íû¸ßÊÖÖ¸½Ì
´ÓÎÒÒÔǰËùѧµÃÖª¶¯Ì¬ÐÔÄÜÊÓͼÀïµÄÐÅÏ¢ºÃÏñ¾ÍÊÇ´ÓSGAÖлñÈ¡µÄ£¬µ«ÊÇÏÖÔÚÅöµ½ÁËijÖÖ˵·¨£¬¶øÇÒ±¾ÈËÊÇÐÂÊÖ£¬¶ÔSGAµÄºËÐÄÈÏÖª²»×㣬ËùÒÔ·¢³öÁËÒÔÉÏÒÉÎÊ£¬Íû¸ßÊÖÁ½⣬²¢¸øÓè½â»ó£¬Ð»Ð»ÒýÓà Âò¼¸±¾ÊéѧϰÏ ÄãµÃ¸æËßÈ˼ÒÂòɶÊé°É£¡ ¶¯Ì¬ÐÔÄÜÊÓͼÁ˽âµÃºÜÉÙ£¡ ¿´µÄÊÇEÎÄÎĵµ£¡ 1.¹ØÓÚoracleµÄÐÔÄÜ¼à¿ØÖ¸±ê£¬ÓÐÖÖ·½·¨ÊÇ´ÓSGAÖвɼ¯ÐÅÏ¢£¬ÕâÓë´Ó¶¯Ì¬ÐÔÄÜÊÓͼÖÐÊÕ¼¯ÓÐʲô²»Í¬Â𣿴Ӷ¯Ì¬ÊÓͼÖвɼ¯»áÔö¼ÓÊý¾Ý¿âÒýÇæ¸ºÔØÂ𣿠SGAÖвɼ¯£¿Ò»°ã¶¼ÊÇͨ¹ý¶¯Ì¬ÐÔÄÜÊÓͼÀ´»ñÈ¡£¬¸ºÔØÔö¼Ó½ÏС¡£ 2. Èç¹ûÊý¾Ý¿â¹ÒÆðºó£¬Ôõô´ÓϵͳµÄ½ø³ÌÖз¢ÏÖ£¿ ʹÓÃsysdbaµÇ¼²é¿´ select database_status from v$instance; ĿǰΪֹÎÒ¿´µ½µÄÎÄÕ»òÊéÃ²ËÆ¶¼ÊǹØÓÚSGAÔõôÉèÖ𡣬SGAµÄ×é³É°¡Ê²Ã´µÄ£¬µ«ÊǶ¼Ã»ÓÐÉîÈë½éÉÜÏ£¬µ±È»ÎÒ¿´µÄÊéÒ²ÓÐÏÞ£¬Èç¹ûÓÐÓйط½ÃæµÄºÃÊéҲϣÍû´ó¼ÒÍÆ¼öÏ£¬ÁíÍâÈç¹û²»¸øsysȨÏÞ£¬ÆÕͨÓû§¾Í¿´²»Á˶¯Ì¬ÐÔÄÜÊÓͼ£¬ÓÐûÓпÉÄÜÓÃÆÕͨÓû§´ÓSGAÖеõ½Êý¾Ý¿âµÄÐÔÄÜÖ¸±êÄØ£¿ ¶¥£¬Ñ§Ï°¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
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 / ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡ ×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½ ´¥·¢Æ÷? Ó¦¸ÃÓÃJOB Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......
СµÜÎÒÕâѧÆÚÔÚѧOracle¡£°²×°ÁËOracle 10.2.0°æ±¾¡£µ«³öÏÖÁËÈçÏÂÎÊÌâ¡£ ORACLEÊý¾Ý¿âµÄORCLÊý¾Ý¿âÄÜͨ¹ýemÀ´¹ÜÀí£¬ÓÐoracleDBConsoleorcl·þÎñ¡£ È»ºóÎÒ×Ô¼ºÐ½¨ÁËÒ»¸öÊý¾Ý¿â¡£·¢ÏÖ·þÎñÀïʲô·þÎñ¶¼ÓУ¬¾ÍÊÇûÓÐor ......