DB/Oracle/¥³¥Þ¥ó¥É/µ¯Æ°¤È½ªÎ»
Ìܼ¡†
¤½¤â¤½¤â¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Îµ¯Æ°¤È½ªÎ»¤ÎÊýË¡¡£µ¯Æ°¾õÂÖ¡¢½ªÎ»¥â¡¼¥É¤Ë¤Ï¤¤¤¯¤Ä¤«¼ïÎब¤¢¤ë¤Î¤Ç¡¢Å¬ÀڤʴÉÍý¤Î¤¿¤á¤Ë¤ÏµóÆ°¤òÀµ³Î¤ËÇÄ°®¤¹¤ëɬÍפ¬¤¢¤ë¡£
µ¯Æ°¤È½ªÎ»†
µ¯Æ°†
SQL*Plus ¤«¤éÁàºî¡£SYSDBA ¤È¤·¤Æ¤Ä¤Ê¤¤¤À¾õÂÖ¤ÇÁàºî¤¹¤ë¡£
-- ¤½¤ì¤¾¤ì¤Î¾õÂ֤ޤǵ¯Æ°¤µ¤»¤ë startup [ nomount | mount | open ] -- ¤½¤ì¤¾¤ì¤Î¾õÂÖ¤«¤éµ¯Æ°¥·¡¼¥±¥ó¥¹¤ò°ìÃʳ¬°ú¤¾å¤²¤ë alter database { mount | open };
½ªÎ»†
SQL*Plus ¤«¤éÁàºî¡£SYSDBA ¤È¤·¤Æ¤Ä¤Ê¤¤¤À¾õÂÖ¤ÇÁàºî¤¹¤ë¡£
-- ¥·¥ã¥Ã¥È¥À¥¦¥ó¥â¡¼¥É¤ò»ØÄꤷ¤Æ½ªÎ»¤µ¤»¤ë shutdown [ abort | immediate | transactional | normal ]
¥·¥ã¥Ã¥È¥À¥¦¥ó¥â¡¼¥É¤Î¤½¤ì¤¾¤ì¤Î°ÕÌ£¤Ï¼¡¤Î¤È¤ª¤ê¡£
¥â¡¼¥É | ÀâÌÀ |
abort | ¤È¤Ë¤«¤¯ÃæÃÇ¡£¶¯À©½ªÎ»¡£ÅŸ»¤ò¤Á¤ç¤ó¤®¤ë |
immediate | Á´Éô¤Î¥»¥Ã¥·¥ç¥ó¤È¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤ò¶¯À©½ªÎ»¡Ê¥í¡¼¥ë¥Ð¥Ã¥¯¡Ë¤·¤Æ¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤ò¼Â¹Ô¡¢¥Õ¥¡¥¤¥ë¤ò¥¯¥í¡¼¥º¤¹¤ë |
transactional | Á´Éô¤Î¥»¥Ã¥·¥ç¥ó¤ò¶¯À©½ªÎ»¤·¡¢¼Â¹ÔÃæ¤Î¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤Î½ªÎ»¤òÂÔµ¡¤¹¤ë¡£¤½¤Î¸å¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤ò¼Â¹Ô¡¢¥Õ¥¡¥¤¥ë¤ò¥¯¥í¡¼¥º¤¹¤ë |
normal | Á´Éô¤Î¥»¥Ã¥·¥ç¥ó¤È¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤Î½ªÎ»¤òÂÔµ¡¤·¡¢¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤ò¼Â¹Ô¡¢¥Õ¥¡¥¤¥ë¤ò¥¯¥í¡¼¥º¤¹¤ë |
Last-modified: 2011-11-01 (²Ð) 10:21:51