DB/Oracle/¥³¥Þ¥ó¥É/REDO ¥í¥°´ÉÍý
Ìܼ¡†
REDO ¥í¥°¤Ë´Ø¤¹¤ë½ô¡¹¤Î´ÉÍýÊýË¡¡£
REDO ¥í¥°¥Õ¥¡¥¤¥ë¤òÀÚ¤êÂؤ¨¤ë†
¥í¥°¥¹¥¤¥Ã¥Á¤òÌÀ¼¨Åª¤Ë¼Â¹Ô¤µ¤»¤ë¡£
ÊýË¡†
- REDO ¥í¥°¥Õ¥¡¥¤¥ë¤òÀÚ¤êÂؤ¨¤ë
alter system switch logfile;
³Îǧ†
- v$log ¤Þ¤¿¤Ï v$logfile ¤«¤é¥í¥°¥°¥ë¡¼¥×¤Î¾ðÊó¤ò³Îǧ
select group#, status from v$log;
¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤ò¼Â¹Ô¤¹¤ë†
¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤òÌÀ¼¨Åª¤Ë¼Â¹Ô¤µ¤»¤ë¡£
ÊýË¡†
- ¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤ò¼Â¹Ô¤¹¤ë
alter system checkpoint;
REDO ¥í¥°¥°¥ë¡¼¥×¤ÎÄɲÆ
¥Ç¥Õ¥©¥ë¥È¤Ç REDO ¥í¥°¥°¥ë¡¼¥×¤Ï»°¤Ä¡£¤³¤ì¤Ë¥°¥ë¡¼¥×¤ò¿·¤·¤¯¤Ò¤È¤ÄÄɲ乤롣
ÊýË¡†
- REDO ¥í¥°¥°¥ë¡¼¥×¤òÄɲ乤ë
-- ¥Õ¥¡¥¤¥ë¤ò¿·µ¬¤ËºîÀ®¤·¤ÆÄɲ乤ë alter database add logfile group <group-number> ('/path/to/redo.log', '/path/to/...') size <file-size>; -- ´û¸¤Î¥Õ¥¡¥¤¥ë¤òºÆÍøÍѤ·¤ÆÄɲ乤ë alter database add logfile group <group-number> ('/path/to/redo.log', '/path/to/...') reuse;
³Îǧ†
- v$log ¤Þ¤¿¤Ï v$logfile ¤«¤é¥í¥°¥°¥ë¡¼¥×¤Î¾ðÊó¤ò³Îǧ
select group#, member from v$logfile; select group#, members, bytes from v$log;
抠
- ¥µ¥¤¥º¤Ï¥°¥ë¡¼¥×¤´¤È¤Ë»ØÄꤹ¤ë
- ¥µ¥¤¥º¤ä¥Õ¥¡¥¤¥ë̾¤ò»ØÄꤷ¤Ê¤¤¤È¥Ç¥Õ¥©¥ë¥È¤¬»È¤ï¤ì¤ë¡£¥µ¥¤¥º¤Ï 100M¤¯¤é¤¤¡¢¥Õ¥¡¥¤¥ë̾¤Ï¥é¥ó¥À¥àʸ»úÎó¤ò´Þ¤ß¡¢¥Ñ¥¹¤Ï¥Õ¥é¥Ã¥·¥å¥ê¥«¥Ð¥êÎΰè
REDO ¥í¥°¥°¥ë¡¼¥×¤Ø¤Î¥á¥ó¥Ð¤ÎÄɲÆ
´û¸¤Î¥í¥°¥°¥ë¡¼¥×¤Ë¿·µ¬¥á¥ó¥Ð¤òÄɲ乤롣
ÊýË¡†
- REDO ¥í¥°¥°¥ë¡¼¥×¤Ë¥á¥ó¥Ð¤òÄɲ乤ë
-- °ì¸Ä¤À¤±Äɲ乤ë alter database add logfile member '/path/to/redo.log' to group <group-number>; -- Ê£¿ôÄɲ乤ë alter database add logfile member '/path/to/redo.log' to group <group-number>, '/path/to/redo.log' to group <group-number>; -- ¥Õ¥¡¥¤¥ë¤òºÆÍøÍѤ¹¤ë alter database add logfile member '/path/to/redo.log' reuse to group <group-number>;
³Îǧ†
- v$log ¤Þ¤¿¤Ï v$logfile ¤«¤é¥í¥°¥°¥ë¡¼¥×¤Î¾ðÊó¤ò³Îǧ
select group#, member from v$logfile; select group#, members, bytes from v$log;
REDO ¥í¥°¥°¥ë¡¼¥×¤Îºï½ü†
ÊýË¡†
- REDO ¥í¥°¥°¥ë¡¼¥×¤òºï½ü¤¹¤ë
alter database drop logfile group <group-number>;
³Îǧ†
- v$log ¤Þ¤¿¤Ï v$logfile ¤«¤é¥í¥°¥°¥ë¡¼¥×¤Î¾ðÊó¤ò³Îǧ
select group#, member from v$logfile; select group#, members, bytes from v$log; select group#, status from v$log;
抠
- ¤³¤Î¥³¥Þ¥ó¥É¤ò¼Â¹Ô¤¹¤ë¤ÈÀ©¸æ¥Õ¥¡¥¤¥ë¤«¤éÅö³º REDO ¥í¥°¥°¥ë¡¼¥×¤Ë´Ø¤¹¤ë¾ðÊ󤬺ï½ü¤µ¤ì¤ë¡£¥í¥°¥Õ¥¡¥¤¥ë¼«ÂΤϺï½ü¤µ¤ì¤Ê¤¤¤Ç»Ä¤ë
- LGRW ¤¬½ñ¤¹þ¤ßÃæ¤Î¥í¥°¥Õ¥¡¥¤¥ë¡Êcurrent ¤Ê¥í¥°¥Õ¥¡¥¤¥ë¡Ë¤Ïºï½ü¤Ç¤¤Ê¤¤¡£ºï½ü¤·¤¿¤¤¾ì¹ç¤Ï¥í¥°¥¹¥¤¥Ã¥Á¤òȯÀ¸¤µ¤»¤Æ inactive ¤Ë¤·¤Æ¤«¤é¹Ô¤¦
alter database switch logfile;
- REDO ¥í¥°¥°¥ë¡¼¥×¤¬Æó¤Ä¤Î¤È¤¤Ë¤Ï¤É¤Á¤é¤âºï½ü¤Ç¤¤Ê¤¤
REDO ¥í¥°¥°¥ë¡¼¥×¤«¤é¤Î¥á¥ó¥Ð¤Îºï½ü†
´û¸¤Î REDO ¥í¥°¥°¥ë¡¼¥×¤«¤é´û¸¤Î¥á¥ó¥Ð¤òºï½ü¤¹¤ë
ÊýË¡†
- REDO ¥í¥°¥°¥ë¡¼¥×¤«¤é¤Î¥á¥ó¥Ð¤Îºï½ü
alter database drop logfile member '/path/to/redo.log';
³Îǧ†
- v$log ¤Þ¤¿¤Ï v$logfile ¤«¤é¥í¥°¥°¥ë¡¼¥×¤Î¾ðÊó¤ò³Îǧ
select group#, member from v$logfile; select group#, members, bytes from v$log;
抠
- ¥°¥ë¡¼¥×ºï½ü»þ¤ÈƱÍÍ¡¢À©¸æ¥Õ¥¡¥¤¥ë¤«¤é¾ðÊó¤Ï¾Ã¤¨¤ë¤¬¥Õ¥¡¥¤¥ë¼«ÂΤϾ䨤ʤ¤
- Current ¤Î¥°¥ë¡¼¥×¤Î¥á¥ó¥Ð¤Ïºï½ü¤Ç¤¤Ê¤¤
- ¥°¥ë¡¼¥×¤Ë¥á¥ó¥Ð¤¬¤Ò¤È¤Ä¤·¤«¤Ê¤¤¾ì¹ç¤Ïºï½ü¤Ç¤¤Ê¤¤
REDO ¥í¥°¥Õ¥¡¥¤¥ë¤Î¥Õ¥¡¥¤¥ë̾¤ÎÊѹ¹†
REDO ¥í¥°¥Õ¥¡¥¤¥ë¤Î¥Õ¥¡¥¤¥ë̾¤òÊѤ¨¤ë¡£¥Õ¥ë¥Ñ¥¹¤Ç»ØÄꤹ¤ë¤Î¤Ç¡¢°ÜÆ°¤Ë¤âÂбþ¡£
ÊýË¡†
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤òÄä»ß¤¹¤ë
shutdown immediate
- REDO ¥í¥°¥Õ¥¡¥¤¥ë¤Î¥Õ¥¡¥¤¥ë̾¤òÊѹ¹¡Ê¤Þ¤¿¤Ï REDO ¥í¥°¥Õ¥¡¥¤¥ë¤ò°ÜÆ°¡Ë¤¹¤ë
mv /path/to/redo.log /new/path/to/newredo.log
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥Þ¥¦¥ó¥È¤¹¤ë
startup mount
- ¿·¤·¤¤ REDO ¥í¥°¥Õ¥¡¥¤¥ë¤Î¾ðÊó¤òÅÐÏ¿¤¹¤ë
alter database rename file '/path/to/redo.log' to '/new/path/to/newredo.log';
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥ª¡¼¥×¥ó¤¹¤ë
alter database open;
³Îǧ†
- v$log ¤Þ¤¿¤Ï v$logfile ¤«¤é¥í¥°¥°¥ë¡¼¥×¤Î¾ðÊó¤ò³Îǧ
select group#, member from v$logfile; select group#, members, bytes from v$log;
REDO ¥í¥°¥Õ¥¡¥¤¥ë¤Î½é´ü²½†
REDO ¥í¥°¥°¥ë¡¼¥×¤ò½é´ü²½¤¹¤ë¡£ÆâÉôŪ¤Ë¤Ï DROP ¤·¤¿¤¢¤È¤Ë ADD ¤·¤Æ¤¤¤ë¤è¤¦¤Ê¤â¤Î¡£CLEAR ¤·¤Ê¤¤¤Ç¤â DROP ¤·¤Æ ADD ¤¹¤ì¤Ð½é´ü²½¤Ë¤Ê¤ë¤¬¡¢¾ì¹ç¤Ë¤è¤Ã¤Æ DROP ¤¬¤Ç¤¤Ê¤¤¤È¤¤â¤¢¤ë¤Î¤Ç¡¢¤³¤¦¤¤¤¦¤È¤¤Ë»È¤¦¡£¶ñÂÎŪ¤Ë¤Ï°Ê²¼¤Î¤è¤¦¤Ê¤È¤¤ËÍøÍÑ¡£
- REDO ¥í¥°¥°¥ë¡¼¥×¤¬Æó¤Ä¤Î¤È¤¤Ë REDO ¥í¥°¥Õ¥¡¥¤¥ë¤ò½é´ü²½¤·¤¿¤¤¾ì¹ç
- REDO ¥í¥°¥°¥ë¡¼¥×¤Î¥á¥ó¥Ð¤¬ÇË»¤·¤Æ¤¤¤ë¤È¤¤Ëºî¤ê¤Ê¤ª¤·¤¿¤¤¾ì¹ç
ÊýË¡†
- REDO ¥í¥°¥Õ¥¡¥¤¥ë¤Î½é´ü²½
-- ¥°¥ë¡¼¥×¤Þ¤ë¤´¤È½é´ü²½¤¹¤ë alter database clear logfile group <group-number>; -- ÆÃÄê¤Î¥á¥ó¥Ð¤À¤±½é´ü²½¤¹¤ë alter database clear logfile '/path/to/redo.log'; -- ¥í¥°¥Õ¥¡¥¤¥ë¤¬¥¢¡¼¥«¥¤¥Ö¤µ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç¤Ë½é´ü²½¤¹¤ë alter database unarchived clear { logfile '/path/to/redo.log' | group <group-number> };
Last-modified: 2011-11-01 (²Ð) 10:41:21