üũÆ÷ÀÎÆ® (Checkpoint)
Á¤ÀÇ
Àå¾Ö½Ã recovery¸¦ ºü¸£°Ô Çϱâ À§ÇØ DBWn°¡ LGWR¿ÍÀÇ °¸À» ÁÙ¿©ÁÖ´Â ÇàÀ§
DBWn´Â Block ´ÜÀ§·Î °»½ÅÇϱ⠶§¹®¿¡ ¾²±â°¡ ´À¸±¼ö ¹Û¿¡ ¾ø°í °»½ÅµÈ ÃÖ¼ÒÇÑÀÇ µ¥ÀÌÅ͸¸ °¡Á®°¡´Â LGWR¿ÍÀÇ °¸ÀÌ ¹ß»ýÇÒ ¼ö ¹Û¿¡ ¾ø´Âµ¥ ÀÌ°¸À» ÁÙ¿©¾ß Àå¾Ö½Ã recovery¾çÀÌ ÁÙ¾îµç´Ù
üũÆ÷ÀÎÆ®°¡ ¹ß»ýÇϸé DBWn°¡ ÀÛµ¿Çϸç CKPT°¡ ÀÌ Á¤º¸¸¦ control file°ú µ¥ÀÌÅÍÆÄÀÏ Çì´õ¿¡ ±â·ÏÇÏ°Ô µÈ´Ù
üũÆ÷ÀÎÆ® ¹ß»ý½Ã±â
¨ç DB clean shutdown ½Ã
¨è Log Switch ½Ã
¨é ALTER SYSTEM CHECKPOINT ·Î DBA°¡ ¼öµ¿À¸·Î ¸í·É
¨ê TABLESPACEÀÇ »óŸ¦ online¿¡¼ offline³ª read only·Î Àüȯ½Ã (±â·Ï¸øÇß´ø°ÍÀ» ±â·ÏÇØ¾ß Çϴϱñ)
¨ë °ü·Ã ÆĶó¹ÌÅÍ ¿µÇâ
üũÆ÷ÀÎÆ®¸¦ ¹ß»ý½ÃÅ°´Âµ¥ ¿µÇâÀ» ÁÖ´Â °ü·Ã ÆĶó¹ÌÅÍ
-. LOG_CHECKPOINT_TIMEOUT
üũÆ÷ÀÎÆ® À§Ä¡¿Í ¸¶Áö¸· ¸®µÎ¾²±â »çÀÌÀÇ ½Ã°£(ÃÊ) (oracle 7)
-. LOG_CHECKPOINT_INTERVAL
üũÆ÷ÀÎÆ® À§Ä¡¿Í ¸¶Áö¸· ¸®µÎ¾²±â »çÀÌÀÇ ºí·°¼ö (oracle 7)
-. FAST_START_IO_TARGET
Àå¾Ö½Ã recovery¸¦ ¼öÇàÇϴµ¥ ÇÊ¿äÇÑ I/O ÀÛ¾÷ Ƚ¼ö (oracle 8i)
-. FAST_START_MTTR_TARGET
Àå¾Ö½Ã recovery¸¦ ¼öÇàÇϴµ¥ ÇÊ¿äÇÑ ½Ã°£(ÃÊ) (oracle 9i)
°¡Àå ±Ç°íµÇ´Â ÆĶó¹ÌÅÍ
MTTR : Mean Time To Recover
°ü·Ã ºä