DB/Oracle/¥³¥Þ¥ó¥É/À©¸æ¥Õ¥¡¥¤¥ë´ÉÍý
Ìܼ¡ †
À©¸æ¥Õ¥¡¥¤¥ë¤ò¤¦¤Þ¤¤¤³¤È´ÉÍý¤¹¤ë¡£¤Ò¤È¤Þ¤ºÂ¿½Å²½¤È¥Ð¥Ã¥¯¥¢¥Ã¥×¡£
À©¸æ¥Õ¥¡¥¤¥ë¤Î¿½Å²½ †
À©¸æ¥Õ¥¡¥¤¥ë¤ò¿½Å²½¤¹¤ë¡£¥Ç¥Õ¥©¥ë¥È¤Ç¤Ï»°¤Ä¤Ë¿½Å²½¤µ¤ì¤Æ¤¤¤ë¡£
ÊýË¡ †
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥ª¡¼¥×¥ó¤¹¤ë
startup
- ½é´ü²½¥Ñ¥é¥á¡¼¥¿¤òÊѹ¹¤¹¤ë
alter system set control_files = '/path/to/controlfile01.ctl','/path/to/controlfile02.ctl' scope = spfile;
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥·¥ã¥Ã¥È¥À¥¦¥ó¤¹¤ë
shutdown immediate
- À©¸æ¥Õ¥¡¥¤¥ë¤ò¥³¥Ô¡¼¤¹¤ë
cp /path/to/controlfile01.ctl /path/to/controlfile04.ctl
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥ª¡¼¥×¥ó¤¹¤ë
startup
³Îǧ †
- ½é´ü²½¥Ñ¥é¥á¡¼¥¿ control_files ¤ÎÃͤò³Îǧ¤¹¤ë
show parameter control_files
Êä †
- ¥Ç¥Õ¥©¥ë¥È¤ÎÊݸ¥Ñ¥¹¤Ï $ORACLE_BASE/oradata/<sid>/control01.ctl
À©¸æ¥Õ¥¡¥¤¥ë¤Î¥Ð¥Ã¥¯¥¢¥Ã¥× †
À©¸æ¥Õ¥¡¥¤¥ë¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×¤¹¤ë¡£¥ª¡¼¥×¥ó¾õÂ֤ǹԤäƤ⤤¤¤¤·¡¢¥·¥ã¥Ã¥È¥À¥¦¥ó¾õÂ֤ǹԤäƤ⤤¤¤¡£
À©¸æ¥Õ¥¡¥¤¥ë¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×¤·¤Ê¤±¤ì¤Ð¤¤¤±¤Ê¤¤¥±¡¼¥¹¤Ï°Ê²¼¡£¤³¤ì¤é¤ÎÁàºî¤Ç¤ÏÀ©¸æ¥Õ¥¡¥¤¥ë¤¬Êѹ¹¤µ¤ì¤ë¡£
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥â¡¼¥ÉÊѹ¹¡ÊNOARCHIVELOG ¥â¡¼¥É¤«¤é ARCHIVELOG ¥â¡¼¥É¤Ë¤·¤¿¾ì¹ç¡Ë
- ɽÎΰè¤ÎºîÀ®¡¢Êѹ¹¡¢ºï½ü
- REDO ¥í¥°¥°¥ë¡¼¥×¤ª¤è¤Ó¥á¥ó¥Ð¤ÎÄɲá¢Êѹ¹¡¢ºï
ÊýË¡ †
À©¸æ¥Õ¥¡¥¤¥ë¤ò¥·¥ã¥Ã¥È¥À¥¦¥ó¾õÂÖ»þ¤Ë¥Ð¥Ã¥¯¥¢¥Ã¥×¤¹¤ë †
OS ¤Î¥Õ¥¡¥¤¥ë¥·¥¹¥Æ¥à¥ì¥Ù¥ë¤Ç¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×¡£Íפ¹¤ë¤Ë cp ¤Ç¥³¥Ô¡¼¤·¤Æ¤ª¤¯¤À¤±¡£
cp $ORACLE_BASE/oradata/<sid>/*.ctl /path/to/backup/directory
À©¸æ¥Õ¥¡¥¤¥ë¤ò¥ª¡¼¥×¥ó¾õÂÖ»þ¤Ë¥Ð¥Ã¥¯¥¢¥Ã¥×¤¹¤ë †
ÊýË¡¤Ï¤Õ¤¿¤Ä¡£À©¸æ¥Õ¥¡¥¤¥ë¤ò¤½¤Î¤Þ¤Þ¥³¥Ô¡¼¤¹¤ë¤«¡¢¥È¥ì¡¼¥¹¥Õ¥¡¥¤¥ë¤Ë½ÐÎϤ¹¤ë¤«¡£
Êä †
¥ª¡¼¥×¥ó¾õÂ֤ǤΥХ寥¢¥Ã¥× †
- ÊÌ¥Õ¥¡¥¤¥ë¤Ë¥³¥Ô¡¼¤¹¤ë¤È¤¡¢¥Õ¥¡¥¤¥ë̾¤Î¤ß¤ò»ØÄꤷ¤¿¾ì¹ç¤Ï $ORACLE_HOME/dbs/ ²¼¤ËºîÀ®¤µ¤ì¤ë
- ¥È¥ì¡¼¥¹¥Õ¥¡¥¤¥ë¤Ï $ORACLE_BASE/diag/rdbms/<sid>/<sid>/trace/<sid>_ora_*.trc ¤Ë½ÐÎϤµ¤ì¤ë¡£½ÐÎÏ¥Õ¥¡¥¤¥ë̾¤ÏƱ¤¸¥Ç¥£¥ì¥¯¥È¥ê¤Î alert_<sid>.log ¤Ç³Îǧ¤Ç¤¤ë
- ½ÐÎÏÀè¤Î¥Ç¥£¥ì¥¯¥È¥ê¤Ï°Ê²¼¤Î¥³¥Þ¥ó¥É¤Ç³Îǧ²Äǽ
show parameter user_dump_dest
- ¥È¥ì¡¼¥¹¥Õ¥¡¥¤¥ë¤ÎÃæ¿È¤Ï CREATE CONTROLEFILE ʸ¡£É¬Íפˤʤä¿¤é¡¢Ãæ¿È¤ÎɬÍפÊÉôʬ¤ò¥³¥Ô¡¼¤·¤ÆÀ©¸æ¥Õ¥¡¥¤¥ë¤òÀ¸À®¤µ¤»¤ë¡£NOMOUNT ¾õÂ֤Ǽ¹ԲÄǽ
- ½ÐÎÏÀè¤Î¥Ç¥£¥ì¥¯¥È¥ê¤Ï°Ê²¼¤Î¥³¥Þ¥ó¥É¤Ç³Îǧ²Äǽ
CREATE CONTROLFILE ʸ¤ÎÃæ¿È †
- NORESETLOGS
- REDO ¥í¥°¥Õ¥¡¥¤¥ë¤òÊÝ»ý¤¹¤ë
- MAXLOGFILES n
- ¥í¥°¥Õ¥¡¥¤¥ë¥°¥ë¡¼¥×¤ÎºÇÂçÃÍ
- MAXLOGMEMBERS n
- ¤Ò¤È¤Ä¤Î¥í¥°¥°¥ë¡¼¥×¤ÎºÇÂç¥á¥ó¥Ð¿ô
- MAXDATAFILES n
- ¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ÎºÇÂç¿ô
- MAXLOGHISTORY
- ÊÝ»ý¤¹¤ë¥í¥°½ç½øÈÖ¹æ¤ÎºÇÂç¿ô
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¾õÂÖ¤ÈÀ©¸æ¥Õ¥¡¥¤¥ë¤ÎÊѹ¹ †
- ALTER DATABASE ʸ¤Ï¥Ç¡¼¥¿¥Ù¡¼¥¹¹½Â¤¤ÎÊѹ¹¡¢¤Ä¤Þ¤ë¤È¤³¤íÀ©¸æ¥Õ¥¡¥¤¥ë¤Î½ñ¤´¹¤¨¤¬Â¿¤¤
- NOMOUNT ¾õÂ֤ǤÏÀ©¸æ¥Õ¥¡¥¤¥ë¤Î̾Á°¤òÃΤäƤ¤¤ë¤À¤±¡Ê½é´ü²½¥Ñ¥é¥á¡¼¥¿¤«¤é¡Ë¤ÇÃæ¿È¤ÏÆÉ¤ó¤Ç¤¤¤Ê¤¤¡£À©¸æ¥Õ¥¡¥¤¥ë¤ò½ñ¤´¹¤¨¤ë¾ì¹ç¤ÏÀ©¸æ¥Õ¥¡¥¤¥ë¤¬³«¤«¤ì¤¿¾õÂÖ¡¢¤Ä¤Þ¤ê MOUNT ¾õÂ֤Ǥ¢¤ëɬÍפ¬¤¢¤ë
À©¸æ¥Õ¥¡¥¤¥ë¤Ë´Ø¤¹¤ë¾ðÊó¤Î¼èÆÀ †
À©¸æ¥Õ¥¡¥¤¥ë¤Ë´Ø¤¹¤ë¾ðÊó¤Ï°Ê²¼¤Î¥Ó¥å¡¼¤«¤é¼èÆÀ¤Ç¤¤ë¡£
- v$database
- v$controlefile_record_section
- v$parameter
Last-modified: 2011-11-02 (¿å) 14:23:03