Oracle/¥¢¡¼¥¥Æ¥¯¥Á¥ã †
¥á¥â¥êÀ߷פ˴ؤ¹¤ë½é´ü²½¥Ñ¥é¥á¡¼¥¿ †
¥Ñ¥é¥á¡¼¥¿ | ÀâÌÀ |
MEMORY_TARGET | Oracle¥·¥¹¥Æ¥àÁ´ÂΤλÈÍѲÄǽ¤Ê¥á¥â¥ê¡¼ |
MEMORY_MAX_TARGET | MEMORY_TARGET¤Ç»ØÄê²Äǽ¤ÊºÇÂ祵¥¤¥º |
SGA_TARGET | ¥Ð¥Ã¥Õ¥¡¡¦¥¥ã¥Ã¥·¥å¡¢¶¦Í¥×¡¼¥ë¡¢¥é¡¼¥¸¡¦¥×¡¼¥ë¡¢Java¥×¡¼¥ë¡¢Streams¥×¡¼¥ë¤Î¥µ¥¤¥º¤òÀßÄꤷ¤¿ÃͤÇưŪ¤Ë³ä¤êÅö¤Æ¤ë ºÇÄã¸ÂÊݾڤ¹¤ë¥µ¥¤¥º¤Ï¡¢DB_CACHE_SIZE¡¢SHARED_POOL_SIZE¡¢STREAMS_POOL_SIZE¡¢JAVA_POOL_SIZE¡¢LOG_BUFFER ¥Ñ¥é¥á¡¼¥¿¤Ç»ØÄê²Äǽ |
PGA_AGGREGATE_TARGET | ¥µ¡¼¥Ð¡¼¥×¥í¥»¥¹¤¬»ÈÍѤǤ¤ë¥á¥â¥ê¡¼¤ÎÌÜɸÃ͡ʤê¤Ê¤±¤ì¤ÐÃͤòĶ¤¨¡¢Ä¶²á¤·¤Æ¤¤¤ë¾ì¹ç¤Ï¥á¥â¥ê¤ò²òÊü¤¹¤ë¤è¤¦ÅØÎϤ¹¤ë¡Ë 0¤ËÀßÄꤹ¤ë¤ÈWORKAREA_SIZE_POLICY¥Ñ¥é¥á¡¼¥¿¤¬MANUAL¤ËÀßÄꤵ¤ì¤ë |
PGA_AGGREGATE_LIMIT | PGA¤Î¾å¸ÂÃͤò»ØÄê¡£¾å¸ÂÃͤòĶ¤¨¤¿¾ì¹ç¤Ï¡¢ºÇ¤âÄ´À°¤¬º¤Æñ¤Ê¥á¥â¥ê¡¼¤ò»ÈÍѤ·¤Æ¤¤¤ë¥»¥Ã¥·¥ç¥ó¤Ç¥³¡¼¥ë¤¬Ää»ß¡¢¤½¤ì¤Ç¤â±Û¤¨¤¿¾ì¹ç¤Ï¥»¥Ã¥·¥ç¥ó¤¬½ªÎ»¤¹¤ë |
WORKAREA_SIZE_POLICY | ºî¶ÈÎΰè¤Î¥µ¥¤¥º»ØÄêÊýË¡¤ò»ØÄê¡ÊAUTO / MANUAL¡ËMANUAL¤Ë¤¹¤ë¤È³Æºî¶ÈÎΰè¤ËÀßÄꤷ¤¿¥Ñ¥é¥á¡¼¥¿¡Ê¡ÁAREA_SIZE¡Ë¤¬ÍøÍѤµ¤ì¤ë |
SHARED_POOL_RESERVED_SIZE | ͽÌóÎΰè¤Î¥µ¥¤¥º¤ò»ØÄê¡£¥Ç¥Õ¥©¥ë¥È¤Ï5% |
̾Á° | ÀâÌÀ |
DB¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å | ¥Ç¥£¥¹¥¯¤«¤éÆɤ߼è¤é¤ì¤¿¥Ç¡¼¥¿¤Î¥³¥Ô¡¼¤ò¥¥ã¥Ã¥·¥å¤¹¤ë |
REDO¥í¥°¥Ð¥Ã¥Õ¥¡ | ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÂФ¹¤ëÊѹ¹¾ðÊó¤òREDO¥ì¥³¡¼¥É¤È¤·¤Æ¥¥ã¥Ã¥·¥å¤¹¤ë¡£LGWR¤Ë¤è¤Ã¤ÆREDO¥í¥°¥Õ¥¡¥¤¥ë¤Ë½ñ¤½Ð¤µ¤ì¤ë |
¶¦Í¥×¡¼¥ë | ¥é¥¤¥Ö¥é¥ê¥¥ã¥Ã¥·¥å | ¶¦ÍSQL¡¢¶¦ÍPL/SQL¡¢¥ª¥Ö¥¸¥§¥¯¥È¤Î¥á¥¿¥Ç¡¼¥¿¤Ê¤É¤ò³ÊǼ¡£ SQL¼Â¹Ô»þ¤Ë¤Ï¥«¡¼¥½¥ë¤È¸Æ¤Ð¤ì¤ë¥Ý¥¤¥ó¥¿¤ò»ÈÍѤ·¤ÆÁàºî¤¬¹Ô¤ï¤ì¤ë¡£ ¥«¡¼¥½¥ë¤Ë¤ÏÍÍ¡¹¤Ê¥á¥¿¥Ç¡¼¥¿¤¬ÂбþÉÕ¤±¤é¤ì¤Æ¤ª¤ê¡¢¥é¥¤¥Ö¥é¥ê¥¥ã¥Ã¥·¥å¤Ë³ÊǼ¤µ¤ì¤ë¤³¤È¤ÇºÆÍøÍѤµ¤ì¤ë¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤ë¡£ |
ͽÌóÎΰè | 4KB¤òĶ¤¨¤ë¥ª¥Ö¥¸¥§¥¯¥È¤Î¥í¡¼¥É»þ¡¢¥é¥¤¥Ö¥é¥ê¥¥ã¥Ã¥·¥å¤Ë¶õ¤ÍÆÎ̤¬¤Ê¤¯¥¨¡¼¥¸¥¢¥¦¥È¤¬È¯À¸¤¹¤ë¾ì¹ç¤Ë»ÈÍѤµ¤ì¤ë |
¥Ç¡¼¥¿¥Ç¥£¥¯¥·¥ç¥Ê¥ê¥¥ã¥Ã¥·¥å | ¥Ç¥£¥¯¥·¥ç¥Ê¥ê¤«¤é¼èÆÀ¤·¤¿¥ì¥³¡¼¥É¤ò³ÊǼ¡£ ¥Ç¥£¥¯¥·¥ç¥Ê¥ê¤Î¸µ¥Ç¡¼¥¿¤ÏSYSTEMɽÎΰè¤Ë³ÊǼ¤µ¤ì¤Æ¤¤¤ë°Ù¡¢¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å¤Ë¥Ç¡¼¥¿¤¬¥í¡¼¥É¤µ¤ì¡¢ »ÈÍѤµ¤ì¤¿¥ì¥³¡¼¥É¤¬¥Ç¥£¥¯¥·¥ç¥Ê¥ê¥¥ã¥Ã¥·¥å¤Ë³ÊǼ |
¥µ¡¼¥Ð¡¼¥ê¥¶¥ë¥È¥¥ã¥Ã¥·¥å | SQLʸñ°Ì¤Î·ë²Ì¥»¥Ã¥È¤¬³ÊǼ¤µ¤ì¤Æ¤¤¤ë¶¦Í¥×¡¼¥ëÆâ¤ÎÎΰ衣 DB¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å¤È°Û¤Ê¤ê¡¢¥Ç¡¼¥¿¥Ö¥í¥Ã¥¯¤Ç¤Ï¤Ê¤¯SQLÌ䤤¹ç¤ï¤»·ë²Ì¤äPL/SQL¥Õ¥¡¥ó¥¯¥·¥ç¥ó·ë²Ì¤¬´Þ¤Þ¤ì¤ë |
¥é¡¼¥¸¥×¡¼¥ë | ¶¦Í¥×¡¼¥ë¤Î³ä¤êÅö¤Æ¤Ë¤ÏŬ¤µ¤Ê¤¤ÂçÎ̤Υá¥â¥ê³ä¤êÅö¤ÆÍѤΥá¥â¥êÎΰè |
Java¥×¡¼¥ë | JVM¤ÎJava¥³¡¼¥É¤È¥Ç¡¼¥¿¤¬³ÊǼ¤µ¤ì¤ë¥á¥â¥êÎΰè |
Streams¥×¡¼¥ë | DML¤äDDL¤ò¾¤ÎDB¤Ë¼«Æ°Åª¤ËÅÁÇŤµ¤»¤ëµ¡Ç½ÍѤΥá¥â¥ê¡£DataPump¤ÏÆâÉôŪ¤ËStreams¥×¡¼¥ë¤ò»ÈÍѤ·¤Æ¤¤¤ë |
Fixed SGA | OracleÆâÉô¤Î¥Ï¥¦¥¹¥¡¼¥Ô¥ó¥°¡ÊÉÔÍפʥǡ¼¥¿ºï½ü¤äÎΰè²òÊü¤Ê¤É¤Î¥á¥ó¥Æ¥Ê¥ó¥¹¡Ë¤Î¥á¥â¥êÎΰè |
¶¦Í¥×¡¼¥ë¤Î¹½Â¤ †
| CPU¥³¥¢¿ô¤ä¡¢¶¦Í¥×¡¼¥ë¥µ¥¤¥º¤Ë¤è¤êºÇÂç7¸Ä¤Î¥µ¥Ö¥×¡¼¥ë¤Ëʬ³ä¤µ¤ì¤ë¡£ ¹¹¤Ë¸³´ü´Ö¤Ë¤è¤ê¡¢4¤Ä¤Î¥Ò¡¼¥×¤Ëʬ³ä¤µ¤ì¤ë¡£¡ÊºÇÂç 7 x 4 = 28¡Ë
ʬ³ä¤·¤¿1¤Ä¤Î¥Ò¡¼¥×¤Ç¶õ¤ÎΰèÉÔ¤¬ÇÉÀ¸¤¹¤ë¤ÈORA-04031¤¬È¯À¸¤¹¤ë¡£
¾¤Î¥Ò¡¼¥×¤«¤é¶õ¤¥á¥â¥ê¤ò³ÎÊݤ¹¤ë¤Ë¤Ï¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å¤ò·Ðͳ¡ÊɬÍפÊÍÆÎ̤ò³ÈÄ¥¤·¤ÆÅϤ¹¡Ë¤¹¤ë°Ù¡¢ ¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å¤Î³Èĥ;ÎϤ¬¤Ê¤¤¤ÈORA-04031¤¬È¯À¸¤¹¤ë¡£ SGAÁ´ÂΤÇ3GB¤È¤·¤Æ¡¢¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å2GB¡¢¶¦Í¥×¡¼¥ë500MB¤ò¥Ñ¥é¥á¡¼¥¿ÀßÄꤹ¤ë¤È¡¢500MB¤·¤«³Èĥ;ÎϤ¬¤Ê¤¯¤Ê¤ë |
¥Ò¡¼¥× | ¸³´ü´Ö | Îΰè |
sga heap(n,0) | ¥¤¥ó¥¹¥¿¥ó¥¹µ¯Æ°Ãæ¤Ï³ÎÊݤµ¤ì¤ë | ±Ê³¥á¥â¥êÎΰè |
sga heap(n,1) | ¥»¥Ã¥·¥ç¥ó¤¬Â¸ºß¤·¤Æ¤¤¤ë´Ö¤Ï³ÎÊݤµ¤ì¤ë | ¥é¥¤¥Ö¥é¥ê¥¥ã¥Ã¥·¥å¡¢¥Ç¥£¥¯¥·¥ç¥Ê¥ê¥¥ã¥Ã¥·¥å |
sga heap(n,2) | ¥«¡¼¥½¥ë¤¬Â¸ºß¤·¤Æ¤¤¤ë´Ö¤Ï³ÎÊݤµ¤ì¤ë | ¿Æ¥«¡¼¥½¥ë¡¢»Ò¥«¡¼¥½¥ë |
sga heap(n,3) | SQLʸ¤Î¼Â¹Ô´Ö¤Ï³ÎÊݤµ¤ì¤ë | SQLÎΰè |
¶¦Í¥×¡¼¥ë¤Î³ÍÆÀ¤ä²òÊü¤ò¹Ô¤¦¾ì¹ç¡¢ÇÓ¾À©¸æ¤ò¹Ô¤¦°Ù¤Ë¡Öshared pool latch¡×¤ò³ÍÆÀ¤¹¤ë¤¬¡¢1¤Ä¤Î¶¦Í¥×¡¼¥ë¤À¤±¤À¤È¥é¥Ã¥Á¶¥¹ç¤Ë¤è¤ëÂÔµ¡¤¬È¯À¸¤¹¤ë¡£
¤½¤Î°Ù¡¢¶¦Í¥×¡¼¥ë¤òʬ³ä¤¹¤ë¤³¤È¤Ç¶¥¹ç¤ò¸º¤é¤·¤Æ¤¤¤ë
¶¦Í¥×¡¼¥ë¤Î¥á¥â¥ê³ä¤êÅö¤Æ
- ¥Õ¥ê¡¼¥ê¥¹¥È¤«¤é¶õ¤¤òõ¤¹¡Ê¥Õ¥ê¡¼¥ê¥¹¥È¤Ï³Æ¥Ò¡¼¥×Ëè¤Ë¸ºß¤¹¤ë¡Ë
- Reserved Granule¡Ê̤³ä¤êÅö¤Æ¤ÎÎΰè¡Ë¤«¤é³ÎÊÝ
- ͽÌóºÑ¤ß¥×¡¼¥ë¤«¤é³ÎÊÝ¡Ê°ìÄꥵ¥¤¥º°Ê¾å¤Î¤â¤Î¤ò³ä¤êÅö¤Æ¤ëÎΰè¡Ë
- »ÈÍѺѤßÎΰè¤ÎºÆÍøÍÑ¡ÊLRU¡ÊĹ´ü´Ö»È¤Ã¤Æ¤Ê¤¤¤â¤Î¡Ë¥ê¥¹¥È¤ò¥Õ¥é¥Ã¥·¥å¡¢¥Á¥ã¥ó¥¯·ë¹ç¤·¤Æ¶õ¤¤òºî¤ë¡Ë
- ¶¦Í¥×¡¼¥ë³ÈÄ¥¡ÊIMMEDIATE¥â¡¼¥É¡Ê¢¨¡Ë¤Ç¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å¤«¤é¶õ¤ÍÆÎ̤ò³ÎÊÝ¡Ë
- ORA-04031¥¨¥é¡¼¡ÊÍ׵᥵¥¤¥º¤Î¥á¥â¥ê¤¬³ä¤êÅö¤Æ¤é¤ì¤Ê¤¤¡Ë
¢¨¶¦Í¥×¡¼¥ëÎΰè¤Ç¡¢¶õ¤ÍÆÎÌÉÔ¤ÇORA-04031¤¬È¯À¸¤·¤¦¤ë»þ¡¢Â¾¥³¥ó¥Ý¡¼¥Í¥ó¥È¤ò½Ì¾®¤·¤Æ¶¦Í¥×¡¼¥ëÎΰè¤Ø¥á¥â¥ê¤ò³ä¤êÅö¤Æ¤ë¡Ê¶¦Í¥×¡¼¥ë¤Ø¤Î¥á¥â¥ê³ä¤êÅö¤Æ¤Ï°ìÊýÄ̹ԡË
PGA¤Ï¥×¥í¥»¥¹µ¯Æ°¤·¤¿ºÝ¤Ë³ä¤êÅö¤Æ¤é¤ì¤ë¥×¥é¥¤¥Ù¡¼¥È¥á¥â¥ê¤Ç¡¢¼ç¤ÊÌÜŪ¤Ï¥½¡¼¥È¤òÆâÉôŪ¤Ë¹Ô¤¦½èÍý¡¢¥Ï¥Ã¥·¥å·ë¹ç¡£
½é´ü²½¥Ñ¥é¥á¡¼¥¿ PGA_AGGREGATE_TARGET ¤Ç OS¤Ë³ä¤êÅö¤Æ¤ë¥á¥â¥êÍÆÎ̤ò»ØÄê¡£
ORACLE¤¬»öÁ°¤Ë¥á¥â¥ê¤ò³ÎÊݤ·¤Æ¤ª¤¯ÌÜɸÃͤǤ¢¤ê¡¢ºÇÂçÃͤǤϤʤ¤¡£Â¤ê¤Ê¤±¤ì¤ÐÀßÄêÃͤòĶ¤¨¤Æ³ÎÊݤ·¡¢ÌÜɸÃͤè¤ê¿¤±¤ì¤Ð²òÊü¤·¤è¤¦¤È¤¹¤ë¡£
12.1¤«¤é¾å¸Â¤ò¶¯À©¤¹¤ë PGA_AGGREGATE_LIMIT ½é´ü²½¥Ñ¥é¥á¡¼¥¿¤¬Äɲ䵤ì¤Æ¤¤¤ë¡£
¥«¥é¥à̾ | ÀâÌÀ |
aggregate PGA target parameter | ¼«Æ°¥â¡¼¥É¤Ç¼Â¹ÔÃæ¤Îºî¶ÈÎΰè¤Ë»ÈÍѤǤ¤ëPGA¥á¥â¥ê¤ÎÎÌ |
aggregate PGA auto target | PGA_AGGREGATE_TARGET½é´ü²½¥Ñ¥é¥á¡¼¥¿¤Î¸½ºßÃÍ |
global memory bound | ¼«Æ°¥â¡¼¥É¤Ç¼Â¹Ô¤µ¤ì¤ëºî¶ÈÎΰè¤ÎºÇÂ祵¥¤¥º |
total PGA inuse | ¸½ºß¡¢ºî¶ÈÎΰè¤ÇÍøÍѤµ¤ì¤Æ¤¤¤ëPGA¥á¥â¥ê¤ÎÎÌ |
total PGA allocated | ¥¤¥ó¥¹¥¿¥ó¥¹¤Ë¤è¤ê³ä¤êÅö¤Æ¤é¤ì¤¿¸½¹Ô¤ÎPGA¥á¥â¥êÎÌ |
maximum PGA allocated | ¥¤¥ó¥¹¥¿¥ó¥¹µ¯Æ°°Ê¹ß¡¢³ä¤êÅö¤Æ¤é¤ì¤¿ºÇÂçPGA¤Î¥á¥â¥êÎÌ |
over allocation count | ¥¤¥ó¥¹¥¿¥ó¥¹µ¯Æ°°Ê¹ß¡¢PGA_AGGREGATE_TARGET¤ò±Û¤¨¤Æ³ä¤êÅö¤Æ¤¿²ó¿ô¡Ê¤³¤ÎÃͤ¬Äê´üŪ¤ËÁý¤¨¤ë¾ì¹ç¤Ï¡¢PGA_AGGREGATE_TARGET¤ÎÀßÄêÃͤòÂ礤¯¤¹¤ëɬÍפ¬¤¢¤ë¡Ë |
¥¯¥é¥¹¥¿¡¼¥¦¥§¥¢ †
CRS¥¹¥¿¥Ã¥¯ †
¥Ç¡¼¥â¥ó̾ | ÀâÌÀ |
CSSD | Cluster Synchronization Services¥Ç¡¼¥â¥ó¡£ASM¤Î¥°¥ë¡¼¥×¥µ¡¼¥Ó¥¹¤ÎÄ󶡵ڤӥΡ¼¥É´Ö¤Î¾õÂ֤δƻë¤ò¹Ô¤¦ ¥¤¥ó¥¿¡¼¥³¥Í¥¯¥È¤ò»ÈÍѤ·¥Î¡¼¥É´Ö¤ÎƱ´ü¤ò¼è¤ê¡¢¥¤¥ó¥¿¡¼¥³¥Í¥¯¥È¤Ë¾ã³²¤¬È¯À¸¤·¤¿¤é¥Î¡¼¥É¤òºÆµ¯Æ°¤¹¤ë |
CRSD | Cluster Ready Services¥Ç¡¼¥â¥ó¡£¥¯¥é¥¹¥¿¥ê¥½¡¼¥¹¡Ê¥¤¥ó¥¹¥¿¥ó¥¹¡¢¥ê¥¹¥Ê¡¼¡¢VIP¤Ê¤ÉOracle Cluesterware¤ËÅÐÏ¿¤·¤¿¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¡Ë¤Îµ¯Æ°¡¢Ää»ß¡¢´Æ»ë¤ò¹Ô¤¦¡£ ¥¯¥é¥¹¥¿¥ê¥½¡¼¥¹¾ã³²È¯À¸»þ¤Ï¥ê¥½¡¼¥¹ºÆµ¯Æ°¤¹¤ë |
EVMD | Event Manager¥Ç¡¼¥â¥ó¡£¥¯¥é¥¹¥¿¥¤¥Ù¥ó¥È¡Ê¥Î¡¼¥É¡¢¥¯¥é¥¹¥¿¤Îµ¯Æ°Ää»ß¤Ê¤É¡Ë¤ò¼õ¿®¤·É¬Íפ˱þ¤¸¤Æ¥¯¥é¥¹¥¿¥¤¥Ù¥ó¥È¤ÎžÁ÷¤ò¹Ô¤¦ |
¥×¥í¥»¥¹Ì¾ | ÀâÌÀ |
ocssd.bin | CSSD¡ÊCluster Synchronization Services¥Ç¡¼¥â¥ó¡Ë¤ÏÅêɼ¥Ç¥£¥¹¥¯¤ò»ÈÍѤ·¤Æ¥Î¡¼¥É´Ö¤Î¾õÂÖ¤ò´Æ»ë¤¹¤ë Oracle¥æ¡¼¥¶¡¼¤Ë¤Æµ¯Æ°¤µ¤ì¡¢CSSD¤¬°Û¾ï½ªÎ»¤·¤¿¾ì¹ç¡¢¥Î¡¼¥É¤¬ºÆµ¯Æ°¤¹¤ë ¥Ù¥ó¥À¡¼À½¥¯¥é¥¹¥¿¥¦¥§¥¢¤ÈÊ»ÍѤ¹¤ë¾ì¹ç¤Ï¥¯¥é¥¹¥¿¥¦¥§¥¢¤ÈÅý¹ç¤µ¤ì¤ë Ê»ÍѤ·¤Ê¤¤¾ì¹ç¤Ï¡¢root¤Ë¤è¤Ã¤Æµ¯Æ°¤µ¤ì¤¿OPRCD(¥×¥í¥»¥¹¥â¥Ë¥¿¥Ç¡¼¥â¥ó)¤¬¥Î¡¼¥É¤òÄä»ß¤¹¤ë Windows/Linux´Ä¶¤Ç¤Ïhangcheck-timer¤Ê¤É¤Î¥«¡¼¥Í¥ë¥É¥é¥¤¥Ð¤¬Æ±Íͤε¡Ç½¤òÄ󶡤¹¤ë°Ù¡¢µ¯Æ°¤·¤Ê¤¤ |
crsd.bin | CRSD¡ÊCluster Ready Services¥Ç¡¼¥â¥ó¡Ë¤ÏOCR¥Õ¥¡¥¤¥ë¤ò»ÈÍѤ·¤ÆOracle Clusterware¤ËÅÐÏ¿ root¥æ¡¼¥¶¡¼¤Ë¤è¤Ã¤Æµ¯Æ°¤µ¤ì¡¢³Æ¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤ÇÄêµÁ¤·¤¿¥¢¥¯¥·¥ç¥ó¥¹¥¯¥ê¥×¥È¤ò»ÈÍѤ·µ¯Æ°¡¢Ää»ß¡¢F/OÅù¤ò¹Ô¤¦ ASM¤ÈDB¤Ë´ØÏ¢¤¹¤ë¥×¥í¥»¥¹¤È¤·¤ÆRACGIMON¡Ê¥¤¥ó¥¹¥¿¥ó¥¹¥â¥Ë¥¿¡¼¡Ë¤òµ¯Æ°¤·¡¢¾õÂÖ´Æ»ë¤äFAN¤Ê¤É¤Îµ¡Ç½¤òÄ󶡤¹¤ë CRSD¤Ïracgwrap¥¹¥¯¥ê¥×¥È¤«¤éracgmain¥×¥í¥°¥é¥à¤òµ¯Æ°¤·¡¢¹¹¤Ë³Æ¥¢¥¯¥·¥ç¥ó¼Â¹Ô¤Î°Ù¡¢»Ò¥×¥í¥»¥¹¤ò°ì»þŪ¤Ëµ¯Æ°¤¹¤ë |
evmd.bin | EVMD¡ÊEvent Manager¥Ç¡¼¥â¥ó¡Ë¤Ï¡¢¥¯¥é¥¹¥¿¥¤¥Ù¥ó¥È¤Î¼õ¿®¡¢Å¾Á÷¤ò¹Ô¤¦ Oracle¥æ¡¼¥¶¡¼¤Ë¤è¤Ã¤Æµ¯Æ°¤µ¤ì¡¢¥¤¥Ù¥ó¥È¤ò¼õ¿®¤¹¤ë¤È¡¢¥¤¥Ù¥ó¥È¤ò¥í¥°²½¤·¡¢»Ò¥×¥í¥»¥¹¤Ç¤¢¤ëEVMLOGGER¡Ê¥¤¥Ù¥ó¥È¥Þ¥Í¡¼¥¸¥ã¥í¥¬¡¼¡Ë¤Ë¥¤¥Ù¥ó¥È½èÍý¤òÍ׵᤹¤ë¡£ EVMLOGGER¤ÏONS¡ÊOracle Notification Services¡Ë¤Ë¥¤¥Ù¥ó¥È¤òÁ÷¿®¤·¤¿¤ê¡¢RACGEVTF¤òµ¯Æ°¤·¥³¡¼¥ë¥¢¥¦¥È¤ò¼Â¹Ô¤¹¤ë |
¥¯¥é¥¹¥¿¡¼¥¦¥§¥¢¤Î¥í¥° †
$ORA_CRS_HOME/log/¥Û¥¹¥È̾¡¡¤È¡¡$ORACLE_HOME/log/¥Û¥¹¥È̾ ¤Ë³ÊǼ¤µ¤ì¤Æ¤¤¤ë¡£
$ORA_CRS_HOME = ¥¯¥é¥¹¥¿¤Î¥¤¥ó¥¹¥È¡¼¥ë¥Ç¥£¥ì¥¯¥È¥ê¡¡¡ÊÎã¡Ë/u01/app/12.1.0/grid/log/<¥Û¥¹¥È̾>
¥Ç¥£¥ì¥¯¥È¥ê | ¥Õ¥¡¥¤¥ë̾ | ÀâÌÀ |
. | alertŽÎŽ½ŽÄ̾.log | ¥¢¥é¡¼¥È¥í¥° |
/agent/crsd/ | oraagent_oracle/ orarootagent_root/ | ¥ê¥½¡¼¥¹´ÉÍý¤·¤Æ¤ë¥Ç¡¼¥â¥ó¡¢¥¨¡¼¥¸¥§¥ó¥È¥í¥° ¥ê¥½¡¼¥¹¥á¥ó¥Ð¡¼¥·¥Ã¥×¤ËÌäÂ꤬ȯÀ¸¤·¤¿¾ì¹ç¤Ë³Îǧ¤¹¤ë |
/agent/ohasd/ | oracssdagent_root/ oracssdmonitor_root/ | ¥Î¡¼¥É¥á¥ó¥Ð¡¼¥·¥Ã¥×¤ËÌäÂê¡ÊOracleºÆµ¯Æ°¤ä¥Ï¥ó¥°¡Ë¤¬¤¢¤Ã¤¿¾ì¹ç¤Ë³Îǧ¤¹¤ë¥í¥° 11gR2¤«¤é¤Î¥í¥°¤Ç¡¢11gR1¤Þ¤Ç¤Ï¡¢cssd/oclsomon/oclsomon.* |
/crsd/ | crsd.log | CRSD¤Î¥í¥°¡£10MB¤Ç¥í¡¼¥Æ¡¼¥·¥ç¥ó¡Êcrsd.l01¡Á10¤Ç¡¢10À¤ÂåÊݸ¡Ë |
/cssd/ | ocssd.log | CSSD¤Î¥í¥°¡£20MB¤Ç¥í¡¼¥Æ¡¼¥·¥ç¥ó¡Êocssd.01¡Á05¤Ç¡¢5À¤ÂåÊݸ¡Ë ¥Ç¥£¥¹¥¯¥Ñ¥¹ÀÚÃǤ䡢¥¤¥ó¥¿¡¼¥³¥Í¥¯¥È¾ã³²¤Î»þ¤Ë³Îǧ¤¹¤ë¥í¥° ¥¡¼¥ï¡¼¥É¡§Aborting local node to avoid splitbrain |
/evmd/ | evmd.log | EVMD¤Î¥í¥°¡£500KB¤Ç¥í¡¼¥Æ¡¼¥·¥ç¥ó¡Ê<¥Û¥¹¥È̾>_evmlog_<ÆüÉÕ>_1¡¢2¤Î̾Á°¤ÇÊݸ¡Ë $ORA_CRS_HOME/evm/logn¤Ë¤â¤¢¤ë¤¬¡¢¥Ð¥¤¥Ê¥ê¤Î°Ù¡¢emvshow¥³¥Þ¥ó¥É¤ò»ÈÍÑ »þ´Ö¤´¤È¤Ë³Îǧ¡§emvshow -t "[@timestamp]@@" ¥í¥°Ì¾ ¥¤¥Ù¥ó¥È°ÀË衧emvshow -D ¥í¥°Ì¾ |
/racg/ | vip.log¤Ê¤É | VIP¡¢ONS¤Ê¤É¤Î¥ê¥½¡¼¥¹¥í¥° |
/client/ | css.log¤Ê¤É | ¥µ¡¼¥Ð¡¼À©¸æ¥æ¡¼¥Æ¥£¥ê¥Æ¥£(srvctl)¤äOCR´ÉÍý(ocrdump¡¢ocrconfig¡¢ocrcheck) |
¥¯¥é¥¹¥¿¡¼¥¦¥§¥¢¤Î¥í¥°¼ý½¸ †
root¥æ¡¼¥¶¡¼¤Ë¤Æ¼Â¹Ô¡Ê$ORA_CRS_HOME¡¢$ORA_BASE¡¢$ORACLE_HOME¤Î´Ä¶ÊÑ¿ô¤òÀßÄꤹ¤ë¡Ë
$ORA_CRS_HOME/bin/diagcollection.pl
¥ª¥×¥·¥ç¥ó | ÀâÌÀ |
--collect | ¥í¥°¾ðÊó¤Î¼ý½¸ --all¡¡¥Ç¥Õ¥©¥ë¥È¡£¤¹¤Ù¤Æ¤Î¥í¥°¤ò¼ý½¸ --crs¡¡CRS¥Û¡¼¥à¤ÎOracle Clusterware¥í¥°¡¢OCR¡¢CORE¥Õ¥¡¥¤¥ë¤ò¼ý½¸ --oh¡¡RAC¥Û¡¼¥à¤ÎOracle Clusterware¥í¥°¤ò¼ý½¸ --nocore¡¡¥³¥¢¥Õ¥¡¥¤¥ë¤ò´Þ¤á¤Ê¤¤ |
--clean | ¸½¹Ô¥Ç¥£¥ì¥¯¥È¥ê¤Ë¸ºß¤¹¤ë¥Õ¥¡¥¤¥ë¤Î¥¯¥ê¡¼¥ó¥¢¥Ã¥×¤ò¹Ô¤¦ ¸½¹Ô¥Ç¥£¥ì¥¯¥È¥ê¤ËƱ̾¥Õ¥¡¥¤¥ë¤¬Â¸ºß¤¹¤ë¤È¾å½ñ¤³Îǧ¤òʹ¤¤¤Æ¤¯¤ë¤Î¤Ç»öÁ°¤Ëºï½ü¤¹¤ë |
--coreanalyze | À¸À®¤µ¤ì¤¿¥Õ¥¡¥¤¥ë¤Ç¸¡½Ð¤µ¤ì¤¿¥³¥¢¥Õ¥¡¥¤¥ë¤Î¤ß¥Æ¥¥¹¥È¥Õ¥¡¥¤¥ë¤ËÃê½Ð |
--help | »ÈÍÑÊýË¡¤òɽ¼¨ |
¥µ¡¼¥Ó¥¹/¥×¥í¥»¥¹ †
¥¯¥é¥¹¥¿¡¼¥µ¡¼¥Ó¥¹ †
̾Á° | ÀâÌÀ |
GCS | ¥¥ã¥Ã¥·¥å¥Õ¥å¡¼¥¸¥ç¥ó¤È¤¤¤¦»ÅÁȤߤòÍøÍѤ·¥¥ã¥Ã¥·¥å°ì´ÓÀ¤òÄ󶡤¹¤ë¥µ¡¼¥Ó¥¹ ¡ ¥Î¡¼¥ÉA¤¬¥Ç¡¼¥¿¤ò¼èÆÀ¡Ê¥Ç¡¼¥¿¤Ï¥Ç¥£¥¹¥¯¤«¤éÆɤ߼è¤é¤ì¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å¤ËÃߤ¨¤é¤ì¤ë¡Ë ¢ ¥Î¡¼¥ÉB¤¬Æ±¤¸¥Ç¡¼¥¿¤ò¼èÆÀ¤òÍ×µá ¢¨ £ ¥Î¡¼¥ÉA¤Ï¥Î¡¼¥ÉB¤Ø¥Ö¥í¥Ã¥¯Å¾Á÷¤ò¹Ô¤¦¡Ê¥Ö¥í¥Ã¥¯Å¾Á÷¤Ë¤è¤ê¥Ç¥£¥¹¥¯¤ÎI/O¤ÏȯÀ¸¤·¤Ê¤¤¡Ë ¢¨¥Î¡¼¥ÉB¤Ï¥ê¥½¡¼¥¹¥Þ¥¹¥¿¡¼¤ØÍ×µá¤ò¹Ô¤¤¡¢¥ê¥½¡¼¥¹¥Þ¥¹¥¿¡¼¤Ï¥Ö¥í¥Ã¥¯¤òÊÝ»ý¤·¤Æ¤¤¤ë¥Î¡¼¥ÉA¤ØžÁ÷»Ø¼¨¤ò¹Ô¤¦ |
GES | ¥¥ã¥Ã¥·¥å°ì´ÓÀ°Ê³°¤ÎÇÓ¾À©¸æ¤òÄ󶡤¹¤ë¥µ¡¼¥Ó¥¹¡£ DML¤Ë¤è¤ë¥í¥Ã¥¯½èÍý¤Ê¤É¥Î¡¼¥ÉA¤Ç¹Ô¥í¥Ã¥¯¤¬È¯À¸¤·¤Æ¤¤¤ë¥Æ¡¼¥Ö¥ë¤ËÂФ·¤Æ¥Î¡¼¥ÉB¤¬Æ±¤¸¹Ô¥í¥Ã¥¯¤¹¤ëSQL¤ò¤·¤¿¾ì¹ç¡¢¹Ô¥í¥Ã¥¯¤òÊÝ»ý¤·¤¿¤Þ¤Þ¥¥ã¥Ã¥·¥å¥Õ¥å¡¼¥¸¥ç¥ó¤¬¹Ô¤ï¤ì¤ë |
¥Ð¥Ã¥¯¥°¥é¥¦¥ó¥É¥×¥í¥»¥¹ †
¥×¥í¥»¥¹Ì¾ | ÀâÌÀ |
PMON | ¾¤Î¥Ð¥Ã¥¯¥°¥é¥¦¥ó¥É¥×¥í¥»¥¹¤ò´Æ»ë¤·¡¢¥µ¡¼¥Ð¡¼¥×¥í¥»¥¹¤¬°Û¾ï½ªÎ»¤·¤¿¾ì¹ç¤ËÉüµì¤ò¹Ô¤¦ |
SMON | ¥¤¥ó¥¹¥¿¥ó¥¹¥ê¥«¥Ð¥ê¡Ê¾ã³²¸å¤Î¥¤¥ó¥¹¥¿¥ó¥¹ºÆµ¯Æ°»þ¤Ë¥³¥ß¥Ã¥È¤µ¤ì¤Æ¤Ê¤¤¥Ç¡¼¥¿¥Ö¥í¥Ã¥¯¤ØREDO¥í¥°¤ò¼«Æ°Åª¤ËŬÍѡˤ·DB¤òÀµ¾ï¤Ê¾õÂÖ¤ËÌ᤹ »È¤Ã¤Æ¤Ê¤¤°ì»þɽÎΰè¤òåºÎï¤Ë¤¹¤ë¡ÊÎ㤨¤Ð¡¢º÷°úºîÀ®»þ¤ÎÎΰè³ä¤êÅö¤Æ¤¬¼ºÇÔ¤·¤¿ºÝ¤Ê¤É¡¢°ì»þɽÎΰè¤òåºÎï¤Ë¤¹¤ë¡Ë |
DBWn | DB¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å¤ÎÆâÍƤò¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Ë½ñ¤¹þ¤à¡£Ê£¿ô¥×¥í¥»¥¹µ¯Æ°¤·½ñ¤¹þ¤ß¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤Î²þÁ±¤¬¤Ç¤¤ë¡Ê¥Þ¥ë¥ÁCPU¤Î¾ì¹ç¡Ë ¼¡¤Î¤è¤¦¤Ê¾ì¹ç¤Ë»ÈÍѺѤߥХåե¡¤ò¥Ç¥£¥¹¥¯¤Ë½ñ¤¹þ¤à ¡¦¥µ¡¼¥Ð¡¼¥×¥í¥»¥¹¤¬¤·¤¤¤ÃͤޤǥХåե¡¥¹¥¥ã¥ó¤·¤Æ¤â¥¯¥ê¡¼¥ó¤ÊºÆÍøÍѤǤ¤ë¥Ð¥Ã¥Õ¥¡¤¬¸«¤Ä¤«¤é¤Ê¤¤¾ì¹ç¤ÏDBWn¤Ë½ñ¤¹þ¤ß¿®¹æ¤¬Á÷¤é¤ì¤ë ¡¦Äê´üŪ¤Ë¥Ð¥Ã¥Õ¥¡¤ò½ñ¤¹þ¤ó¤Ç¡¢REDO¥¹¥ì¥Ã¥ÉÆâ¤Î¥¤¥ó¥¹¥¿¥ó¥¹¥ê¥«¥Ð¥ê¤ò³«»Ï¤¹¤ë°ÌÃÖ¡Ê¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¡Ë¤ò¿Ê¤á¤ë¡£ ¡¡¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤Î¥í¥°¤Î°ÌÃ֤ϥХåե¡¥¥ã¥Ã¥·¥åÆâ¤Î¤â¤Ã¤È¤â¸Å¤¤»ÈÍѺѤߥХåե¡¥¥ã¥Ã¥·¥å¤Ë¤è¤Ã¤Æ·è¤Þ¤ë |
LGWR | REDO¥í¥°¥Ð¥Ã¥Õ¥¡¤ÎÆâÍƤòREDO¥í¥°¥Õ¥¡¥¤¥ë¤Ø½ñ¤¹þ¤à¡£ ½ñ¤¹þ¤à¥¿¥¤¥ß¥ó¥°¤Ï¡¢COMMIT¡¢REDO¥í¥°¥¹¥¤¥Ã¥Á¡¢LGWR¤Ë¤è¤ëºÇ¸å¤Î½ñ¤¹þ¤ß¤«¤é3É÷вᤷ¤¿»þ¡¢DBWn¤¬½¤ÀµºÑ¤ß¥Ð¥Ã¥Õ¥¡¤ò¥Ç¥£¥¹¥¯¤Ë½ñ¤¹þ¤àɬÍפ¬¤¢¤ë¤È¤ |
CKPT | ¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥å¤È¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òƱ´ü¤¹¤ë¤¿¤á¤Î¥¤¥Ù¥ó¥È¡£ ¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬È¯À¸¤¹¤ë¤È¿·¤·¤¤¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¾ðÊó¡ÊSNC¤Ê¤É¡Ë¤ÇÀ©¸æ¥Õ¥¡¥¤¥ë¤ä¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¥Ø¥Ã¥À¡¼¤ò¹¹¿·¤·¡¢DBWn¤Ë¥Ç¡¼¥¿¥Ö¥í¥Ã¥¯¤ò¥Ç¥£¥¹¥¯¤Ë½ñ¤¹þ¤à¤è¤¦¤Ë°ÍÍꤹ¤ë¡£ ¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤òÍøÍѤ¹¤ëÌÜŪ¤Ï ¡¦¥¤¥ó¥¹¥¿¥ó¥¹¾ã³²»þ¤Î¥ê¥«¥Ð¥ê»þ´Ö¤Îû½Ì ¥Ð¥Ã¥Õ¥¡¥¥ã¥Ã¥·¥åÆâ¤Î»ÈÍѺѤߥХåե¡¤¬Äê´üŪ¤Ë¥Ç¥£¥¹¥¯¤Ë½ñ¤¹þ¤Þ¤ì¤ë¤³¤È¤òÊݾڤ¹¤ë DB¤ÎÄ̾ïÄä»ß¤¬¼Â¹Ô¤µ¤ì¤¿ºÝ¤Ë¤¹¤Ù¤Æ¤Î¥³¥ß¥Ã¥ÈºÑ¤ß¥Ç¡¼¥¿¤¬¥Ç¥£¥¹¥¯¤Ë½ñ¤¹þ¤Þ¤ì¤ë¤³¤È¤òÊݾڤ¹¤ë |
MMON MMNL | AWR¤Ë´Ø¤¹¤ë¿¿ô¤Î¥¿¥¹¥¯¤ò¼Â¹Ô¤¹¤ë¡£ MMON¤Ï¥¹¥Ê¥Ã¥×¥·¥ç¥Ã¥È¤ò¼èÆÀ¤·Á°²óÊѹ¹¤µ¤ì¤¿SQL¥ª¥Ö¥¸¥§¥¯¥È¤ÎÅý·×¿ôÃͤò¼èÆÀ¤·¤Æ¥á¥È¥ê¥Ã¥¯¤¬¤½¤Î¤·¤¤¤ÃͤòĶ¤¨¤¿¤È¤¤Ë½ñ¤¹þ¤ß¤ò¹Ô¤¦¡£ ´ÉÍýÀ¥â¥Ë¥¿¡¼¥×¥í¥»¥¹¡ÊMMNL¡Ë¤ÏSGA¤Î¥¢¥¯¥Æ¥£¥Ö¥»¥Ã¥·¥ç¥óÍúÎò¡ÊASH¡Ë¥Ð¥Ã¥Õ¥¡Æâ¤ÎÅý·×¤ò¥Ç¥£¥¹¥¯¤Ë½ñ¤¹þ¤à |
RECO | ¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤¬¥Í¥Ã¥È¥ï¡¼¥¯¾å¤ÎÊ£¿ô¤ÎDB¤Ç½èÍý¤¹¤ë¤³¤È¤òʬ»¶½èÍý¤È¸À¤¤¡¢Ê¬»¶½èÍý¤Ç°·¤ï¤ì¤ë¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤Î¾ã³²¤ò²ò·è¤¹¤ë |
ARCn | REDO¥í¥°¥¹¥¤¥Ã¥Á¤¬¹Ô¤ï¤ì¤ë¤È¥ª¥ó¥é¥¤¥óREDO¥í¥°¤ò¥ª¥Õ¥é¥¤¥ó¥Õ¥¡¥¤¥ë¤È¤È¤·¤Æ¥³¥Ô¡¼¤¹¤ë¡ÊDB¤¬¥¢¡¼¥«¥¤¥Ö¥í¥°¥â¡¼¥É¤Ë¤Ê¤Ã¤Æ¤¤¤ë¾ì¹ç¤Î¤ß¡Ë |
¥¯¥é¥¹¥¿¡¼´Ä¶¤Ç¤Î¤ß¼Â¹Ô¤µ¤ì¤ë¥Ð¥Ã¥¯¥°¥é¥¦¥ó¥É¥×¥í¥»¥¹ †
¥×¥í¥»¥¹Ì¾ | ÀâÌÀ |
LMON | ¥¯¥é¥¹¥¿¤Ë¥¤¥ó¥¹¥¿¥ó¥¹¤ÎÄɲá¦ÀÚ¤êÎ¥¤·¤¬¹Ô¤ï¤ì¤ë¤³¤È¤ò¸¡ÃΤ·¥°¥í¡¼¥Ð¥ë¥ê¥½¡¼¥¹¤ÎºÆ¹½ÃÛ¤ò¹Ô¤¦ |
LMD0 | ¥Ç¥Ã¥È¥í¥Ã¥¯¤Î´ÉÍý¤ä¥í¥Ã¥¯¥â¡¼¥É¤ÎÊÑ´¹¡ÊÇÓ¾¥â¡¼¥É¡¢¶¦Í¥â¡¼¥É¤Ê¤É¡Ë¤ÎGES¥ê¥½¡¼¥¹Ä´À°¤ò¹Ô¤¦ |
LCK0 | ÉÔÀµ¤Ê¥í¥Ã¥¯¡¢»ÈÍÑÃæ¥í¥Ã¥¯¥ê¥¹¥È¤Ê¤É¤òºîÀ®¤·GES¥ê¥½¡¼¥¹Í×µá¤ò½èÍý¤¹¤ë |
LMSn | ¥¤¥ó¥¹¥¿¥ó¥¹´Ö¤Ç¤Î¥á¥Ã¥»¡¼¥¸¤Îή¤ì¤òÀ©¸æ¤·¡¢¥¥ã¥Ã¥·¥å°ì´·À¤Î¤¿¤á¤Î¥Ç¡¼¥¿¥Ö¥í¥Ã¥¯Å¾Á÷Åù¤ÎGCS¥ê¥½¡¼¥¹Ä´À°¤ò¹Ô¤¦ |
DIAG | ¥¤¥ó¥¹¥¿¥ó¥¹Æâ¤Î¾õÂÖ¤ò´Æ»ë¤·¡¢¥¤¥ó¥¹¥¿¥ó¥¹Æâ¤Î¥×¥í¥»¥¹¤¬°Û¾ï½ªÎ»¤·¤¿¾ì¹ç¤Ë¿ÇÃǥǡ¼¥¿¤òÊÝ»ý¤¹¤ë |
¢¨¥Ð¥Ã¥¯¥°¥é¥¦¥ó¥É¥×¥í¥»¥¹°ìÍ÷
REDO¥í¥° †
¥Ç¡¼¥¿¤ËÂФ·¤Æ¹Ô¤ï¤ì¤¿¤¹¤Ù¤Æ¤ÎÊѹ¹ÍúÎò¤òµÏ¿¤¹¤ë¥Õ¥¡¥¤¥ë¤Ç¾ã³²»þ¤Î¥ê¥«¥Ð¥ê¤Ë»ÈÍÑ¡£
¼ç¤Ê¥Æ¡¼¥Ö¥ë †
¥Ó¥å¡¼ | ÀâÌÀ |
V$LOG | À©¸æ¥Õ¥¡¥¤¥ë¤«¤é¤Î¥í¥°¥Õ¥¡¥¤¥ë¾ðÊó |
V$LOGFILE | REDO¥í¥°¥Õ¥¡¥¤¥ë¤Î¾ðÊó |
DBA_HIST_LOG | ¥í¥°¥Õ¥¡¥¤¥ë¤ÎÍúÎò¾ðÊó¤ÇV$LOG¤Î¥¹¥Ê¥Ã¥×¾ðÊ󤬴ޤޤì¤ë |
REDO¥í¥°¤Î¹½À® †
REDO¥í¥°¤ÏÊ£¿ô¥á¥ó¥Ð¡¼¡Ê¥Õ¥¡¥¤¥ë¡Ë¤«¤é¤Ê¤ë¥°¥ë¡¼¥×¤Ç¹½À®¤µ¤ì¤ë¡£
¥¤¥ó¥¹¥¿¥ó¥¹Ëè¤Ë¡¢¥¹¥ì¥Ã¥É¤¬³ä¤ê¿¶¤é¤ì¤ë¡£
- ¥°¥ë¡¼¥×1¡Ê¥Õ¥¡¥¤¥ë1a¡¢¥Õ¥¡¥¤¥ë1b¡Ë
- ¥°¥ë¡¼¥×2¡Ê¥Õ¥¡¥¤¥ë2a¡¢¥Õ¥¡¥¤¥ë2b¡Ë
- ¥°¥ë¡¼¥×3¡Ê¥Õ¥¡¥¤¥ë3a¡¢¥Õ¥¡¥¤¥ë3b¡Ë
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ -------------------
1 1 2181 52428800 512 2 NO CURRENT 214366325 2016-04-07 09:00:54 2.8147E+14
2 1 2180 52428800 512 2 NO INACTIVE 214294773 2016-04-06 23:36:01 214366325 2016-04-07 09:00:54
3 2 1819 52428800 512 2 NO INACTIVE 214205326 2016-04-06 12:00:25 214358417 2016-04-07 08:00:14
4 2 1820 52428800 512 2 NO CURRENT 214358417 2016-04-07 08:00:14 2.8147E+14
¥Ç¡¼¥¿¤¬¹¹¿·¤µ¤ì¤ë¤È¡¢°ìöREDO¥í¥°¥Ð¥Ã¥Õ¥¡¡Ê¥á¥â¥ê¡Ë¤Ë³ÊǼ¤µ¤ìLGWR¤Ë¤è¤Ã¤ÆREDO¥í¥°¥Ð¥Ã¥Õ¥¡¤«¤é¡¢REDO¥í¥°¥Õ¥¡¥¤¥ë¤Ë½ñ¤¹þ¤ß¤¬¹Ô¤ï¤ì¤ë¡£
¥°¥ë¡¼¥×Æâ¤Î¥Õ¥¡¥¤¥ëÁ´¤Æ¤ËÂФ·¤ÆÁ´¤¯Æ±¤¸ÆâÍƤòƱ»þ¤Ë½ñ¤¹þ¤à¡ÊÂѾ㳲À¤ò¹Íθ¡Ë
¥Ð¥Ã¥Õ¥¡¤«¤é¡¢¥í¥°¤Ë½ñ¤¹þ¤Þ¤ì¤ë¥¿¥¤¥ß¥ó¥°¤Ï
- ¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤Î¥³¥ß¥Ã¥È»þ
- REDO¥í¥°¡¦¥Ð¥Ã¥Õ¥¡¤Î3ʬ¤Î1¤¬¤¤¤Ã¤Ñ¤¤¤Ë¤Ê¤Ã¤¿¤È¤
- ¥¿¥¤¥à¥¢¥¦¥ÈȯÀ¸»þ¡Ê3ÉáË
¥°¥ë¡¼¥×Æâ¤Î¥Õ¥¡¥¤¥ëÍÆÎ̤¬°ìÇդˤʤë¤È¥í¥°¥¹¥¤¥Ã¥Á¤ò¹Ô¤¤¼¡¤ÎREDO¥í¥°¥°¥ë¡¼¥×¤ËÊѹ¹ÍúÎò¤ò½ñ¤¹þ¤à¡£
¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È †
REDO¥í¥°¤ËÈæ¤Ù¤Æ¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ÏÃÙ±ä½ñ¤¹þ¤ß¤ò¹Ô¤¦°Ù¡¢¥Ç¡¼¥¿¤ËÀ°¹çÀ¤¬¼è¤ì¤Ê¤¯¤Ê¤ë¡£
¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤Ï¡¢REDO¥í¥°¤È¡¢¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ÎÆâÍƤÎƱ´ü¤ò¼è¤ë°Ù¤Î¥¤¥Ù¥ó¥È¤Ç°Ê²¼¤Î¥¿¥¤¥ß¥ó¥°¤ÇȯÀ¸
- ¥í¥°¡¦¥¹¥¤¥Ã¥Á¤¬È¯À¸¤·¤¿¤È¤
- ¥¤¥ó¥¹¥¿¥ó¥¹¤¬ABORT°Ê³°¤ÇÄä»ß¤µ¤ì¤¿¤È¤
- ALTER TABLESPACEʸ¤ÇǤ°Õ¤ÎɽÎΰè¤ò¥ª¥Õ¥é¥¤¥ó¤Ë¤·¤¿¤È¤
¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤Ë´ØÏ¢¤¹¤ë½é´ü²½¥Ñ¥é¥á¡¼¥¿
½é´ü²½¥Ñ¥é¥á¡¼¥¿ | ÀâÌÀ |
LOG_CHECKPOINT_INTERVAL | REDO¥í¥°¤Ë»ØÄꤵ¤ì¤¿¥Ç¡¼¥¿¤¬½ñ¤¹þ¤Þ¤ì¤¿»þ¤Ë¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤ò¼Â¹Ô¡Êñ°Ì¤ÏOS¤Î¥Ö¥í¥Ã¥¯¥µ¥¤¥º¡Ë |
LOG_CHECKPOINT_TIMEOUT | ¤¹¤Ù¤Æ¤Î¥Ð¥Ã¥Õ¥¡¤¬»ØÄꤷ¤¿Éäè¤êŤ¤´Ö¡¢(¥¥ã¥Ã¥·¥åÆâ¤Ë)»ÈÍѺѤǻĤé¤Ê¤¤¤è¤¦¤Ë¤¹¤ë |
LOG_CHECKPOINTS_TO_ALERT | ¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤Î³«»Ï/½ªÎ»¤ò¥¢¥é¡¼¥È¥í¥°¤ËµÏ¿¤¹¤ë¡Ê¥í¥°¥¹¥¤¥Ã¥Á¤Ï¥Ñ¥é¥á¡¼¥¿¤Ë´Ø·¸¤Ê¤¯µÏ¿¤µ¤ì¤ë¡Ë |
REDO¥í¥°¤ÎDUMP †
Êѹ¹ÍúÎò¤òDUMP¤·¤Æ¥Æ¥¥¹¥Èɽ¼¨¤¹¤ë¡£
ALTER SYSTEM DUMP LOGFILE 'REDO¥í¥°¥Õ¥¡¥¤¥ë¤ÎFULLPATH'
DBA MIN file_id# block_id#
DBA MAX file_id# block_id#;
¢¨ file_id# ¤È block_id# ¤ò»ØÄꤹ¤ë¤³¤È¤ÇDUMP¤¹¤ë¥ª¥Ö¥¸¥§¥¯¥È¤ò¹Ê¤ê¹þ¤ó¤Ç¤¤¤ë
¢¨ file_id# ¤È block_id# ¤Ï DBA_EXTENTS¥Æ¡¼¥Ö¥ë¤«¤é³Îǧ¤¹¤ë
¥¢¡¼¥«¥¤¥Ö¥í¥° †
¼ç¤Ê¥Æ¡¼¥Ö¥ë †
½é´ü²½¥Ñ¥é¥á¡¼¥¿ †
½é´ü²½¥Ñ¥é¥á¡¼¥¿ | ÀâÌÀ |
DB_RECOVERY_FILE_DEST | ¥ê¥«¥Ð¥êÎΰè¤ÎÊݸÀè |
DB_RECOVERY_FILE_DEST_SIZE | ¥ê¥«¥Ð¥êÎΰè¤ÎºÇÂ祵¥¤¥º |
¥¢¡¼¥«¥¤¥Ö¥í¥° †
ARCHIVELOG¥â¡¼¥É¤Ë¤·¤¿¾ì¹ç¡¢ÍÆÎÌFULL¤Ë¤Ê¤Ã¤Æ¤¤¤ëREDO¥í¥°¥Õ¥¡¥¤¥ë¤Î¥³¥Ô¡¼¤òºîÀ®¤¹¤ë¡£
ARCHIVE¤¬½ªÎ»¤¹¤ë¤Þ¤Ç¡¢REDO¥í¥°¡¦¥Õ¥¡¥¤¥ë¤Ï¾å½ñ¤¤µ¤ì¤Ê¤¤¡£
¥¢¡¼¥«¥¤¥Ö¥í¥°¤Î¾ðÊó¤Ï¡¢ARCHIVE LOG LIST¡¡¥³¥Þ¥ó¥É¤Ç³Îǧ²Äǽ¡£
ARCHIVE LOG LIST
¥¢¡¼¥«¥¤¥Ö¥í¥°¤Îºï½ü †
ºï½ü¾ò·ï¤ò»ØÄꤷ¤¿¸å¡¢Âоݥե¡¥¤¥ë¤¬É½¼¨¤µ¤ì¡¢YES/NO ¤ÎÁªÂò¤¬¤Ç¤ë¡£YES¤òÁªÂò¤¹¤ë¤³¤È¤Çºï½ü¤µ¤ì¤ë¡£
ºï½ü¤µ¤ì¤¿¥¢¡¼¥«¥¤¥Ö¥í¥°¤Ï¡¢V$ARCHIVED_LOG ¤Î NAME Î󤬶õÇò¤Ë¤Ê¤ë¡£
-- RMAN ¤ËÀܳ
NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
rman target /
rman target [USER]/[PASS]@[¼±ÊÌ»Ò]
-- ¥¢¡¼¥«¥¤¥Ö¥í¥°¤Î¥ê¥¹¥Èɽ¼¨
list archivelog all;
list archivelog like '%¥Õ¥¡¥¤¥ë%';
-- 7Æü°Ê¾åÁ°¤Î¥¢¡¼¥«¥¤¥Ö¥í¥°ºï½ü
delete archivelog until time 'sysdate-7';
-- ¥·¡¼¥±¥ó¥¹No 105 ¤Þ¤Ç¤Î¥¢¡¼¥«¥¤¥Ö¥í¥°ºï½ü
delete archivelog until sequence 105 [ thread 1 ];