DB/Oracle/¥³¥Þ¥ó¥É/¥Ð¥Ã¥¯¥¢¥Ã¥×¤È¥ê¥«¥Ð¥ê
Ìܼ¡†
Âç»ö¤ÊÂç»ö¤Ê¥Ð¥Ã¥¯¥¢¥Ã¥×¡£
¥æ¡¼¥¶´ÉÍý¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×¡ÊSHUTDOWN ¾õÂ֡ˆ
¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬¥·¥ã¥Ã¥È¥À¥¦¥ó¤·¤¿¾õÂ֤ǤΥХ寥¢¥Ã¥×¡£¤È¤¤¤Ã¤Æ¤â¥³¥Ô¡¼¤¹¤ë¤À¤±¡£
ÊýË¡†
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤òÄä»ß¤µ¤»¤ë
shutdown immediate
- ɬÍפʥե¡¥¤¥ë¤ò¥³¥Ô¡¼¤¹¤ë
- ¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¡Ê$ORACLE_BASE/oradata/<sid>/*.dbf¡Ë
- REDO ¥í¥°¥Õ¥¡¥¤¥ë¡Ê$ORACLE_BASE/oradata/<sid>/*.log¡Ë
- À©¸æ¥Õ¥¡¥¤¥ë¡Ê$ORACLE_BASE/oradata/<sid>/*.ctl¡Ë
- ½é´ü²½¥Ñ¥é¥á¡¼¥¿¥Õ¥¡¥¤¥ë¡Ê$ORACLE_HOME/dbs/spfile<sid>.ora¡Ë
- create pfile from spfile ¤·¤Æ init<sid>.ora ¤â¥³¥Ô¡¼¤¹¤ë¤Î¤â¤è¤¤
- ¤½¤Î¾
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò³«»Ï¤µ¤»¤ë
startup open
¥æ¡¼¥¶´ÉÍý¤ÎɽÎΰè¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×¡ÊOPEN ¾õÂ֡ˆ
¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬¥ª¡¼¥×¥ó¤·¤¿¾õÂÖ¤ÇɽÎΰè¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×¤¹¤ëÊýË¡¡£¤¤¤ï¤æ¤ë¥ª¥ó¥é¥¤¥ó¥Ð¥Ã¥¯¥¢¥Ã¥×¡£
ÊýË¡†
- SYSDBA ¸¢¸Â¤ÇÀܳ¤¹¤ë
conn / as sysdba
- ¥Ð¥Ã¥¯¥¢¥Ã¥×¤Î³«»Ï
alter tablespace <tablespace-name> begin backup;
- OS ¤Îµ¡Ç½¤ÇɽÎΰè¤Ë°¤¹¤ë¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ò¥³¥Ô¡¼¤¹¤ë
- cp ¥³¥Þ¥ó¥É¤Ç *.dbf ¤ò¥³¥Ô¡¼¤·¤Æ¤ª¤¯
- ¥Ð¥Ã¥¯¥¢¥Ã¥×¤Î½ªÎ»
alter tablespace <tablespace-name> end backup;
抠
- ¥ª¥ó¥é¥¤¥ó¥Ð¥Ã¥¯¥¢¥Ã¥×¤Î¾ì¹ç¡¢¥³¥Ô¡¼Ãæ¤â¥Ç¡¼¥¿¤Î¹¹¿·¤¬Áö¤ë¡£À°¹çÀ³ÎÊݤΤ¿¤á¤Ë¤Ï REDO ¥í¥°¤Ë¤è¤ë¥ê¥«¥Ð¥ê¤¬É¬Íס£¤Ç¤â¤½¤ÎÊÕ¤Ï Oracle ¤µ¤ó¤¬¥ê¥«¥Ð¥ê»þ¤Ë¾¡¼ê¤Ë¤ä¤Ã¤Æ¤¯¤ì¤ë
- begin database ¤·¤¿»þÅÀ¤Ç¡¢¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Ø¤Î SCN ¾ðÊó¤Î¹¹¿·½ñ¤¹þ¤ß¤¬»ß¤Þ¤ë¡£¤³¤ì¤Ë¤è¤Ã¤Æ¥ê¥«¥Ð¥ê»þ¤Î¥¹¥¿¡¼¥ÈÃÏÅÀ¤Î SCN ¤¬³Î¼Â¤Ë¸ÇÄꤵ¤ì¤ÆÀ°¹çÀ¤¬¤È¤ê¤ä¤¹¤¯¤Ê¤ë¡£end backup ¤Ç SCN ¤Î¹¹¿·½ñ¤¹þ¤ß¤¬ºÆ³«¤¹¤ë
À©¸æ¥Õ¥¡¥¤¥ë¤Î¥Ð¥Ã¥¯¥¢¥Ã¥×†
È󥯥ê¥Æ¥£¥«¥ë¤Ê¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Î¥ê¥«¥Ð¥ê†
¤¿¤È¤¨¤Ð USERS ɽÎΰè¤Î¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ò¸í¤Ã¤Æ¾Ã¤·¤Æ¤·¤Þ¤Ã¤¿¤È¤¡£¥Ð¥Ã¥¯¥¢¥Ã¥×¤«¤é¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ò¥³¥Ô¡¼¤·¤Æ»ý¤Ã¤Æ¤¤Æ¡Ê¥ê¥¹¥È¥¢¡Ë¡¢REDO ¥í¥°¥Õ¥¡¥¤¥ë¤ò»È¤Ã¤Æ¥ê¥«¥Ð¥ê¤¹¤ëɬÍפ¬¤¢¤ë¡£
¥ª¥ó¥é¥¤¥ó¾õÂ֤ǤΥꥫ¥Ð¥ê¤¬²Äǽ¡£Ää»ß¤µ¤»¤Æ¤«¤é¤Ç¤â¤¤¤¤¤±¤É¡¢²ÄÍÑÀ¤ò¹Íθ¤¹¤ë¤È¶ËÎÏ¥ª¥ó¥é¥¤¥ó¤Î¤Þ¤Þ¤ä¤ê¤¿¤¤¡£
ÊýË¡†
- ɽÎΰè¤ò¥ª¥Õ¥é¥¤¥ó¤Ë¤¹¤ë
-- temporary ¤ÇÅܤé¤ì¤¿¤é immediate ¤Ë¤¹¤ë alter tablespace <tablespace-name> offline { temporary | immediate };
- ¥Ð¥Ã¥¯¥¢¥Ã¥×¥Õ¥¡¥¤¥ë¤«¤é¥ê¥¹¥È¥¢¤¹¤ë
- OS ¤Î¥³¥Þ¥ó¥É¤Ç¥Ð¥Ã¥¯¥¢¥Ã¥×¤«¤é¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ò¸µ¤Î¾ì½ê¤Ë¥³¥Ô¡¼¤¹¤ë
- ¥ê¥«¥Ð¥ê¤ò¼Â¹Ô¤¹¤ë
recover tablespace <tablespace-name> [ auto ]
- auto ¤ò»ØÄꤹ¤ë¤È¾¡¼ê¤ËÁ´Éô¼Â¹Ô¡£»ØÄꤷ¤Ê¤¤¤È¥í¥°¥Õ¥¡¥¤¥ë̾¤ò°ì¸Ä¤º¤Ä³Îǧ¤·¤Æ¤¯¤ë¡ÊEnter ¥¥£¤ÎÏ¢ÂǤ¬É¬ÍסË
¥¯¥ê¥Æ¥£¥«¥ë¤Ê¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Î¥ê¥«¥Ð¥ê†
¥¯¥ê¥Æ¥£¥«¥ë¤Ê¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¡¢¤Ä¤Þ¤ë¤È¤³¤í¤Î SYSTEM ɽÎΰè¤ä UNDO ɽÎΰè¤Î¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤¬¾Ã¼º¤·¤¿¤È¤¤Î¥ê¥«¥Ð¥ê¡£
̵¤¯¤Ê¤Ã¤¿»þÅÀ¤Ç»ß¤Þ¤ë¤Î¤Ç¡¢Í×¥·¥ã¥Ã¥È¥À¥¦¥ó¡£¤·¤«¤¿¤Ê¤¤¡£
ÊýË¡†
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤òÄä»ß¤µ¤»¤ë
shutdown abort
- abort °Ê³°¤Ç¤ÏÄä»ß¤Ç¤¤Ê¤¤¡£¥Õ¥¡¥¤¥ë¤¬¤Ê¤¯¤Æ¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬¼Â¹Ô¤Ç¤¤Ê¤¤¤¿¤á¡£
- ¥Ð¥Ã¥¯¥¢¥Ã¥×¥Õ¥¡¥¤¥ë¤«¤é¥ê¥¹¥È¥¢¤¹¤ë
- OS ¤Î¥³¥Þ¥ó¥É¤Ç¥Ð¥Ã¥¯¥¢¥Ã¥×¤«¤é¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ò¸µ¤Î¾ì½ê¤Ë¥³¥Ô¡¼¤¹¤ë
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥Þ¥¦¥ó¥È¤¹¤ë
startup mount
- ¥Ð¥Ã¥¯¥¢¥Ã¥×¤·¤¿¥Õ¥¡¥¤¥ë¤ò¥ª¥ó¥é¥¤¥ó¤Ë¤¹¤ë
alter database datafile '/path/to/datafile.dbf' online;
- ¥ê¥«¥Ð¥ê¤ò¼Â¹Ô¤¹¤ë
recover datafile '/path/to/datafile.dbf' [ auto ]
- auto ¤ò»ØÄꤹ¤ë¤È¾¡¼ê¤ËÁ´Éô¼Â¹Ô¡£»ØÄꤷ¤Ê¤¤¤È¥í¥°¥Õ¥¡¥¤¥ë̾¤ò°ì¸Ä¤º¤Ä³Îǧ¤·¤Æ¤¯¤ë¡ÊEnter ¥¥£¤ÎÏ¢ÂǤ¬É¬ÍסË
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥ª¡¼¥×¥ó¤¹¤ë
alter database open;
Last-modified: 2011-11-02 (¿å) 15:01:12