DB/Oracle/¥³¥Þ¥ó¥É/À©¸æ¥Õ¥¡¥¤¥ë´ÉÍý

Top/DB/Oracle/¥³¥Þ¥ó¥É/À©¸æ¥Õ¥¡¥¤¥ë´ÉÍý

Ìܼ¡

À©¸æ¥Õ¥¡¥¤¥ë¤ò¤¦¤Þ¤¤¤³¤È´ÉÍý¤¹¤ë¡£¤Ò¤È¤Þ¤ºÂ¿½Å²½¤È¥Ð¥Ã¥¯¥¢¥Ã¥×¡£


À©¸æ¥Õ¥¡¥¤¥ë¤Î¿½Å²½

À©¸æ¥Õ¥¡¥¤¥ë¤ò¿½Å²½¤¹¤ë¡£¥Ç¥Õ¥©¥ë¥È¤Ç¤Ï»°¤Ä¤Ë¿½Å²½¤µ¤ì¤Æ¤¤¤ë¡£

ÊýË¡

  1. ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥ª¡¼¥×¥ó¤¹¤ë
    startup
    
  2. ½é´ü²½¥Ñ¥é¥á¡¼¥¿¤òÊѹ¹¤¹¤ë
    alter system
      set control_files = '/path/to/controlfile01.ctl','/path/to/controlfile02.ctl'
      scope = spfile;
    
  3. ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥·¥ã¥Ã¥È¥À¥¦¥ó¤¹¤ë
    shutdown immediate
    
  4. À©¸æ¥Õ¥¡¥¤¥ë¤ò¥³¥Ô¡¼¤¹¤ë
    cp /path/to/controlfile01.ctl /path/to/controlfile04.ctl
    
  5. ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥ª¡¼¥×¥ó¤¹¤ë
    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