Ƽº£·Î Á¦6Àå ¹é¾÷°ú º¹±¸
https://technet.tmaxsoft.com/upload/download/online/tibero/pver-20150504-000001/tibero_admin/ch_BackupRecovery.html
Á¦6Àå ¹é¾÷°ú º¹±¸
³»¿ë ¸ñÂ÷
Tibero´Â ½Ã½ºÅÛÀÇ ¿¹»óÄ¡ ¸øÇÑ ¿À·ù µîÀ¸·Î ÀÎÇØ µ¥ÀÌÅͺ£À̽º°¡ ºñÁ¤»óÀûÀ¸·Î Á¾·áÇϰųª ½Ã½ºÅÛ¿¡ ¹°¸®ÀûÀÎ ¼Õ»óÀ» ÀÔÀº »óȲÀ» ´ëóÇÏ·Á°í ´Ù¾çÇÑ ¹é¾÷°ú º¹±¸ ¹æ¹ýÀ» Á¦°øÇÑ´Ù.
º» Àå¿¡¼´Â ÀÌ·¯ÇÑ ¹é¾÷°ú º¹±¸ ¹æ¹ýÀ» ¼³¸íÇÑ´Ù.
TiberoÀÇ ÆÄÀÏÀº ÄÁÆ®·Ñ ÆÄÀÏ(Control file), µ¥ÀÌÅÍ ÆÄÀÏ(Data file), Àӽà ÆÄÀÏ(Temp file), ·Î±× ÆÄÀÏ(Log file)·Î ±¸¼ºµÈ´Ù.
°¢ ÆÄÀÏÀÇ Æ¯Â¡°ú ¿ªÇÒÀº ´ÙÀ½°ú °°´Ù.
ÄÁÆ®·Ñ ÆÄÀÏÀº Tibero¸¦ ±¸¼ºÇÏ´Â ¸ðµç ÆÄÀÏÀÇ À§Ä¡¿Í µ¥ÀÌÅͺ£À̽ºÀÇ À̸§ µî µ¥ÀÌÅͺ£À̽ºÀÇ ±¸Á¶¸¦ ÀúÀåÇÏ´Â ÆÄÀÏÀÌ´Ù. ƯÈ÷, Tibero°¡ »ç¿ëÇÏ´Â µ¥ÀÌÅÍ ÆÄÀÏ, ·Î±× ÆÄÀÏ µîÀÇ »óÅ Á¤º¸°¡ ±â·ÏµÈ´Ù. ÄÁÆ®·Ñ ÆÄÀÏÀº Tibero¸¦ ±âµ¿ÇÒ ¶§ º¹±¸°¡ ÇÊ¿äÇÑÁö¸¦ ÆÇ´ÜÇÏ´Â µ¥ »ç¿ëµÈ´Ù.
ÄÁÆ®·Ñ ÆÄÀÏÀº µ¥ÀÌÅͺ£À̽ºÀÇ º¹±¸¿¡ ¸Å¿ì Áß¿äÇÑ ÆÄÀÏÀ̹ǷΠ´Ù¸¥ ¹°¸®Àû ÆÄƼ¼Ç¿¡ ¿©·¯ °³ ÁöÁ¤Çϱ⸦ ±ÇÀåÇÑ´Ù. ¿©·¯ °³¸¦ À¯ÁöÇϸé ÇÑ ÆÄƼ¼Ç¿¡ Àå¾Ö°¡ ¹ß»ýÇÏ¿© ÄÁÆ®·Ñ ÆÄÀÏÀ» »ç¿ëÇÏÁö ¸øÇÏ´õ¶óµµ ´Ù¸¥ ÄÁÆ®·Ñ ÆÄÀÏÀ» ÀÌ¿ëÇÏ¿© º¹±¸ÇÒ ¼ö ÀÖ´Ù.
ÄÁÆ®·Ñ ÆÄÀÏÀº ÇöÀçÀÇ µ¥ÀÌÅͺ£À̽º¸¦ ±¸¼ºÇÏ´Â ÆÄÀÏ¿¡ °üÇÑ Á¤º¸¸¦ ´ã°í ÀÖÀ¸¹Ç·Î ¹Ýµå½Ã ÃֽŠ°ÍÀ¸·Î À¯ÁöÇØ¾ß ÇÑ´Ù. ÄÁÆ®·Ñ ÆÄÀÏÀÇ ¹é¾÷Àº ÇöÀçÀÇ ÄÁÆ®·Ñ ÆÄÀÏ ÀÚü¸¦ ¹é¾÷ÇÏ´Â ¹æ½ÄÀ¸·Î ÀÌ·ç¾îÁöÁö ¾Ê°í, ÄÁÆ®·Ñ ÆÄÀÏÀ» »ý¼ºÇÏ´Â CREATE CONTROLFILE ¹®À» ¹é¾÷ÇØ µÎ¾ú´Ù°¡ º¹±¸°¡ ÇÊ¿äÇÑ °æ¿ì ¹é¾÷ÇØ ³õÀº ÄÁÆ®·Ñ ÆÄÀÏ »ý¼º¹®À» »ç¿ëÇÏ¿© ÄÁÆ®·Ñ ÆÄÀÏÀ» ´Ù½Ã »ý¼ºÇÏ´Â ¹æ½ÄÀ¸·Î ÀÌ·ç¾îÁø´Ù.
ÃÖ½ÅÀÇ ÄÁÆ®·Ñ ÆÄÀÏÀ» À¯ÁöÇϱâ À§Çؼ´Â µ¥ÀÌÅͺ£À̽º¿¡ ÆÄÀÏÀ» Ãß°¡Çϰųª º¯°æÇÏ´Â µî ±¸Á¶»ó º¯È°¡ ÀÖÀ» ¶§¸¶´Ù ÄÁÆ®·Ñ ÆÄÀÏÀÇ »ý¼º¹®À» ¹é¾÷ÇØ¾ß ÇÑ´Ù. ÄÁÆ®·Ñ ÆÄÀÏ ÀÚü¸¦ ¹é¾÷ÇØ µÎ¾ú´Ù°¡ »ç¿ëÇÏ´Â °ÍÀº NOARCHIVELOG ¸ðµå¿¡¼Ã³·³ µ¥ÀÌÅͺ£À̽º Àüü¸¦ ¹é¾÷ÇÏ´Â °æ¿ì¿¡¸¸ »ç¿ëÇÒ ¼ö ÀÖ´Ù.
µ¥ÀÌÅÍ ÆÄÀÏÀº »ç¿ëÀÚÀÇ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â ÆÄÀÏ·Î½á ·Î±× ÆÄÀÏ°ú ÇÔ²² µ¥ÀÌÅͺ£À̽º¸¦ ±¸¼ºÇÏ´Â °¡Àå Áß¿äÇÑ ÆÄÀÏÀÌ´Ù.
Permanent Å×ÀÌºí ½ºÆäÀ̽º¿Í Undo Å×ÀÌºí ½ºÆäÀ̽º¿¡¼ Á¤ÀÇÇÑ ÆÄÀÏ·Î Å×À̺í, À妽º µîÀÇ µ¥ÀÌÅͺ£À̽º °´Ã¼¸¦ ÀúÀåÇÑ´Ù. Å×ÀÌºí ½ºÆäÀ̽º´Â ÇÑ °³ ÀÌ»óÀÇ µ¥ÀÌÅÍ ÆÄÀÏ·Î ÀÌ·ç¾îÁö¸ç, ÇÑ µ¥ÀÌÅÍ ÆÄÀÏÀº ÇϳªÀÇ Å×ÀÌºí ½ºÆäÀ̽º¿¡ ¼ÓÇÑ´Ù.
µ¥ÀÌÅÍ ÆÄÀÏÀº »ç¿ëÀÚÀÇ µ¥ÀÌÅÍ°¡ ¹°¸®ÀûÀ¸·Î ÀúÀåµÇ´Â °ø°£À̹ǷΠ¹Ýµå½Ã ¹é¾÷ÇØ¾ß ÇÑ´Ù.
Àӽà ÆÄÀÏÀº µ¥ÀÌÅͺ£À̽º°¡ ¸Þ¸ð¸®¿¡¼ ó¸®ÇÒ ¼ö ¾ø´Â ¹æ´ëÇÑ ¾çÀÇ µ¥ÀÌÅ͸¦ ´Ù·ç´Â °æ¿ì Àӽ÷Π»ç¿ëÇϱâ À§ÇÑ °ø°£ÀÌ´Ù.
Tibero´Â »ç¿ëÀÚÀÇ ÁúÀǸ¦ ó¸®Çϱâ À§ÇØ Á¤·Ä µîÀÇ ¿¬»êÀ» ¼öÇàÇÒ ¶§¿Í Àӽà Å×À̺í(Temporary Table)ÀÇ µ¥ÀÌÅ͸¦ ÀúÀåÇÒ ¶§ µ¥ÀÌÅÍ ÆÄÀÏÀ» »ç¿ëÇÑ´Ù. µ¥ÀÌÅÍ ÆÄÀÏÀº Àӽà Å×ÀÌºí ½ºÆäÀ̽º(Temporary Tablespace)¿¡¼¸¸ Á¤ÀÇÇÒ ¼ö ÀÖ°í, Àӽà Å×ÀÌºí ½ºÆäÀ̽º´Â Çϳª ÀÌ»óÀÇ µ¥ÀÌÅÍ ÆÄÀÏÀ» °¡Áú ¼ö ÀÖ´Ù.
Àӽà ÆÄÀÏÀº µ¥ÀÌÅͺ£À̽º¸¦ ±¸¼ºÇÏ´Â µ¥ÀÌÅÍ°¡ ¹°¸®ÀûÀ¸·Î ÀúÀåµÇÁö´Â ¾Ê°í ¿î¿µ Áß¿¡ Àӽ÷Π»ç¿ëµÇ´Â ¿µ¿ªÀ̹ǷΠ¹é¾÷ÇÒ ÇÊ¿ä°¡ ¾ø´Ù.
·Î±× ÆÄÀÏÀº ·Î±×¸¦ ÀúÀåÇÏ´Â ÆÄÀÏÀÌ´Ù. µ¥ÀÌÅÍ ÆÄÀÏ¿¡ ±â·ÏµÇ´Â ³»¿ëÀ» ½Ã°£ ¼øÀ¸·Î ±â·ÏÇÏ´Â ÆÄÀÏ·Î½á µ¥ÀÌÅͺ£À̽º¸¦ º¹±¸ÇÒ ¶§ »ç¿ëÇÑ´Ù.
·Î±× ÆÄÀÏÀº ¿î¿µ Áß¿¡ ¼øȯÀûÀ¸·Î Àç»ç¿ëµÇ´Â ¿Â¶óÀÎ ·Î±× ÆÄÀÏ°ú Àç»ç¿ëµÈ ¿Â¶óÀÎ ·Î±× ÆÄÀÏÀ» º¸°üÇÏ´Â ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏ·Î ³ª´¶´Ù.
ARCHIVELOG ¸ðµå·Î ¿î¿µ ÁßÀÏ ¶§¸¸ ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏÀÌ ¸¸µé¾îÁø´Ù. NOARCHIVELOG ¸ðµå¿¡¼´Â ¿Â¶óÀÎ ·Î±× ÆÄÀϸ¸ »ç¿ëÇÑ´Ù. NOARCHIVELOG ¸ðµå¿¡¼´Â Àç»ç¿ëµÇ¾î ¾ø¾îÁø ·Î±× ÆÄÀÏÀÌ ÀÖÀ» ¼ö ÀÖÀ¸¹Ç·Î º¹±¸ÇÒ ¶§ ¸¹Àº Á¦¾àÀÌ µû¸¥´Ù.
·Î±× ÆÄÀÏÀº µ¥ÀÌÅͺ£À̽º º¹±¸ÇÒ ¶§ º¹¿øµÈ µ¥ÀÌÅÍ ÆÄÀÏÀ» ÃֽŠ»óÅ·Πº¹±¸Çϱâ À§ÇØ, µ¥ÀÌÅͺ£À̽º°¡ ¾î¶»°Ô º¯°æµÇ¾î ¿Ô´ÂÁö¿¡ ´ëÇÑ ¸ðµç Á¤º¸¸¦ ±â·ÏÇÑ´Ù. µû¶ó¼ µ¥ÀÌÅÍ ÆÄÀÏ°ú ÇÔ²² ¹Ýµå½Ã ¹é¾÷À» ÇØ¾ß ÇÑ´Ù.
¹é¾÷(Backup)Àº ¿©·¯ °¡Áö À¯ÇüÀÇ Àå¾Ö·ÎºÎÅÍ µ¥ÀÌÅͺ£À̽º¸¦ º¸È£ÇÏ´Â °ÍÀ» ¶æÇÑ´Ù. Áï, ½Ã½ºÅÛ Àå¾Ö°¡ ¹ß»ýÇßÀ» ¶§ º¹±¸¸¦ Çϰųª ½Ã½ºÅÛ ÀÛµ¿À» À¯ÁöÇϱâ À§ÇÑ ÀýÂ÷ ¶Ç´Â ±â¹ýÀÌ´Ù.
Tibero´Â µ¥ÀÌÅͺ£À̽º¸¦ ¹é¾÷ÇÏ´Â ¹æ¹ýÀ» Å©°Ô µÎ °¡Áö·Î ³ª´©¾î ¼öÇàÇÒ ¼ö ÀÖ´Ù.
³í¸®Àû ¹é¾÷À̶õ Å×À̺í, À妽º, ½ÃÄö½º¿Í °°Àº µ¥ÀÌÅͺ£À̽ºÀÇ ³í¸®Àû ´ÜÀ§¸¦ ¹é¾÷ÇÏ´Â °ÍÀ» ¶æÇÑ´Ù. Tibero¿¡¼´Â À̸¦ À§ÇØ tbExport¿Í tbImport À¯Æ¿¸®Æ¼¸¦ Á¦°øÇÏ°í ÀÖ´Ù. tbExport¿Í tbImport¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº "Tibero À¯Æ¿¸®Æ¼ ¾È³»¼"¸¦ Âü°íÇÑ´Ù.
¹°¸®Àû ¹é¾÷À̶õ µ¥ÀÌÅͺ£À̽º¸¦ ±¸¼ºÇÏ´Â ¹°¸®ÀûÀÎ ÆÄÀÏÀ» ¹é¾÷ÇÏ´Â °ÍÀÌ¸ç ¿î¿µÃ¼Á¦¿¡¼ ÆÄÀÏ º¹»ç ¸í·É(COPY)À¸·Î ¹é¾÷ÇÏ´Â °ÍÀ» ¶æÇÑ´Ù. ¹°¸®Àû ¹é¾÷ÀÌ ÇÊ¿äÇÑ ÆÄÀÏ¿¡´Â µ¥ÀÌÅÍ ÆÄÀÏ°ú ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏÀÌ ÀÖ´Ù.
¿Â¶óÀÎ ·Î±× ÆÄÀÏÀº NOARCHIVELOG ¸ðµå¿¡¼ µ¥ÀÌÅͺ£À̽º Àüü¸¦ ¹é¾÷ÇÏ¿© º¹±¸ÇÒ °æ¿ì¿¡¸¸ Àǹ̰¡ ÀÖ´Ù.
ÁÖÀÇ
µ¥ÀÌÅͺ£À̽º°¡ ¿î¿µ ÁßÀÏ ¶§ ¿î¿µÃ¼Á¦ÀÇ ÆÄÀÏ º¹»ç ¸í·ÉÀ» »ç¿ëÇÏ´Â °ÍÀº ¾ÈÀüÇÏÁö ¾ÊÀ¸¹Ç·Î ÁÖÀÇÇÑ´Ù.
º» Àý¿¡¼´Â ¹é¾÷ÀÇ Á¾·ù¸¦ ¼³¸íÇÑ´Ù.
´ÙÀ½Àº Tibero°¡ Á¦°øÇÏ´Â ¹é¾÷ÀÇ Á¾·ùÀÌ´Ù.
¸ðµåº° ¹é¾÷
µ¥ÀÌÅͺ£À̽º¸¦ ARCHIVELOG ¸ðµå·Î ¿î¿µÇÒ ¶§¿Í ±×·¸Áö ¾Ê¾ÒÀ» ¶§ »ç¿ëÇÒ ¼ö ÀÖ´Â ¹é¾÷ ¹æ¹ýÀÌ ´Ù¸£´Ù.
Tibero¸¦ Á¤»óÀûÀ¸·Î Á¾·áÇÑ »óÅ¿¡¼ ¹é¾÷ÇÏ´Â ¹æ¹ýÀÌ´Ù. ½ÇÇà ¿¹´Â ¡°6.2.2. ¹é¾÷ ½ÇÇࡱÀÇ "Consistent ¹é¾÷"À» Âü°íÇÑ´Ù.
TiberoÀÇ µ¥ÀÌÅͺ£À̽º°¡ ¿î¿µ ÁßÀÏ ¶§ ¹é¾÷Çϰųª Á¤»óÀûÀ¸·Î Á¾·áµÇÁö ¾ÊÀº »óÅ¿¡¼ ¹é¾÷ÇÏ´Â ¹æ¹ýÀÌ´Ù. ½ÇÇà ¿¹´Â ¡°6.2.2. ¹é¾÷ ½ÇÇࡱÀÇ "Inconsistent ¹é¾÷"À» Âü°íÇÑ´Ù. ´Ü, NOARCHIVELOG ¸ðµå¿¡¼´Â Á¤ÇÕ¼º ¹®Á¦°¡ ¹ß»ýÇÒ ¼ö ÀÖÀ¸¹Ç·Î ÀÌ ¹æ¹ýÀº Çã¿ëµÇÁö ¾Ê´Â´Ù.
º» Àý¿¡¼´Â Tibero°¡ Á¦°øÇÏ´Â ¹°¸®Àû ¹× ³í¸®ÀûÀÎ ¹é¾÷ ¹æ¹ý¿¡ µû¶ó ¹é¾÷À» ½ÇÇàÇÏ´Â ¿¹¸¦ ¼³¸íÇÑ´Ù.
µ¥ÀÌÅÍ ÆÄÀÏÀ̳ª ·Î±× ÆÄÀÏÀÇ °æ¿ì¿¡´Â µ¥ÀÌÅͺ£À̽º »óÅ¿¡ µû¶ó¼ ¹é¾÷ ¹Þ´Â ¹æ¹ýÀÌ ´Ù¸£¹Ç·Î À̸¦ °¢°¢ µ¥ÀÌÅͺ£À̽º°¡ ¿î¿µ ÁßÀÎ °æ¿ì(Inconsistent ¹é¾÷)¿Í ±×·¸Áö ¾ÊÀº °æ¿ì(Consistent ¹é¾÷)·Î ³ª´©¾î¼ ¼³¸íÇÑ´Ù.
ÄÁÆ®·Ñ ÆÄÀÏ ¹é¾÷
ÄÁÆ®·Ñ ÆÄÀÏÀº ¹°¸®ÀûÀÎ ¹é¾÷°ú ³í¸®ÀûÀÎ ¹é¾÷À» ¸ðµÎ Áö¿øÇÏÁö¸¸, Tibero¿¡¼´Â ÄÁÆ®·Ñ ÆÄÀÏÀÇ ³í¸®ÀûÀÎ ¹é¾÷À» ÃßõÇÑ´Ù. ¹°¸®Àû ¹é¾÷Àº Á¦¾à»çÇ×°ú »ç¿ë¹ýÀÌ º¹ÀâÇϱ⠶§¹®¿¡ ½Ç¼ö¸¦ ¹æÁöÇϱâ À§ÇØ º¸Åë »ç¿ëÇÏÁö ¾Ê´Â °ÍÀÌ ÁÁ´Ù. ¹°¸®Àû ¹é¾÷½Ã µ¥ÀÌÅÍÀÇ Á¤ÇÕ¼ºÀ» ¸ÂÃçÁÖ±â À§ÇØ ¸ðµç µ¥ÀÌÅÍ ÆÄÀÏÀ» ¹é¾÷ÇÑ ÈÄ ¸¶Áö¸·¿¡ ÄÁÆ®·Ñ ÆÄÀÏÀ» ¹é¾÷ÇØ ÁÖ¾î¾ß ÇÑ´Ù. µ¥ÀÌÅͺ£À̽ºÀÇ ±¸Á¶¿¡ º¯È°¡ ÀÏ¾î³ °æ¿ì¿¡´Â ÄÁÆ®·Ñ ÆÄÀÏÀÇ »ý¼º¹®À» ¹é¾÷ÇÏ´Â ³í¸®Àû ¹é¾÷À» »ç¿ëÇÏ´Â °ÍÀ» ±ÇÀåÇÑ´Ù.
´ÙÀ½Àº ÄÁÆ®·Ñ ÆÄÀÏÀ» ¹°¸®Àû ¹é¾÷À¸·Î tibero6/backup µð·ºÅ͸®¿¡ ÀÖ´Â ctrlfile1.ctl ÆÄÀÏ¿¡, ³í¸®Àû ¹é¾÷À¸·Î ÄÁÆ®·Ñ ÆÄÀÏÀÇ »ý¼±¹®À» ctrlfile1.sql ÆÄÀÏ¿¡ ¹é¾÷ÇÏ´Â ¿¹ÀÌ´Ù.
ÄÁÆ®·Ñ ÆÄÀÏÀÇ ¹°¸®Àû ¹é¾÷
[¿¹ 6.1] ÄÁÆ®·Ñ ÆÄÀÏÀÇ ¹°¸®Àû ¹é¾÷
SQL> alter database backup controlfile to '/tibero6/backup/ctrlfile1.ctl'; Altered.
ÄÁÆ®·Ñ ÆÄÀÏÀÇ ³í¸®Àû ¹é¾÷
[¿¹ 6.2] ÄÁÆ®·Ñ ÆÄÀÏÀÇ ¹°¸®Àû ¹é¾÷
SQL> alter database backup controlfile to trace as '/tibero6/backup/ctrlfile1.sql' reuse NORESETLOGS; Altered.
»ý¼ºµÈ ctrlfile1.sql ÆÄÀÏÀº ´ÙÀ½°ú °°Àº ³»¿ëÀ» Æ÷ÇÔÇÑ´Ù.
[¿¹ 6.3] ¹é¾÷µÈ ÄÁÆ®·Ñ ÆÄÀÏ »ý¼º¹®
CREATE CONTROLFILE REUSE DATABASE "inventory" LOGFILE GROUP 0 ( '/disk1/log001.log', '/disk2/log002.log' ) SIZE 1M, GROUP 1 ( '/disk1/log003.log', '/disk2/log004.log' ) SIZE 1M, GROUP 2 ( '/disk1/log005.log', '/disk2/log006.log' ) SIZE 1M NORESETLOGS DATAFILE '/disk1/system001.dtf', '/disk1/undo001.dtf' NOARCHIVELOG MAXLOGFILES 255 MAXLOGMEMBERS 8 MAXDATAFILES 100 CHARACTER SET MSWIN949 NATIONAL CHARACTER SET UTF16 ;
RESETLOGS´Â ÄÁÆ®·Ñ ÆÄÀÏÀÇ »ý¼º¹®¿¡ ÁöÁ¤ÇÑ ´ë·Î ¸¸µé¾îÁø´Ù. ÀÌ »ý¼º¹®Àº Æ®·¹À̽º ÆÄÀÏÀ» »ý¼ºÇÑ ÈÄ RESETLOGS¸¦ ÇÊ¿ä·Î ÇÒ °æ¿ì¿¡ »ç¿ëÇϸç, RESETLOGS°¡ ÇÊ¿äÇÏÁö ¾ÊÀº °æ¿ì´Â NORESETLOGS·Î ¼öÁ¤ÇÏ¿© ÄÁÆ®·Ñ ÆÄÀÏÀ» »ý¼ºÇÒ ¶§ Àû¿ëÇÒ ¼ö ÀÖ´Ù.
Âü°í
ÄÁÆ®·Ñ ÆÄÀÏÀÇ »ý¼º¹®¿¡´Â Àӽà ÆÄÀÏÀ» »ý¼ºÇÏ´Â ³»¿ëÀÌ ¾ø´Ù. ÄÁÆ®·Ñ ÆÄÀÏÀ» »ý¼ºÇÑ ÈÄ Tibero¸¦ ±âµ¿Çϸé Àӽà ÆÄÀÏÀº Á¸ÀçÇÏÁö ¾Ê´Â´Ù. ÄÁÆ®·Ñ ÆÄÀÏÀ» »õ·Î »ý¼ºÇÑ °æ¿ì ¹Ýµå½Ã Àӽà ÆÄÀÏÀ» Ãß°¡ÇØ¾ß Àӽà ÆÄÀÏÀ» ÀÌ¿ëÇÑ ±â´ÉÀ» »ç¿ëÇÒ ¼ö ÀÖ´Ù.
»ý¼ºµÈ ÄÁÆ®·Ñ ÆÄÀÏÀº $TB_SID.tip ÆÄÀÏ¿¡ °æ·Î¸¦ ¼³Á¤ÇÑ´Ù.
´ÙÀ½°ú °°ÀÌ MOUNT³ª OPEN »óÅ¿¡¼ ÄÁÆ®·Ñ ÆÄÀÏÀÇ ¸ñ·ÏÀ» Á¶È¸ÇÏ·Á¸é µ¿Àû ºä V$CONTROLFILE¸¦ Á¶È¸ÇÑ´Ù.
[¿¹ 6.5] ÄÁÆ®·Ñ ÆÄÀÏ Á¶È¸
SQL> SELECT NAME FROM V$CONTROLFILE; NAME ------------------------------------------------------------ /disk1/c1.ctl /disk2/c2.ctl 2 selected.
Âü°í
ÄÁÆ®·Ñ ÆÄÀÏÀ» ´Ù½Ã »ý¼ºÇϱâ À§Çؼ´Â $TB_SID.tip ÆÄÀÏ¿¡ ¼³Á¤µÈ ÄÁÆ®·Ñ ÆÄÀÏÀÇ À§Ä¡¸¦ [¿¹ 6.5]ÀÇ ÁúÀÇ °á°ú¿Í µ¿ÀÏÇÏ°Ô ¼³Á¤ÇÑ ÈÄ CREATE CONTROLFILE ¹®À» ½ÇÇàÇØ¾ß ÇÑ´Ù.
Consistent ¹é¾÷
º» Àý¿¡¼´Â Tibero°¡ Á¤»óÀûÀ¸·Î Á¾·áÇÑ ÈÄ¿¡ ¹é¾÷ÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÑ´Ù.
Consistent ¹é¾÷À» ½ÇÇà Çϱ⿡ ¾Õ¼ ¹é¾÷ÇÒ ÄÁÆ®·Ñ ÆÄÀÏ, µ¥ÀÌÅÍ ÆÄÀÏ, ·Î±× ÆÄÀÏÀ» Á¶È¸ÇÑ´Ù.
´ÙÀ½Àº MOUNT³ª OPEN »óÅ¿¡¼ µ¿Àû ºä V$DATAFILE¸¦ ÅëÇØ µ¥ÀÌÅÍ ÆÄÀÏÀ» Á¶È¸ÇÏ´Â ¹æ¹ýÀÌ´Ù. ¿©±â¼ MOUNT´Â TiberoÀÇ ÀνºÅϽº°¡ ½ÃÀÛµÈ »óÅÂÀ̸ç, OPENÀº ÄÁÆ®·Ñ ÆÄÀÏ¿¡ Á¤ÀÇÇÑ ¸ðµç ÆÄÀÏÀÌ ¿ÀÇÂµÈ »óŸ¦ ÀǹÌÇÑ´Ù.
[¿¹ 6.6] µ¥ÀÌÅÍ ÆÄÀÏÀÇ Á¶È¸
SQL> SELECT NAME FROM V$DATAFILE; NAME ------------------------------------------------------------ /disk1/system001.dtf /disk2/undo001.dtf /disk3/user001.dtf 3 selected.
´ÙÀ½Àº ¿Â¶óÀÎ ·Î±× ÆÄÀÏÀ» MOUNT³ª OPEN »óÅ¿¡¼ Á¶È¸ÇÏ´Â ¹æ¹ýÀÌ´Ù.
[¿¹ 6.7] ¿Â¶óÀÎ ·Î±× ÆÄÀÏÀÇ Á¶È¸
SQL> SELECT MEMBER FROM V$LOGFILE; MEMBER ------------------------------------------------------------ /disk1/log001.log /disk2/log002.log /disk2/log003.log /disk3/log004.log /disk3/log005.log /disk1/log006.log 6 selected.
¿Â¶óÀÎ ·Î±× ÆÄÀÏÀº ARCHIVELOG ¸ðµå°¡ ¾Æ´Ñ °æ¿ì¿¡´Â ¹é¾÷ÇÏÁö ¾Ê´Â °ÍÀÌ ÁÁ´Ù. ARCHIVELOG ¸ðµå¿¡¼´Â ¿Â¶óÀÎ ·Î±× ÆÄÀÏÀÌ ¾ÆÄ«À̺êµÇ±â ¶§¹®¿¡ ¾ÆÄ«À̺êµÈ ÆÄÀÏÀ» ¹é¾÷ÇÏ¸é ¾È µÈ´Ù. Âü°í·Î ¾ÆÄ«À̺êµÈ ÆÄÀÏÀº LOG_ARCHIVE_DEST
ÃʱâÈ ÆĶó¹ÌÅÍ¿¡ ¼³Á¤µÈ À§Ä¡¿¡ ÀúÀåµÈ´Ù.
µ¥ÀÌÅͺ£À̽º´Â ´ÙÀ½°ú °°ÀÌ NORMAL ¸ðµå·Î Á¾·áÇÏ´Â °ÍÀÌ ÁÁ´Ù.
SQL> tbdown NORMAL; Tibero instance was terminated.
µ¥ÀÌÅͺ£À̽º°¡ Á¤»óÀûÀ¸·Î Á¾·áµÇ¸é ¿î¿µÃ¼Á¦º°·Î Á¦°øÇÏ´Â ÆÄÀÏ º¹»ç ¸í·ÉÀ» »ç¿ëÇÏ¿© ¹é¾÷ÇÑ´Ù.
Inconsistent ¹é¾÷
º» Àý¿¡¼´Â Tibero°¡ ¿î¿µ ÁßÀÏ ¶§ ¹é¾÷ÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÑ´Ù.
µ¥ÀÌÅͺ£À̽º°¡ ¿î¿µ ÁßÀÌ¸é ¿î¿µÃ¼Á¦ÀÇ ¸í·É¾î¸¦ »ç¿ëÇØ µ¥ÀÌÅÍ ÆÄÀÏÀ» º¹»çÇÏ´Â °ÍÀº ¾ÈÀüÇÏÁö ¾Ê´Ù. ÀÌ·¯¸é ´ÙÀ½°ú °°Àº ¹®ÀåÀ» ½ÇÇàÇÏ¿© Tibero¿¡ ¹é¾÷ÀÇ ½ÃÀÛ°ú Á¾·á¸¦ Å뺸ÇØ¾ß ÇÑ´Ù.
alter tablespace {tablespace name} begin backup ... alter tablespace {tablespace name} end backup
begin backup°ú end backup ¹®Àå »çÀÌ¿¡´Â ÇØ´ç Å×ÀÌºí ½ºÆäÀ̽ºÀÇ º¯°æ »çÇ׿¡ ´ëÇÑ ·Î±×°¡ ´Ã¾î³ª±â ¶§¹®¿¡ µ¥ÀÌÅͺ£À̽º¿¡ ºÎ´ãÀÌ °¡ÁßµÇ°Ô µÈ´Ù. begin backupÀ» ½ÃÀÛÇÑ ÀÌÈÄ¿¡´Â ½Å¼ÓÇÏ°Ô ¹é¾÷À» ¿Ï·áÇÏ°í end backup »óÅ·Πº¹±Í½ÃÄÑ¾ß ÇÑ´Ù.
Inconsistent ¹é¾÷ÀÇ Àüü °úÁ¤Àº ´ÙÀ½°ú °°´Ù.
¸ÕÀú ¹é¾÷ÇÒ Å×ÀÌºí ½ºÆäÀ̽º¸¦ ¼±Á¤ÇÑ´Ù.
[¿¹ 6.8] Inconsistent ¹é¾÷ - Å×ÀÌºí ½ºÆäÀ̽ºÀÇ ¼±Á¤
SQL> select name,type from v$tablespace; NAME TYPE ------------------------------ ---- SYSTEM DATA UNDO UNDO USER DATA TEMP TEMP 3 selected.
¹é¾÷ÇÒ Å×ÀÌºí ½ºÆäÀ̽º¿¡ ¼ÓÇÑ µ¥ÀÌÅÍ ÆÄÀÏÀ» Á¶È¸ÇÑ ÈÄ begin backup, end backup ¸í·É¾î¸¦ »ç¿ëÇÏ¿© ¹é¾÷À» ¼öÇàÇÑ´Ù. ¿¹¸¦ µé¾î USER Å×ÀÌºí ½ºÆäÀ̽º¸¦ ¹é¾÷ÇÒ °æ¿ì¸¦ °¡Á¤ÇÏ°í ¼öÇàÇÑ´Ù.
[¿¹ 6.9] Inconsistent ¹é¾÷ - begin backup, end backup ¸í·É¾îÀÇ »ç¿ë
SQL> select f.name from v$tablespace t join v$datafile f on t.ts# = f.ts# where t.name = 'USER'; NAME ------------------------------------------------------------ /disk3/user001.dtf 1 selected SQL> alter tablespace SYSTEM begin backup; Altered. SQL> !cp /disk3/user001.dtf /backup/ SQL> alter tablespace SYSTEM end backup; Altered.
Tibero¸¦ ¿î¿µÇÏ´Ù º¸¸é, ¿¹»óÄ¡ ¸øÇÑ Àå¾Ö·Î ÀÎÇØ Á¤»óÀûÀÎ µ¥ÀÌÅͺ£À̽º ¿î¿µÀÌ ¾î·Á¿î »óȲÀÌ ¹ß»ýÇÒ ¼ö ÀÖ´Ù. º¹±¸´Â Àå¾Ö°¡ ¹ß»ýÇÏ´Â °æ¿ì º¹¿øÇÏ´Â ÀÏ·ÃÀÇ °úÁ¤ÀÌ´Ù.
º¹±¸¸¦ ÇÏ·Á¸é ¹é¾÷µÈ µ¥ÀÌÅͺ£À̽º°¡ ÀÖ¾î¾ß ÇÑ´Ù. Tibero´Â µ¥ÀÌÅͺ£À̽º¿¡¼ ÀϾ´Â ¸ðµç º¯È¸¦ ·Î±× ÆÄÀÏ¿¡ ±â·ÏÇÑ´Ù. µû¶ó¼ ¹é¾÷ ÀÌÈÄ¿¡ µ¥ÀÌÅͺ£À̽º¿¡ ÀÏ¾î³ ¸ðµç º¯È¿¡ ´ëÇؼ´Â ·Î±×¸¦ Àû¿ëÇÏ¸é º¹±¸ÇÒ ¼ö ÀÖ´Ù. ·Î±× ÆÄÀÏ¿¡´Â Ä¿¹ÔµÇÁö ¾ÊÀº Æ®·£Àè¼ÇÀÌ ¼öÁ¤ÇÑ µ¥ÀÌÅ͵µ Æ÷ÇԵǾî ÀÖ´Ù. º¹±¸ÇÒ ¶§ ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏ°ú ·Î±× ÆÄÀÏ ¸ðµÎ »ç¿ëÇÒ ¼ö ÀÖ´Ù.
º¹±¸ °úÁ¤Àº ´ÙÀ½°ú °°ÀÌ µÎ °¡Áö °æ¿ì·Î ¼öÇàÇÒ ¼ö ÀÖ´Ù.
µ¥ÀÌÅÍ ÆÄÀÏ¿¡ ±â·ÏµÇÁö ¾Ê´Â º¯È¸¦ ·Î±×¸¦ »ç¿ëÇÏ¿© Àû¿ëÇÏ´Â °úÁ¤
µ¥ÀÌÅÍ ÆÄÀÏ¿¡ ¸ðµç ·Î±×ÀÇ º¯È¸¦ ±â·ÏÇÏ´Â °úÁ¤À» ÅëÇؼ µ¥ÀÌÅͺ£À̽º´Â ¾ÈÁ¤µÈ »óÅ°¡ µÈ´Ù. Áï, µ¥ÀÌÅͺ£À̽º ¿î¿µ»óÀÇ Æ¯Á¤ ½ÃÁ¡±îÁö ¸ðµç ÀÛ¾÷ÀÌ ¹Ý¿µµÇ°í ±× ÀÌÈÄÀÇ º¯È´Â ¹ß»ýÇÏÁö ¾Ê¾Æ¾ß ÇÑ´Ù.
µ¥ÀÌÅͺ£À̽º¿¡ Á¤»óÀûÀÎ º¹±¸°¡ ÀÌ·ç¾îÁ® ¾ÈÁ¤µÈ »óÅ°¡ µÇ¾î¾ß¸¸ ±âµ¿ÇÒ ¼ö ÀÖ´Ù.
Ä¿¹ÔµÇÁö ¾Ê´Â µ¥ÀÌÅÍ·Î º¹±¸ÇÏ´Â °úÁ¤
µ¥ÀÌÅͺ£À̽º¸¦ Á¾·áÇÒ ¶§ Ä¿¹ÔÇÏÁö ¾ÊÀº Æ®·£Àè¼ÇÀÌ ¼öÁ¤ÇÑ ³»¿ëÀ¸·Î º¹±¸ÇÏ´Â °úÁ¤ÀÌ´Ù.
Tibero´Â ºÎÆ® ¸ðµåº°·Î ¹ß»ýµÇ´Â ÀÛ¾÷À» º¹±¸ Ãø¸é¿¡¼ º¸¸é ´ÙÀ½°ú °°´Ù.
NOMOUNT ¸ðµå·Î´Â ¾ðÁ¦³ª º¹±¸ÇÒ ¼ö ÀÖ´Ù. ÀÌ ¸ðµå¿¡¼´Â µ¥ÀÌÅͺ£À̽º¿Í ÄÁÆ®·Ñ ÆÄÀÏÀ» »ý¼ºÇÒ ¼ö ÀÖ´Ù. MOUNT ¸ðµå·Î µ¿ÀÛÇϱâ À§Çؼ´Â ÄÁÆ®·Ñ ÆÄÀÏÀÌ ÀÖ¾î¾ß ÇÑ´Ù. ÄÁÆ®·Ñ ÆÄÀÏÀÌ ¾ø°Å³ª ÄÁÆ®·Ñ ÆÄÀÏ¿¡ Àå¾Ö°¡ ¹ß»ýÇÑ °æ¿ì¿¡´Â NOMOUNT ¸ðµå·Î µ¿ÀÛÇϸç ÄÁÆ®·Ñ ÆÄÀÏÀ» »ý¼ºÇϸé MOUNT ¸ðµå·Î µ¿ÀÛÇÒ ¼ö ÀÖ´Ù.
MOUNT ¸ðµå¿¡¼´Â µ¥ÀÌÅÍ ÆÄÀÏ, ¿Â¶óÀÎ ·Î±× ÆÄÀÏ, ÄÁÆ®·Ñ ÆÄÀÏ »çÀÌÀÇ »óŸ¦ °Ë»çÇÏ¿© Tibero¸¦ ±âµ¿ÇÒ Áغñ¸¦ ÇÑ´Ù. ¼¼ ÆÄÀÏÀÌ ¸ðµÎ ÃֽŠ»óÅÂÀ̸é OPEN ¸ðµå·Î µ¿ÀÛÇÒ ¼ö ÀÖ´Ù. ÆÄÀÏ¿¡ ¹°¸®ÀûÀÎ Àå¾Ö°¡ ¹ß»ýÇÏ¿´°Å³ª, º¹¿øµÈ ÆÄÀÏÀ̶ó¸é ¹Ìµð¾î º¹±¸°¡ ÇÊ¿äÇϸç MOUNT ¸ðµå·Î µ¿ÀÛÇÑ´Ù. MOUNT ¸ðµå¿¡¼´Â Á¦ÇÑµÈ ºäÀÇ Á¶È¸°¡ °¡´ÉÇÏ°í, ¹Ìµð¾î º¹±¸¸¦ ¼öÇàÇÒ ¼ö ÀÖ´Ù.
TiberoÀÇ µ¥ÀÌÅÍ ÆÄÀÏ, ¿Â¶óÀÎ ·Î±× ÆÄÀÏ, ÄÁÆ®·Ñ ÆÄÀÏÀÌ ÀÏ°ü¼ºÀ» À¯ÁöÇÒ ¶§¿¡¸¸ OPEN ¸ðµå·Î µ¿ÀÛÇÒ ¼ö ÀÖ´Ù. OPEN ¸ðµå¿¡¼ Tibero´Â ¼¼ ÆÄÀÏÀ» ¿°í Á¤»óÀ¸·Î µ¿ÀÛÇÑ´Ù. ÀÏ¹Ý »ç¿ëÀÚ´Â µ¥ÀÌÅͺ£À̽º¸¦ ÀÌ¿ëÇÒ ¼ö ÀÖ´Ù.
¿ÀÇÁ¶óÀÎ »óÅÂÀÎ Å×ÀÌºí ½ºÆäÀ̽º¿¡ »ç¿ëÀÚ°¡ Á¢±ÙÇÏ·Á¸é ¿ì¼± ÇØ´ç Å×ÀÌºí ½ºÆäÀ̽º¸¦ ¿Â¶óÀÎ »óÅ·ΠÀüȯÇØ¾ß ÇÑ´Ù. À̶§ ´Ù¸¥ ÆÄÀϵé°ú ÀÏ°ü¼ºÀ» À¯ÁöÇϱâ À§ÇØ ÇØ´ç Å×ÀÌºí ½ºÆäÀ̽º¿¡ ¿Â¶óÀÎ ¹Ìµð¾î º¹±¸¸¦ ¼öÇàÇØ¾ß ÇÑ´Ù.
ÆÄ¼Õ º¹±¸(Crash Recovery)´Â Tibero¸¦ ¿î¿µÇÏ´Â Áß¿¡ Á¤Àü, ½Ã½ºÅÛ ÀÌ»ó, °Á¦ Á¾·á µîÀ¸·Î µ¥ÀÌÅͺ£À̽º°¡ ºñÁ¤»óÀûÀ¸·Î Á¾·áµÇ¾úÀ» ¶§ »ç¿ëÀÚÀÇ ¸í·É ¾øÀÌ ÀÚµ¿À¸·Î º¹±¸µÇ´Â °ÍÀ» ÀǹÌÇÑ´Ù. º¹±¸°¡ ¿Ï·áµÇ¸é Tibero°¡ Á¤»óÀûÀ¸·Î µ¿ÀÛÇÑ´Ù.
ÆÄ¼Õ º¹±¸´Â ¿Â¶óÀÎ ·Î±× ÆÄÀÏÀÇ ³»¿ë Áß ¾ÆÁ÷ µ¥ÀÌÅÍ ÆÄÀÏ¿¡ ¹Ý¿µµÇÁö ¾ÊÀº ºÎºÐÀ» ±â·ÏÇÏ¿© Tibero°¡ ºñÁ¤»óÀûÀ¸·Î Á¾·áµÇ±â Á÷Àü¿¡ ¿î¿µ ½ÃÁ¡ÀÇ »óÅ·Πº¹±¸ÇÏ´Â °úÁ¤°ú ÀÌ·¯ÇÑ »óÅ·Πº¹±¸µÈ ½ÃÁ¡¿¡¼ Ä¿¹ÔµÇÁö ¾ÊÀº Æ®·£Àè¼ÇÀÌ ¹ß»ý½ÃŲ º¯È¸¦ µÇµ¹¸®´Â °úÁ¤À¸·Î ³ª´ ¼ö ÀÖ´Ù.
ÆÄ¼Õ º¹±¸ÀÇ ¸ðµç °úÁ¤Àº ÆÄÀÏÀÇ ¼Õ»óÀÌ ¾øÀ¸¸é DBAÀÇ µµ¿ò ¾øÀÌ ÀÚµ¿À¸·Î ÀÌ·ç¾îÁø´Ù.
Tibero´Â Æò±Õ ÆÄ¼Õ º¹±¸ ½Ã°£À» ¼³Á¤ ÇÒ¼ö ÀÖ´Â ±â´É(Mean Crash Recovery Time)À» Á¦°øÇÏ°í ÀÖ´Ù. Mean Crash Recovery Time(ÀÌÇÏ MCRT)Àº ÆÄ¼Õ º¹±¸½Ã ÇÊ¿äÇÑ I/O Ƚ¼ö¸¦ ÅëÁ¦ÇÔÀ¸·Î½á Æò±Õ ÆÄ¼Õ º¹±¸ ½Ã°£À» Á¶ÀýÇÑ´Ù.
MCRT´Â ´ÙÀ½ ÆĶó¹ÌÅ͸¦ ¼³Á¤Çؼ Á¶ÀýÇÒ ¼ö ÀÖ´Ù.
ÆĶó¹ÌÅÍ ¼³¸í _MCRT_TARGET Æò±Õ ÆÄ¼Õ º¹±¸ ½Ã°£À» ¼³Á¤ÇÑ´Ù. (±âº»°ª: 1800, ´ÜÀ§: ÃÊ)
Tibero¸¦ ±¸¼ºÇÏ´Â ÆÄÀÏÀÌ ¹°¸®ÀûÀÎ ¼Õ»óÀ̳ª Á¤»óÀûÀ¸·Î µ¿ÀÛÇÒ ¼ö ¾ø´Â °æ¿ì°¡ ¹ß»ýÇÒ ¼ö ÀÖ´Ù. ÀÌ·¯ÇÑ °æ¿ì µ¥ÀÌÅͺ£À̽º°¡ Á¤»óÀûÀ¸·Î µ¿ÀÛÇÒ ¼ö ÀÖµµ·Ï º¹±¸ÇÏ´Â °úÁ¤ÀÌ ¹Ìµð¾î º¹±¸(Media Recovery)ÀÌ´Ù.
¹Ìµð¾î º¹±¸ °úÁ¤Àº ÀÚµ¿À¸·Î ÀÌ·ç¾îÁöÁö ¾Ê´Â´Ù. DBA°¡ »óȲÀ» ÆľÇÇؼ ÇÊ¿äÇÑ °úÁ¤À» Áö½ÃÇÏ´Â ÀÏ·ÃÀÇ ÀÛ¾÷ÀÌ ÇÊ¿äÇÏ´Ù. º¹±¸ ¿Ï·á½ÃÁ¡À» ¿À·ù°¡ ¹ß»ýÇϱâ ÀÌÀüÀÇ °¡Àå ÃÖ±Ù ½ÃÁ¡±îÁö·Î ÇÒÁö, °ú°ÅÀÇ Æ¯Á¤ ½ÃÁ¡±îÁö·Î ÇÒÁö ¿©ºÎ¿¡ µû¶ó¼ ¿ÏÀü º¹±¸(Complete Recovery)¿Í ºÒ¿ÏÀü º¹±¸(Incomplete Recovery)·Î ±¸ºÐµÈ´Ù.
¿ÏÀü º¹±¸
¿Â¶óÀÎ ·Î±× ÆÄÀÏÀÇ °¡Àå ÃÖ±Ù ·Î±×±îÁö ¸ðµÎ ¹Ý¿µÇÏ´Â ¹Ìµð¾î º¹±¸ÀÌ´Ù.
ºÒ¿ÏÀü º¹±¸
¿Â¶óÀÎ ·Î±× ÆÄÀÏÀÇ ÃÖ±Ù±îÁö°¡ ¾Æ´Ñ ±× ÀÌÀüÀÇ Æ¯Á¤ ½ÃÁ¡±îÁö º¹±¸ÇÏ´Â °ÍÀ» ¸»ÇÑ´Ù. ºÒ¿ÏÀü º¹±¸ ÈÄ¿¡´Â ¹Ýµå½Ã RESETLOGS ¸ðµå·Î Tibero¸¦ ±âµ¿ÇØ¾ß ÇÑ´Ù. RESETLOGS´Â ¿Â¶óÀÎ ·Î±× ÆÄÀÏÀ» ÃʱâÈÇÏ´Â °ÍÀ̸ç, ÇöÀç ¿Â¶óÀÎ ·Î±× ÆÄÀÏ·Î µ¥ÀÌÅͺ£À̽º¸¦ ½ÃÀÛÇÏÁö ¾ÊÀ» ¶§ »ç¿ëÇÑ´Ù.
RESETLOGS°¡ ÇÊ¿äÇÑ °æ¿ì´Â ´ÙÀ½°ú °°´Ù.
ºÒ¿ÏÀü ¹Ìµð¾î º¹±¸¸¦ ÇÑ °æ¿ì
RESETLOGS·Î ÄÁÆ®·Ñ ÆÄÀÏÀ» »ý¼ºÇÑ °æ¿ì
RESETLOGS·Î ½ÃÀÛÇÏ¸é »õ·Î¿î µ¥ÀÌÅͺ£À̽º°¡ ¸¸µé¾îÁø °Í°ú °°´Ù. RESETLOGS ÀÌÀüÀÇ µ¥ÀÌÅÍ ÆÄÀÏ, ·Î±× ÆÄÀÏ°ú RESETLOGS ÀÌÈÄÀÇ ÆÄÀÏÀº ¼·Î ȣȯµÇÁö ¾Ê´Â´Ù. RESETLOGS ÀÌÀüÀÇ ¹é¾÷ ÆÄÀÏÀ̳ª ·Î±× ÆÄÀÏÀ» ÀÌ¿ëÇÏ¿© RESETLOGS ÀÌÈÄ·Î º¹±¸ÇÒ ¼ö ¾ø´Ù. ¶ÇÇÑ RESETLOGS ÀÌÈÄÀÇ ÆÄÀÏÀ» RESETLOGS ÀÌÀü »óÅ·ΠºÒ¿ÏÀü º¹±¸¸¦ ÇÏ´Â °Íµµ ºÒ°¡´ÉÇÏ´Ù. µû¶ó¼ RESETLOGS ¸ðµå·Î ±âµ¿ÇÑ °æ¿ì¿¡´Â ¹Ýµå½Ã »õ·Î ¹é¾÷À» Çϱ⸦ ±ÇÀåÇÑ´Ù.
RESETLOGS·Î µ¥ÀÌÅͺ£À̽º¸¦ ±âµ¿ÇÏ´Â ¹æ¹ýÀº ´ÙÀ½°ú °°´Ù.
¹Ìµð¾î º¹±¸ °úÁ¤Àº MOUNT ¸ðµå¿¡¼¸¸ ÀÌ·ç¾îÁø´Ù. ¹é¾÷µÈ ÆÄÀÏÀ» »ç¿ëÇÏ¿© ¿À·ù°¡ ¹ß»ýÇÑ ÆÄÀÏÀ» º¹¿øÇÏ´Â °úÁ¤°ú º¹¿øµÈ ÆÄÀÏÀ» ¹é¾÷ÇÑ ½ÃÁ¡À¸·ÎºÎÅÍ ÃÖ±Ù ¶Ç´Â ƯÁ¤ ½ÃÁ¡±îÁö ¹Ý¿µµÇÁö ¾ÊÀº º¯È¸¦ ·Î±× ÆÄÀÏÀ» »ç¿ëÇÏ¿© º¹±¸ÇÏ´Â °úÁ¤À¸·Î ³ª´ ¼ö ÀÖ´Ù. ´Ü¼øÇÑ º¹¿ø °úÁ¤¸¸À¸·Î´Â TiberoÀÇ Á¤»óÀûÀÎ ¿î¿µÀÌ ºÒ°¡´ÉÇÏ´Ù.
¹Ìµð¾î º¹±¸¸¦ À§ÇØ Àå¾Ö°¡ ¹ß»ýÇÑ ÆÄÀÏÀ» ã¾Æ º¹±¸ÇØ¾ß ÇÑ´Ù. À̸¦ À§ÇØ ´ÙÀ½°ú °°Àº ºä¸¦ Á¦°øÇÑ´Ù.
V$LOGFILE
V$CONTROLFILE
V$LOG
V$RECOVER_FILE
V$RECOVERY_FILE_STATUS
¹Ìµð¾î º¹±¸´Â ·Î±× ÆÄÀÏÀ» Çϳª¾¿ µ¥ÀÌÅͺ£À̽º¿¡ ¼ø¼´ë·Î ¹Ý¿µÇÏ¿© ÁøÇàÇÑ´Ù. µ¥ÀÌÅͺ£À̽º´Â ÇöÀç º¹±¸¿¡ ÇÊ¿äÇÑ ·Î±× ÆÄÀϸ¸À» ¹Ý¿µÇÒ ¼ö ÀÖ´Ù. ÇöÀç ÇÊ¿äÇÑ ·Î±× ÆÄÀÏÀ» ã±â À§ÇØ ½ÃÄö½º ¹øÈ£°¡ »ç¿ëµÈ´Ù. ½ÃÄö½º ¹øÈ£´Â µ¥ÀÌÅͺ£À̽º°¡ »ý¼ºµÈ ÀÌÈÄ·Î ¸¸µé¾îÁø ·Î±× ÆÄÀÏÀÇ ÀÏ·Ã ¹øÈ£À̸ç, ¸ðµç ·Î±× ÆÄÀÏÀº ÇϳªÀÇ À¯ÀÏÇÑ ½ÃÄö½º ¹øÈ£¸¦ °®´Â´Ù. ½ÃÄö½º ¹øÈ£°¡ Å« ·Î±× ÆÄÀÏÀÌ ÃÖ±Ù ·Î±× ÆÄÀÏÀÌ´Ù. ½ÃÄö½º ¹øÈ£´Â ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏÀÇ °æ¿ì ÆÄÀÏ À̸§À» ÅëÇØ ¾Ë ¼ö ÀÖ°í, ¿Â¶óÀÎ ·Î±× ÆÄÀÏÀÇ °æ¿ì V$LOG ºä¸¦ ÅëÇØ ¾Ë ¼ö ÀÖ´Ù.
Tibero¸¦ ¿î¿µÇÏ´Â µµÁß¿¡ ÀϺΠµ¥ÀÌÅÍ ÆÄÀÏÀÌ ¹°¸®ÀûÀ¸·Î ¼Õ»óµÇ°Å³ª Á¤»óÀûÀ¸·Î µ¿ÀÛÇÒ ¼ö ¾ø´Â °æ¿ì°¡ ¹ß»ýÇÒ ¼ö ÀÖ´Ù. ÀÌ·¯ÇÑ °æ¿ì¿¡ OPEN ¸ðµå¿¡¼ ÇØ´ç µ¥ÀÌÅÍ ÆÄÀÏÀÌ Æ÷ÇÔµÈ Å×ÀÌºí ½ºÆäÀ̽º¸¸ ¹Ìµð¾î º¹±¸¸¦ ¼öÇàÇÒ ¼ö ÀÖ´Ù. ÀÌ°ÍÀÌ ¿Â¶óÀÎ ¹Ìµð¾î º¹±¸(Online Media Recovery)ÀÌ´Ù. ¿Â¶óÀÎ ¹Ìµð¾î º¹±¸´Â ¿ÏÀü º¹±¸¸¸ °¡´ÉÇÏ´Ù.
Tibero´Â ´Ù¾çÇÑ ¹é¾÷ ¹× º¹±¸ ½Ã³ª¸®¿À¸¦ Á¦°øÇÑ´Ù. ¼÷·ÃµÈ µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ¶ó¸é »óȲ¿¡ ¸Â´Â ÀûÀýÇÑ ¹æ¹ýÀ» ¼±ÅÃÇÏ°í È°¿ëÇÒ ¼ö ÀÖÀ» °ÍÀÌ´Ù. Ç㳪 ³Ê¹« ´Ù¾çÇÑ ±â´ÉÀ» Á¦°øÇÔÀ¸·Î½á ¿ÀÈ÷·Á »ç¿ëÀÚ¿¡°Ô È¥¶õÀ» ÁÙ ¼öµµ ÀÖ´Ù. ÀÌ·¯ÇÑ ¸éÀ» º¸¿ÏÇϱâ À§ÇÏ¿© Tibero´Â º¹±¸ °ü¸®ÀÚ(ÀÌÇÏ RMGR)¸¦ Á¦°øÇÑ´Ù.
RMGRÀº ´Ù¾çÇÑ ¹é¾÷/º¹±¸ ½Ã³ª¸®¿À¸¦ Áö¿øÇϵµ·Ï ±¸¼ºµÇ¾î ÀÖ´Ù. Tibero¿¡¼ Á¦°øµÇ´Â RMGRÀÇ ±â´ÉÀº ´ÙÀ½°ú °°´Ù.
Tibero µ¥ÀÌÅͺ£À̽º¿¡ ¼ÓÇÑ Àüü µ¥ÀÌÅÍ ÆÄÀÏÀ» ¿Â¶óÀÎ ¹é¾÷ÇÑ´Ù. ¿Â¶óÀÎ ¹é¾÷À» À§Çؼ´Â µ¥ÀÌÅͺ£À̽º°¡ ARCHIVELOG ¸ðµåÀÌ¿©¾ß ÇÑ´Ù. RMGRÀº ÀÚµ¿À¸·Î µ¥ÀÌÅͺ£À̽ºÀÇ Begin Backup ±â´ÉÀ» »ç¿ëÇÏ¿© ¸ðµç Å×ÀÌºí ½ºÆäÀ̽º¸¦ Hot Backup »óÅ·Π¸¸µé°í ¹é¾÷À» ÁøÇàÇÑ´Ù.
¹é¾÷À» ¿Ï·áÇÏ¸é µ¥ÀÌÅͺ£À̽ºÀÇ End Backup ±â´ÉÀ» »ç¿ëÇÏ¿© ¸ðµç Å×ÀÌºí ½ºÆäÀ̽º¸¦ Hot Backup »óÅ·κÎÅÍ ÇØÁ¦ÇÑ´Ù. ¹é¾÷ÇÒ µ¥ÀÌÅÍ ÆÄÀÏ ¿ª½Ã V$DATAFILEÀ» Á¶È¸ÇÏ¿© ÀÚµ¿À¸·Î °áÁ¤ÇØ ÁØ´Ù.
RMGR¸¦ ÅëÇØ ¿Â¶óÀÎ ¹é¾÷À» ¹Þ¾ÒÀ¸¸é À̸¦ ÀÌ¿ëÇÏ¿© Incremental BackupÀ» ÇÒ ¼ö ÀÖ´Ù. Incremental BackupÀ̶õ ¹é¾÷À» ¹ÞÀ» ¶§ Àüü ÆÄÀÏÀ» ¹Þ´Â °ÍÀÌ ¾Æ´Ï¶ó ÀÌÀü ¹é¾÷°úÀÇ Â÷À̸¸À» ±â·ÏÇÏ´Â ¹æ½ÄÀ¸·Î ¹é¾÷¿¡ ¼Ò¸ðµÇ´Â µð½ºÅ© °ø°£À» ȹ±âÀûÀ¸·Î ÁÙÀÏ ¼ö ÀÖ´Ù.
Incremental BackupÀ» ÇÏ·Á¸é ÀÌÀü¿¡ RMGR¸¦ ÅëÇØ Online Full BackupÀ» ¹Þ¾Ò¾î¾ß ÇÑ´Ù. ÇöÀç µ¥ÀÌÅͺ£À̽º¿Í ¹é¾÷º»°úÀÇ Â÷À̸¦ ±¸ÇÏ¿© ¹é¾÷ ÆÄÀÏÀ» ¸¸µç´Ù. ÀÌ·¯ÇÑ ±â´ÉÀº RMGR¸¦ ÅëÇؼ¸¸ »ç¿ëÇÒ ¼ö ÀÖ´Ù.
RMGRÀ» ÀÌ¿ëÇÏ¿© ¸¸µé¾îÁø ¹é¾÷º»À» ÀÌ¿ëÇÏ¿© ÀÚµ¿ Recovery¸¦ ÁøÇàÇÑ´Ù. Backup Á¤º¸´Â Controlfile¿¡ ÀúÀåÀÌ µÇ¾îÀÖ´Ù. Controlfile¿¡ ÀúÀåµÈ Á¤º¸¸¦ ±â¹ÝÀ¸·Î Online Full Backup/Incremental Backup Á¤º¸¸¦ ºÐ¼®ÇÏ¿© ÀÚµ¿À¸·Î Merge ÈÄ RecoveryÇØÁØ´Ù. ControlfileÀÌ Á¢±Ù ºÒ°¡´ÉÇÒ¶§¿¡´Â ¹é¾÷µÈ ControlfileÀ» ÀÌ¿ëÇÏ¿© º¹±¸¸¦ ÁøÇàÇÑ´Ù. ´Ü, À̶§¿¡´Â ¹é¾÷ÀÌ Á¸ÀçÇÏ´Â Backup Dest(-o ¿É¼Ç)¸¦ ¸í½ÃÇØÁÖ¾î¾ß ÇÑ´Ù.
ÁÖÀÇ
TAC ȯ°æ¿¡¼ RMGRÀ» ÀÌ¿ëÇÑ º¹±¸¸¦ ÁøÇàÇϱâ À§Çؼ´Â ±¸¼º ³ëµå Áß ÇÑ °³ÀÇ ³ëµå¸¸ ¶°ÀÖ´Â »óȲ¿¡¼ º¹±¸¸¦ ÁøÇàÇØ¾ß ÇÑ´Ù.
Àüü µ¥ÀÌÅͺ£À̽º¸¦ ¹é¾÷/º¹±¸ÇÏ´Â ´ë½Å¿¡ ÇÊ¿äÇÑ Å×ÀÌºí ½ºÆäÀ̽º¸¸ ´ë»óÀ¸·Î ¹é¾÷/º¹±¸ ÀÛ¾÷À» ¼öÇàÇÒ ¼ö ÀÖ´Ù.
RMGRÀ» ÀÌ¿ëÇÏ¿© Controlfile¿¡ µî·ÏµÈ Backup SetÀ» »èÁ¦ÇÒ ¼ö ÀÖ´Ù. »èÁ¦ ´ë»óÀÌ µÇ´Â Target Backup SetÀº Backup Set ID(--backup_set ¿É¼Ç)¸¦ ¸í½ÃÇÔÀ¸·Î½á ÁöÁ¤ÇÒ ¼ö ÀÖÀ¸¸ç, Backup Date(--beforetime ¿É¼Ç)¸¦ ¸í½ÃÇÏ´Â °æ¿ì¿¡´Â Backup Date ÀÌÀü¿¡ BackupÀÌ ÀÌ·ç¾îÁø ¸ðµç Backup SetµéÀ» »èÁ¦ ´ë»óÀ¸·Î ÁöÁ¤ÇÒ ¼ö ÀÖ´Ù. Backup Date´Â YYYYMMDDHH(24)mmss ÇüÅ·Π¸í½ÃÇÑ´Ù.
»èÁ¦ÇÏ°íÀÚ ÇÏ´Â Backup SetÀÌ Á¸ÀçÇÏ´Â ¹é¾÷ °æ·Î´Â ControlfileÀ» ÂüÁ¶ÇÏ¿© °áÁ¤ÇϹǷÎ, BackupÀÌ ÀÌ·ç¾îÁø ÀÌÈÄ¿¡ ¹é¾÷ °æ·Î°¡ º¯°æµÈ °æ¿ì¿¡´Â »èÁ¦ÇÏ°íÀÚ ÇÏ´Â Backup SetÀÌ Á¸ÀçÇÏ´Â Backup Dest(-o ¿É¼Ç)¸¦ ¸í½ÃÇØÁÖ¾î¾ß ÇÑ´Ù. ¸¸¾à Controlfile¿¡ µî·ÏµÈ Backup SetÀ» »ç¿ëÀÚ°¡ ¼öµ¿À¸·Î »èÁ¦ÇÏ¿´°Å³ª, À߸øµÈ ¹é¾÷ °æ·Î¸¦ ¸í½ÃÇÏ¿© ¹é¾÷ °æ·Î¿¡¼ »èÁ¦ ´ë»óÀ¸·Î ÁöÁ¤µÈ Backup SetÀ» ãÀ» ¼ö ¾ø´Â °æ¿ì¿¡´Â Controlifle¿¡ µî·ÏµÈ Backup Set Entry¸¸À» »èÁ¦ÇÏ°í Á¾·áÇÏ°Ô µÈ´Ù.
RMGRÀº ¼Ð ¸í·ÉÀ¸·Î ½ÇÇàµÇ¸ç ´Ù¾çÇÑ ¿É¼ÇÀ» ÁöÁ¤ÇÏ¿© ¿øÇÏ´Â ±â´ÉÀ» »ç¿ëÇÒ ¼ö ÀÖ´Ù.
¿É¼Ç | ¼³¸í |
---|---|
backup | RMGR¸¦ ÅëÇØ ¹é¾÷À» ÁøÇàÇÑ´Ù. |
recover | RMGR·Î ¹Þ¾Æ³õÀº ¹é¾÷º»À» ÀÌ¿ëÇÏ¿© º¹±¸¸¦ ÁøÇàÇÑ´Ù. |
delete | RMGR·Î ¹Þ¾Æ³õÀº ¹é¾÷º» Áß »ç¿ëÀÚ ÀÔ·ÂÀ¸·Î ÁÖ¾îÁø Á¶°Ç¿¡ ¸Â´Â ¹é¾÷º»À» »èÁ¦ÇÑ´Ù. |
--userid | µ¥ÀÌÅͺ£À̽º¿¡ Á¢¼ÓÇÒ »ç¿ëÀÚ¸í°ú Æнº¿öµå ¹× SID¸¦ ¾Æ·¡¿Í °°Àº Çü½ÄÀ¸·Î ÁöÁ¤ÇÑ´Ù. --userid USERID[[/PASSWD][@SID]] ȸé»ó¿¡ ºñ¹Ð¹øÈ£ ³ëÃâÀ» ¿øÄ¡ ¾ÊÀ» ¶§¿¡´Â ºñ¹Ð¹øÈ£¸¦ °ø¹éÀ¸·Î ÀÔ·ÂÇÑ ÈÄ, ºñ¹Ð¹øÈ£¸¦ ÀÔ·ÂÇ϶ó´Â ¹®±¸°¡ ³ª¿À¸é ºñ°ø°³·Î ¹øÈ£¸¦ ÀÔ·ÂÇÒ ¼ö ÀÖ´Ù. --userid USERID/[@SID] OS ÀÎÁõÀ» ¹ÞÀº °èÁ¤À¸·Î ·Î±×ÀÎÇÏ´Â °æ¿ì Userid¿Í Passwd¸¦ ÀÔ·ÂÇÏÁö ¾Ê¾Æµµ ·Î±×ÀÎ °¡´ÉÇÏ´Ù(´Ü, ÇöÀç´Â backup°ú delete ±â´É¸¸ °¡´É). --userid / |
-v, --verbose | RMGRÀÇ ÁøÇà»óȲÀ» ÀÚ¼¼ÇÏ°Ô Ãâ·ÂÇÑ´Ù. |
-s, --silent | RMGRÀÇ ÁøÇà»óȲÀ» ÃÖ¼Ò·Î Ãâ·ÂÇÑ´Ù. |
-h, --help | RMGRÀÇ ¿É¼Ç »ç¿ë¹ýÀ» Ãâ·ÂÇÑ´Ù. |
-i, --incremental | °¡Àå ÃֽŠ¹é¾÷¿¡ ´ëÇÑ Incremental backupÀ» ¼öÇàÇÑ´Ù. |
-C, --cumulative | ¸¶Áö¸· full backup¿¡ ´ëÇÑ incremental backupÀ» ¼öÇàÇÑ´Ù. |
-c, --compress | ¹é¾÷À» ¼öÇàÇÒ ¶§ µ¥ÀÌÅ͸¦ ¾ÐÃàÇÏ¿© ÀúÀåÇÑ´Ù. º¸Åë ¹é¾÷¿¡ ¼Ò¿äµÇ´Â ½Ã°£Àº ´Ã¾î³ª°í »ý¼ºµÇ´Â ÆÄÀÏ Å©±â´Â ÁÙ¾îµç´Ù. |
-u, --skip-unused | ¹é¾÷À» ¼öÇàÇÒ ¶§ ½ÇÁ¦·Î »ç¿ëµÇÁö ¾ÊÀº ºí·ÏÀº ¹é¾÷ ÆÄÀÏ¿¡ ¾²Áö ¾Ê´Â´Ù. ¹é¾÷ ÈÄ »ý¼ºµÇ´Â ÆÄÀÏ Å©±â¸¦ ÁÙÀÏ ¼ö ÀÖ´Ù. |
-o | ¹é¾÷¹ÞÀ»/¹é¾÷¹ÞÀº µð·ºÅ͸®¸¦ ÁöÁ¤ÇÑ´Ù. ¹é¾÷ÇÒ ¶§ ¿É¼ÇÀ» ÁÖÁö ¾ÊÀ» °æ¿ì RMGR_BACKUP_DEST°¡ ±âº» dest·Î ¼³Á¤µÈ´Ù. º¹±¸ÇÒ °æ¿ì ¿É¼ÇÀ» ÁÖÁö ¾ÊÀ¸¸é ¹é¾÷µÈ µð·ºÅ͸®¸¦ ÀÚµ¿À¸·Î ã¾Æ°£´Ù. ¿É¼ÇÀ» ÁÙ °æ¿ì ¸ðµç full/incremental backupÀÌ ÇØ´ç µð·ºÅ͸®¿¡ ÀÖ¾î¾ß ÇÑ´Ù. |
--with-archivelog | ¹é¾÷/º¹±¸¸¦ ¼öÇàÇÒ ¶§ hot backupÀ» º¹±¸Çϱâ À§ÇÑ ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀϵµ ÇÔ²² ¹é¾÷/º¹¿øÇÑ´Ù. tbrmgr backup --with-archivelog ±âº»ÀûÀ¸·Î Ŭ·¯½ºÅÍ È¯°æ¿¡¼´Â Áö¿øµÇÁö ¾ÊÀ¸¸ç, ¿¹¿ÜÀûÀ¸·Î TAC-TAS ±¸¼ºÈ¯°æ¿¡¼ ¸ðµç instance°¡ active stroage »óÀÇ µ¿ÀÏÇÑ LOG_ARCHIVE_DEST¸¦ °øÀ¯ÇÏ´Â °æ¿ì¿¡ ÇÑÇÏ¿© Áö¿øµÈ´Ù. ¹é¾÷µÈ ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏÀº ´ÙÀ½ÀÇ Çü½ÄÀ¸·Î °ü¸®µÈ´Ù. bkl_<BACKUPSET#>_t<THREAD#>-r<RESETLOGS TSN>-s<SEQUENCE#>.arc ¿¹¸¦ µé¾î BACKUPSET#´Â 1, THREAD#´Â 0, RESETLOGS TSN´Â 0, SEQEUNCE#´Â 1ÀÎ °æ¿ì ÆÄÀϸíÀº 'bkl_1_t0-r0-s1.arc'ÀÌ µÈ´Ù. |
--for-standby | standby ±¸ÃàÀ» À§ÇÑ ¹é¾÷ ¹× º¹±¸¸¦ ÁøÇàÇÑ´Ù. cluster ȯ°æ¿¡¼´Â ¾ÆÄ«ÀÌºê ·Î±× ¹é¾÷À» Áö¿øÇÏÁö ¾Ê±â ¶§¹®¿¡, ¾ÆÄ«ÀÌºê ·Î±×´Â Á÷Á¢ ¹é¾÷/º¹¿øÇØ¾ß ÇÑ´Ù |
--clone | µ¥ÀÌÅÍ ÆÄÀÏ ¹é¾÷ ÀÌÈÄ ¿Â¶óÀÎ Redo ·Î±× ¹é¾÷µµ ¼öÇàÇÑ´Ù(DB Ŭ·Î´×¿¡ »ç¿ë). Ŭ·Ð DB ±¸ÃàÀ» À§Çؼ´Â ¼öµ¿À¸·Î ·Î±× ÆÄÀÏÀ» DB µð·ºÅ͸®¿¡ ¿Å±ä ÈÄ º¹±¸¸¦ ¼öÇàÇÑ´Ù. |
--before-time | ¹é¾÷À» »èÁ¦ÇÒ ¶§ ¸í½ÃµÈ ½ÃÁ¡ ÀÌÀüÀÇ ¹é¾÷µéÀ» »èÁ¦ÇÑ´Ù. ½Ã°£Àº YYYYMMDDHHMMSSÀÇ Çü½ÄÀÌ´Ù. tbrmgr delete --before-time 20130614165736 |
--backup_set | ¹é¾÷À» »èÁ¦ÇÒ ¶§ ¸í½ÃµÈ Backup Setµµ »èÁ¦ÇÑ´Ù. tbrmgr delete --backup_set 1 |
--untiltime | ½Ã°£±â¹Ý ºÒ¿ÏÀü º¹±¸¸¦ ¼öÇàÇÑ´Ù. ¿É¼Ç¿¡¼ ÁöÁ¤ÇÑ ½Ã°£±îÁö º¯°æµÈ ³»¿ë¸¸ º¹±¸µÈ´Ù. ½Ã°£Àº YYYYMMDDHHMMSSÀÇ Çü½ÄÀÌ´Ù. tbrmgr recover --untiltime 20130614165736 |
--untilchange | º¯°æ ±â¹Ý ºÒ¿ÏÀü º¹±¸¸¦ ¼öÇàÇÑ´Ù. ¿É¼Ç¿¡¼ ÁöÁ¤ÇÑ TSN±îÁö º¯°æµÈ ³»¿ë¸¸ º¹±¸µÈ´Ù. tbrmgr recover --untilchange 16218 |
--tablespace | º¹±¸ ¶Ç´Â ¹é¾÷ÇÒ ´ë»ó Å×ÀÌºí ½ºÆäÀ̽º¸¦ ÁöÁ¤ÇÑ´Ù. Å×ÀÌºí ½ºÆäÀ̽º¸¦ ÁöÁ¤ÇÑ °æ¿ì µ¥ÀÌÅͺ£À̽ºÀÇ ÀϺθ¸ ¹é¾÷/º¹±¸ÇÑ´Ù. tbrmgr backup -o /backup/ --tablespace usr,system |
--with-password-file | µ¥ÀÌÅÍ ÆÄÀÏ(datafile)À» ¹é¾÷/º¹±¸ÇÏ´Â °æ¿ì password fileÀ» ÇÔ²² ¹é¾÷/º¹±¸ÇÑ´Ù. tbrmgr backup --with-password-file |
--wallet | ¾ÏÈ£ÈµÈ Å×ÀÌºí ½ºÆäÀ̽º¿¡ Á¢±ÙÇϱâ À§ÇÑ ÀÎÁõÀÛ¾÷À» ¼öÇàÇÑ´Ù. »ç¿ëÀÚ°¡ ¸í½ÃÇÑ PASSWORD¸¦ ÅëÇØ WALLETÀ» ¿°í º¹±¸¸¦ ½ÃÀÛÇÑ´Ù. tbrmgr recover --wallet PASSWORD |
-p, --parallel THREAD_COUNT | »ç¿ëÀÚ°¡ ¸í½ÃÇÑ THREAD_COUNT¸¸Å ½º·¹µå¸¦ ÇÒ´çÇÏ¿© º´·Ä ¹é¾÷/º¹±¸¸¦ ¼öÇàÇÑ´Ù. tbrmgr backup --parallel THREAD_COUNT |
--recover-to | µ¥ÀÌÅÍ ÆÄÀÏ / ·Î±× ÆÄÀÏÀ» ÇØ´ç µð·ºÅ͸®·Î ¿Å±ä ÈÄ º¹±¸¸¦ ¼öÇàÇÑ´Ù. ¿ÏÀü º¹±¸¸¦ ¿øÇÑ´Ù¸é ¿Â¶óÀÎ ¸®µÎ ·Î±×¸¦ ¸ÕÀú ÇØ´ç µð·ºÅ͸®·Î ¿Å±ä ÈÄ ¼öÇàÇØ¾ß ÇÑ´Ù. TAS ȯ°æ¿¡¼´Â Áö¿øÇÏÁö ¾Ê´Â´Ù. tbrmgr backup --recover-to /tibero_new_directory/ |
º» Àý¿¡¼´Â ´ÙÀ½ÀÇ ¹é¾÷/º¹±¸ ½Ã³ª¸®¿À¸¦ ÅëÇؼ RMGRÀ» ÀÌ¿ëÇÑ ¹é¾÷/º¹±¸¸¦ ¼³¸íÇÑ´Ù.
ÁÖÀÇ
RMGRÀÇ Online (Full / Incremental) BackupÀ» ÅëÇØ »ý¼ºµÈ Backup SetÀ» ÀÌ¿ëÇÏ¿© Recovery¸¦ ¼öÇàÇϱâ À§Çؼ´Â Archive Log FileÀÌ ¹Ýµå½Ã ÇÊ¿äÇÏ´Ù. µû¶ó¼ Archive Log FileÀÌ À¯½ÇµÉ °æ¿ì¿¡ ´ëºñÇÏ¿© Online (Full / Incremental) Backup½Ã Archive Log Fileµµ ÇÔ²² Backup (--with-archivelog ¿É¼Ç) Çصδ °ÍÀÌ ¹Ù¶÷Á÷ÇÏ´Ù. TAC ȯ°æ¿¡¼´Â RMGRÀ» ÀÌ¿ëÇÑ Archive Log BackupÀÌ Áö¿øµÇÁö ¾Ê´Â´Ù.
RMGRÀº ´ëºÎºÐÀÇ °úÁ¤À» ÀÚµ¿À¸·Î ÁøÇàÇϱ⠶§¹®¿¡ »ç¿ëÀÚ°¡ ½ÇÇà ¸í·ÉÀ» ÅëÇØ ÀÛ¾÷À» ¸í½ÃÇØÁØ ÀÌÈÄ¿¡´Â Ưº°È÷ °ü¸®ÇØ¾ß ÇÒ »çÇ×ÀÌ ¾ø´Ù. RMGRÀÌ ÀÛ¾÷À» ÁøÇàÇÏ´Â µ¿¾È¿¡´Â ÀÛ¾÷ÀÇ ÁøÇà °úÁ¤À» »ìÆ캼 ¼ö ÀÖ´Ù.
RMGRÀ» ÅëÇØ BackupÀ» ÁøÇàÇÑ ÀÌÈÄ¿¡´Â V$BACKUP_SETÀ» ÅëÇØ Backup Set Á¤º¸¸¦ Á¶È¸ÇÒ ¼ö ÀÖÀ¸¸ç, V$BACKUP_ARCHIVED_LOG¸¦ ÅëÇØ Archive Log Backup Á¤º¸¸¦ Á¶È¸ÇÒ ¼ö ÀÖ´Ù. V$BACKUP_SET_TABLESPACE¸¦ Á¶È¸ÇÏ¸é °¢ Backup Set¿¡ ´ëÇÑ Tablespace Á¤º¸¸¦ È®ÀÎÇÒ ¼ö ÀÖ´Ù.
Âü°í
µ¥ÀÌÅÍ ÆÄÀÏÀÌ Raw Device ÆÄÀÏ ¹× Tibero Active StorageÀÎ °æ¿ì¿¡µµ RMGRÀ» ÀÌ¿ëÇÑ Backup ¹× Recovery°¡ °¡´ÉÇÏ´Ù. ´Ü, Active Storage¸¦ »ç¿ëÇÒ ¶§ ¹Ì¸® Active Storage Instance¸¦ ¼³Á¤ ¹× ºÎÆÃÀ» ÇÏ¿©¾ß ÇÑ´Ù.
Online Full Backup ½Ã³ª¸®¿À
RMGRÀ» ÀÌ¿ëÇÏ¿© ÀÓÀÇÀÇ ¹é¾÷ °æ·Î¿¡¼ Online Full BackupÀ» ¼öÇàÇÒ ¼ö ÀÖÀ¸¸ç(-o ¿É¼Ç), ¹é¾÷ °æ·Î¸¦ ¸í½ÃÇÏÁö ¾ÊÀº °æ¿ì¿¡´Â RMGR_BACKUP_DEST°¡ ±âº» dest·Î ¼³Á¤µÈ´Ù.
[¿¹ 6.11] Online Full Backup ½Ã³ª¸®¿À
$ tbrmgr backup -o /home/tbrdb/work/6/backup/ ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - ONLINE backup ============================================= DB connected archive log check succeeded 100.00% |=======================================>| 12800/12800 blks 0.08s Synchronizing... 100.00% |=======================================>| 25600/25600 blks 0.18s Synchronizing... 100.00% |=======================================>| 12800/12800 blks 0.10s Synchronizing... 100.00% |=======================================>| 1280/1280 blks 0.02s Synchronizing... Database full backup succeeded DB disconnected RMGR backup ends $ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; SET_ID START_TIME ---------- ---------------------------------------------------------------- FINISH_TIME START_TSN ---------------------------------------------------------------- ---------- FINISH_TSN RESETLOGS_TSN BASE_SET SIZE(KB) IS_PARTIAL IS_INCREMENTAL ---------- ------------- ---------- ---------- ---------- -------------- WITH_ARCHIVELOG --------------- 1 2018/06/11 2018/06/11 36321 36338 0 0 453588 NO NO NO 1 row selected. SQL> select * from V$BACKUP_ARCHIVED_LOG; 0 row selected.
Compress ¿É¼Ç°ú Skip Unused ¿É¼ÇÀ» Àû¿ëÇÑ Online Full Backup ½Ã³ª¸®¿À
µ¥ÀÌÅ͸¦ ¾ÐÃàÇÏ¿© Backup SetÀ» »ý¼ºÇÏ´Â Compress(-c) ¿É¼Ç°ú ½ÇÁ¦·Î »ç¿ëµÇÁö ¾ÊÀº ºí·ÏÀ» ¹é¾÷ ´ë»ó¿¡¼ Á¦¿ÜÇÏ´Â Skip Unused(-u) ¿É¼ÇÀ» ÇÔ²² Àû¿ëÇÏ¿© Online Full BackupÀ» ¼öÇàÇÒ ¼ö ÀÖ´Ù.
[¿¹ 6.12] Compress ¿É¼Ç°ú Skip Unused ¿É¼ÇÀ» Àû¿ëÇÑ Online Full Backup ½Ã³ª¸®¿À
$ tbrmgr backup -c -u -o /home/tbrdb/work/6/backup/ ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - ONLINE backup ============================================= DB connected archive log check succeeded 100.00% |=======================================>| 12800/12800 blks 1.00s Synchronizing... 100.00% |=======================================>| 25600/25600 blks 1.85s Synchronizing... 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... 100.00% |=======================================>| 1280/1280 blks 0.06s Synchronizing... Database full backup succeeded DB disconnected RMGR backup ends
With Archive Log ¿É¼ÇÀ» Àû¿ëÇÑ Online Full Backup ½Ã³ª¸®¿À
RMGRÀ» ÀÌ¿ëÇÑ BackupÀ» ¼öÇàÇÏ´Â °æ¿ì with Archive Log(--with-archivelog) ¿É¼ÇÀ» Àû¿ëÇÔÀ¸·Î½á, ¹é¾÷ °æ·Î¿¡ µ¥ÀÌÅÍ ÆÄÀÏ¿¡ ´ëÇÑ Backup°ú ÇÔ²² Archive Log BackupÀ» »ý¼ºÇÒ ¼ö ÀÖ´Ù. Online BackupÀ» ÀÌ¿ëÇÏ¿© Recovery¸¦ ¼öÇàÇϱâ À§Çؼ´Â Archive Log°¡ ¹Ýµå½Ã ÇÊ¿äÇϹǷÎ, Archive Log BackupÀ» »ý¼ºÇÔÀ¸·Î½á ¿øº» Archive Log FileÀÌ À¯½ÇµÇ´Â °æ¿ì¿¡µµ Á¤»óÀûÀ¸·Î Recovery¸¦ ÁøÇàÇÒ ¼ö ÀÖ´Ù.
¹é¾÷µÈ ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏÀº ´ÙÀ½ÀÇ Çü½ÄÀ¸·Î °ü¸®µÈ´Ù.
bkl_<BACKUPSET#>_t<THREAD#>-r<RESETLOGSTSN>-s<SEQUENCE#>.arc
¿¹¸¦ µé¾î BACKUPSET#´Â 1, THREAD#´Â 0, RESETLOGS TSN´Â 0, SEQEUNCE#´Â 1ÀÎ °æ¿ì ÆÄÀϸíÀº 'bkl_1_t0-r0-s1.arc'ÀÌ µÈ´Ù.
V$BACKUP_SETÀ» Á¶È¸ÇÔÀ¸·Î½á °¢ Backup Set¿¡ Archive Log BackupÀÌ Á¸ÀçÇÏ´ÂÁö È®ÀÎÇÒ ¼ö ÀÖÀ¸¸ç, V$BACKUP_ARCHIVED_LOG¸¦ Á¶È¸ÇÔÀ¸·Î½á Archive Log BackupÀÇ Á¤º¸¸¦ È®ÀÎÇÒ ¼ö ÀÖ´Ù.
[¿¹ 6.13] With Archive Log ¿É¼ÇÀ» Àû¿ëÇÑ Online Full Backup ½Ã³ª¸®¿À
$ tbrmgr backup --with-archivelog -o /home/tbrdb/work/6/backup/ ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - ONLINE backup ============================================= DB connected archive log check succeeded 100.00% |=======================================>| 12800/12800 blks 0.08s Synchronizing... 100.00% |=======================================>| 25600/25600 blks 0.18s Synchronizing... 100.00% |=======================================>| 12800/12800 blks 0.08s Synchronizing... 100.00% |=======================================>| 1280/1280 blks 0.02s Synchronizing... Database full backup succeeded DB disconnected RMGR backup ends $ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; SET_ID START_TIME ---------- ---------------------------------------------------------------- FINISH_TIME START_TSN ---------------------------------------------------------------- ---------- FINISH_TSN RESETLOGS_TSN BASE_SET SIZE(KB) IS_PARTIAL IS_INCREMENTAL ---------- ------------- ---------- ---------- ---------- -------------- WITH_ARCHIVELOG --------------- 1 2016/06/16 2016/06/16 34386 34441 0 0 453588 NO NO YES 1 row selected. SQL> set line 200 SQL> col MIN_LOG_TIME for a20 SQL> col MAX_LOG_TIME for a20 SQL> col RESETLOG_TIME for a20 SQL> select * from V$BACKUP_ARCHIVED_LOG a; SET_ID MIN_LOG_TSN MAX_LOG_TSN MIN_LOG_TIME MAX_LOG_TIME ---------- ----------- ----------- -------------------- -------------------- 1 34386 34441 2016/06/16 2016/06/16 MIN_LOG_SEQUENCE MAX_LOG_SEQUENCE RESETLOG_TSN RESETLOG_TIME ---------------- ---------------- ------------ -------------------- 2 2 0 1 row selected.
With Archive Log ¿É¼ÇÀ» Àû¿ëÇÑ Incremental Backup ½Ã³ª¸®¿À
¾Õ¼ Online Full BackupÀ» ÅëÇØ »ý¼ºµÈ Full Backup SetÀÌ ÃÖ¼Ò 1°³ ÀÌ»ó Á¸ÀçÇÏ´Â °æ¿ì¿¡´Â °¡Àå ÃÖ½ÅÀÇ Backup Set°ú ÇöÀç »óŸ¦ ºñ±³ÇÏ¿© º¯°æ»çÇ׸¸À» BackupÇÏ´Â Incremental BackupÀ» ¼öÇàÇÒ ¼ö ÀÖ´Ù. º¯°æ»çÇ׸¸À» BackupÇϹǷΠFull Backup Set¿¡ ºñÇØ Backup SetÀÇ Size¸¦ ȹ±âÀûÀ¸·Î ÁÙÀÏ ¼ö ÀÖÁö¸¸, ¾Õ¼± Backup SetÀÌ À¯½ÇµÇ¾î ºñ±³ ´ë»óÀÌ »ç¶óÁö°Ô µÇ¸é BackupsetÀ» Database Recovery¿¡ »ç¿ëÇÒ ¼ö ¾ø´Â À§Ç輺ÀÌ Á¸ÀçÇÑ´Ù.
V$BACKUP_SETÀ» Á¶È¸ÇÔÀ¸·Î½á °¢ Backup SetÀÌ Incremental Backup SetÀÎÁö È®ÀÎÇÒ ¼ö ÀÖÀ¸¸ç, Incremental Backup½Ã ºñ±³ ´ë»óÀÌ µÇ´Â Backup Set(Base Set)ÀÇ ID¸¦ È®ÀÎÇÒ ¼ö ÀÖ´Ù. Full Backup SetÀÇ °æ¿ì Base SetÀÌ Á¸ÀçÇÏÁö ¾ÊÀ¸¹Ç·Î Base Set ID°¡ 0À¸·Î Ç¥±âµÈ´Ù.
[¿¹ 6.14] With Archive Log ¿É¼ÇÀ» Àû¿ëÇÑ Incremental Backup ½Ã³ª¸®¿À
$ tbrmgr backup -i --with-archivelog -o /home/tbrdb/work/6/backup/ ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - INCREMENTAL backup ============================================= DB connected archive log check succeeded 100.00% |=======================================>| 12800/12800 blks 0.04s Synchronizing... 100.00% |=======================================>| 25600/25600 blks 0.04s Synchronizing... 100.00% |=======================================>| 12800/12800 blks 0.02s Synchronizing... 100.00% |=======================================>| 1280/1280 blks 0.02s Synchronizing... Database incremental backup succeeded DB disconnected RMGR backup ends $ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; SET_ID START_TIME ---------- ---------------------------------------------------------------- FINISH_TIME START_TSN ---------------------------------------------------------------- ---------- FINISH_TSN RESETLOGS_TSN BASE_SET SIZE(KB) IS_PARTIAL IS_INCREMENTAL ---------- ------------- ---------- ---------- ---------- -------------- WITH_ARCHIVELOG --------------- 1 2016/06/16 2018/06/11 34386 34441 0 0 453588 NO NO YES 2 2016/06/16 2018/06/11 34448 35234 0 1 23730 NO YES YES 2 rows selected. SQL> set line 200 SQL> col MIN_LOG_TIME for a20 SQL> col MAX_LOG_TIME for a20 SQL> col RESETLOG_TIME for a20 SQL> select * from V$BACKUP_ARCHIVED_LOG a; SET_ID MIN_LOG_TSN MAX_LOG_TSN MIN_LOG_TIME MAX_LOG_TIME ---------- ----------- ----------- -------------------- -------------------- 1 34386 34441 2016/06/16 2016/06/16 2 34448 35234 2016/06/16 2016/06/16 MIN_LOG_SEQUENCE MAX_LOG_SEQUENCE RESETLOG_TSN RESETLOG_TIME ---------------- ---------------- ------------ -------------------- 2 2 0 6 6 0 2 row selected.
Online Full BackupÀ» ÀÌ¿ëÇÑ Recovery ½Ã³ª¸®¿À
RMGRÀº Online Full BackupÀ» ÅëÇØ »ý¼ºµÈ Backup SetÀ» ÀÌ¿ëÇÏ¿© Recovery¸¦ ¼öÇàÇÒ ¼ö ÀÖ´Ù. ¾Æ·¡ ¿¹Á¦´Â Backup Set¿¡ Archive Log BackupÀÌ Á¸ÀçÇÏÁö ¾Ê´Â °æ¿ì·Î, ÀÌ °æ¿ì¿¡´Â ¿øº» Archive Log FileÀ» °¡Áö°í ÀÖ¾î¾ß Recovery¸¦ ÁøÇàÇÒ ¼ö ÀÖ´Ù.
[¿¹ 6.15] Online Full BackupÀ» ÀÌ¿ëÇÑ Recovery ½Ã³ª¸®¿À
$ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; SET_ID START_TIME ---------- ---------------------------------------------------------------- FINISH_TIME START_TSN ---------------------------------------------------------------- ---------- FINISH_TSN RESETLOGS_TSN BASE_SET SIZE(KB) IS_PARTIAL IS_INCREMENTAL ---------- ------------- ---------- ---------- ---------- -------------- WITH_ARCHIVELOG --------------- 1 2016/06/16 2016/06/16 34386 34441 0 0 453588 NO NO NO 1 row selected. SQL> quit Disconnected. $ tbrmgr recover -o /home/tbrdb/work/6/backup/ ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - recovery ============================================= Tibero instance terminated (ABNORMAL mode). Control file #0 (/home/tbrdb/work/6/database/TB6/c1.ctl) is accessible Listener port = 45648 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (MOUNT mode). DB Connected RMGR BEGIN RESTORE full backup set_id: 1 last incremental backup set_id: 1 Applying FULL BACKUP (set_id:1, ts_id:0, df_id:0) 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:1, df_id:1) 100.00% |=======================================>| 25600/25600 blks 0.20s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:3, df_id:2) 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:4, df_id:3) 100.00% |=======================================>| 1280/1280 blks 0.00s Synchronizing... Database restore succeeded recoverSQL: ALTER DATABASE RECOVER AUTOMATIC Database automatic recovery succeeded DB disconnected Tibero instance terminated (NORMAL mode). Listener port = 45648 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode). RMGR recovery ends
Online Full Backup°ú Archive Log BackupÀ» ÀÌ¿ëÇÑ Recovery ½Ã³ª¸®¿À
RMGRÀº Online Full BackupÀ» ÅëÇØ »ý¼ºµÈ Backup SetÀ» ÀÌ¿ëÇÏ¿© Database Recovery¸¦ ¼öÇàÇÒ ¼ö ÀÖ´Ù. ¾Æ·¡ ¿¹Á¦´Â ¿øº» Archive Log FileÀÌ À¯½ÇµÈ °æ¿ì·Î, with Archive Log(--with-archivelog) ¿É¼ÇÀ» ÅëÇØ Archive Log BackupÀ» RestoreÇÏ´Â °æ¿ì¿¡´Â Á¤»óÀûÀ¸·Î Recovery°¡ ÁøÇàµÇÁö¸¸, with Archive Log(--with-archivelog) ¿É¼ÇÀ» Àû¿ëÇÏÁö ¾Ê°í Recovery¸¦ ¼öÇàÇÏ´Â °æ¿ì¿¡´Â Recovery¿¡ ½ÇÆÐÇÏ´Â °ÍÀ» È®ÀÎÇÒ ¼ö ÀÖ´Ù.
[¿¹ 6.16] Online Full Backup°ú Archive Log BackupÀ» ÀÌ¿ëÇÑ Recovery ½Ã³ª¸®¿À
$ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; SET_ID START_TIME ---------- ---------------------------------------------------------------- FINISH_TIME START_TSN ---------------------------------------------------------------- ---------- FINISH_TSN RESETLOGS_TSN BASE_SET SIZE(KB) IS_PARTIAL IS_INCREMENTAL ---------- ------------- ---------- ---------- ---------- -------------- WITH_ARCHIVELOG --------------- 1 2016/06/16 2016/06/16 34386 34441 0 0 453588 NO NO YES 1 row selected. SQL> set line 200 SQL> col MIN_LOG_TIME for a20 SQL> col MAX_LOG_TIME for a20 SQL> col RESETLOG_TIME for a20 SQL> select * from V$BACKUP_ARCHIVED_LOG a; SET_ID MIN_LOG_TSN MAX_LOG_TSN MIN_LOG_TIME MAX_LOG_TIME ---------- ----------- ----------- -------------------- -------------------- 1 34386 34441 2016/06/15 2016/06/16 MIN_LOG_SEQUENCE MAX_LOG_SEQUENCE RESETLOG_TSN RESETLOG_TIME ---------------- ---------------- ------------ -------------------- 2 2 0 1 row selected. SQL> quit Disconnected. $ tbrmgr recover -o /home/tbrdb/work/6/backup/ ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - recovery ============================================= Tibero instance terminated (ABNORMAL mode). Control file #0 (/home/tbrdb/work/6/database/TB6/c1.ctl) is accessible Listener port = 45648 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (MOUNT mode). DB Connected RMGR BEGIN RESTORE full backup set_id: 1 last incremental backup set_id: 1 Applying FULL BACKUP (set_id:1, ts_id:0, df_id:0) 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:1, df_id:1) 100.00% |=======================================>| 25600/25600 blks 0.20s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:3, df_id:2) 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:4, df_id:3) 100.00% |=======================================>| 1280/1280 blks 0.00s Synchronizing... Database restore succeeded recoverSQL: ALTER DATABASE RECOVER AUTOMATIC RMGR Error: recovery failed (automatic recovery failed) SVR Error: Unable to find archive log file for thread 0 from change 34428. $ tbrmgr recover --with-archivelog -o /home/tbrdb/work/6/backup/ ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - recovery ============================================= Tibero instance terminated (ABNORMAL mode). Control file #0 (/home/tbrdb/work/6/database/TB6/c1.ctl) is accessible Listener port = 45648 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (MOUNT mode). DB Connected RMGR BEGIN RESTORE full backup set_id: 1 last incremental backup set_id: 1 Applying FULL BACKUP (set_id:1, ts_id:0, df_id:0) 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:1, df_id:1) 100.00% |=======================================>| 25600/25600 blks 0.20s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:3, df_id:2) 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:4, df_id:3) 100.00% |=======================================>| 1280/1280 blks 0.00s Synchronizing... Database restore succeeded recoverSQL: ALTER DATABASE RECOVER AUTOMATIC Database automatic recovery succeeded DB disconnected Tibero instance terminated (NORMAL mode). Listener port = 45648 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode). RMGR recovery ends
Online Full Backup°ú Incremental BackupÀ» ÀÌ¿ëÇÑ Recovery ½Ã³ª¸®¿À
RMGRÀº Online Full BackupÀ» ÅëÇØ »ý¼ºµÈ Backup Set°ú Incremental BackupÀ» ÅëÇØ »ý¼ºµÈ Backup SetÀ» ÀÚµ¿À¸·Î MergeÇÏ¿© Recovery¸¦ ÁøÇàÇÑ´Ù.
[¿¹ 6.17] Online Full Backup°ú Incremental BackupÀ» ÀÌ¿ëÇÑ Recovery ½Ã³ª¸®¿À
$ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; SET_ID START_TIME ---------- ---------------------------------------------------------------- FINISH_TIME START_TSN ---------------------------------------------------------------- ---------- FINISH_TSN RESETLOGS_TSN BASE_SET SIZE(KB) IS_PARTIAL IS_INCREMENTAL ---------- ------------- ---------- ---------- ---------- -------------- WITH_ARCHIVELOG --------------- 1 2016/06/16 2018/06/11 34386 34441 0 0 453588 NO NO YES 2 2016/06/16 2018/06/11 34448 35234 0 1 23730 NO YES YES 2 rows selected. 2 rows selected. SQL> set line 200 SQL> col MIN_LOG_TIME for a20 SQL> col MAX_LOG_TIME for a20 SQL> col RESETLOG_TIME for a20 SQL> select * from V$BACKUP_ARCHIVED_LOG a; SET_ID MIN_LOG_TSN MAX_LOG_TSN MIN_LOG_TIME MAX_LOG_TIME ---------- ----------- ----------- -------------------- -------------------- 1 34386 34441 2016/06/16 2016/06/16 2 34448 35234 2016/06/16 2016/06/16 MIN_LOG_SEQUENCE MAX_LOG_SEQUENCE RESETLOG_TSN RESETLOG_TIME ---------------- ---------------- ------------ -------------------- 2 2 0 6 6 0 2 row selected. SQL> quit Disconnected. $ tbrmgr recover --with-archivelog -o /home/tbrdb/work/6/backup ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - recovery ============================================= Tibero instance terminated (ABNORMAL mode). Control file #0 (/home/tbrdb/work/6/database/TB6/c1.ctl ) is accessible Listener port = 45648 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (MOUNT mode). DB Connected RMGR BEGIN RESTORE full backup set_id: 1 last incremental backup set_id: 2 Applying FULL BACKUP (set_id:1, ts_id:0, df_id:0) 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:1, df_id:1) 100.00% |=======================================>| 25600/25600 blks 0.20s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:3, df_id:2) 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... Applying FULL BACKUP (set_id:1, ts_id:4, df_id:3) 100.00% |=======================================>| 1280/1280 blks 0.00s Synchronizing... Applying INCREMENTAL BACKUP (set_id:2, ts_id:0, df_id:0) 100.00% |=======================================>| 12800/12800 blks 0.60s Synchronizing... Applying INCREMENTAL BACKUP (set_id:2, ts_id:1, df_id:1) 100.00% |=======================================>| 25600/25600 blks 1.20s Synchronizing... Applying INCREMENTAL BACKUP (set_id:2, ts_id:3, df_id:2) 100.00% |=======================================>| 12800/12800 blks 0.80s Synchronizing... Applying INCREMENTAL BACKUP (set_id:2, ts_id:4, df_id:3) 100.00% |=======================================>| 1280/1280 blks 0.00s Synchronizing... Database restore succeeded recoverSQL: ALTER DATABASE RECOVER AUTOMATIC Database automatic recovery succeeded DB disconnected Tibero instance terminated (NORMAL mode). Listener port = 45648 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode). RMGR recovery ends
Tablespace ±â¹Ý Recovery ½Ã³ª¸®¿À
RMGRÀº »ç¿ëÀÚ°¡ Tablespace NameÀ¸·Î ÁöÁ¤ÇÑ(--tablespace ¿É¼Ç) ƯÁ¤ Å×ÀÌºí ½ºÆäÀ̽º¿¡ ´ëÇؼ¸¸ Recovery¸¦ ¼öÇàÇÒ ¼ö ÀÖ´Ù. V$BACKUP_SET_TABLESPACEÀ» Á¶È¸ÇÔÀ¸·Î½á °¢ Backup Set¿¡ Æ÷ÇÔµÈ Å×ÀÌºí ½ºÆäÀ̽º¸¦ È®ÀÎÇÒ ¼ö ÀÖ´Ù.
[¿¹ 6.18] Tablespace ±â¹Ý Recovery ½Ã³ª¸®¿À
$ tbsql sys/tibero SQL> set line 200 SQL> col NAME for a20 SQL> select * from V$TABLESPACE a; TS# NAME TYPE BIGFILE FLASHBACK_ON ---------- -------------------- ---- ------- ------------ 0 SYSTEM DATA NO NO 1 UNDO UNDO NO NO 2 TEMP TEMP NO NO 3 USR DATA NO NO 4 SYSSUB DATA NO NO 5 rows selected. SQL> select * from V$BACKUP_SET_TABLESPACE; SET_ID TS# ---------- ---------- 1 0 1 1 1 3 1 4 4 rows selected. SQL> quit Disconnected. $ tbrmgr recover --tablespace USR -o /home/tbrdb/work/6/backup/ ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - recovery ============================================= Tibero instance terminated (ABNORMAL mode). Control file #0 (/home/tbrdb/work/6/database/TB6/c1.ctl) is accessible Listener port = 45648 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (MOUNT mode). DB Connected RMGR BEGIN RESTORE full backup set_id: 1 last incremental backup set_id: 1 Applying FULL BACKUP (set_id:1, ts_id:3, df_id:2) 100.00% |=======================================>| 12800/12800 blks 0.00s Synchronizing... Database restore succeeded recoverSQL: ALTER DATABASE RECOVER AUTOMATIC Database automatic recovery succeeded DB disconnected Tibero instance terminated (NORMAL mode). Listener port = 45648 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode). RMGR recovery ends
º» Àý¿¡¼´Â ´ÙÀ½ÀÇ ¹é¾÷ »èÁ¦ ½Ã³ª¸®¿À¸¦ ÅëÇؼ RMGRÀ» ÀÌ¿ëÇÑ ¹é¾÷ »èÁ¦¸¦ ¼³¸íÇÑ´Ù.
RMGRÀ» ÀÌ¿ëÇÏ¿© Backup SetÀ» »èÁ¦ÇÏ´Â °æ¿ì, »èÁ¦ ´ë»óÀÌ µÇ´Â Target Backup SetÀº µÎ °¡Áö ¹æ½ÄÀ¸·Î ÁöÁ¤ÇÒ ¼ö ÀÖ´Ù. ù ¹ø°·Î Backup Set ID(--backup_set ¿É¼Ç)¸¦ ¸í½ÃÇÏ¿© ÇØ´ç Backup Set¸¸À» »èÁ¦ÇÒ ¼ö ÀÖÀ¸¸ç, µÎ ¹ø°·Î Backup Date(--beforetime ¿É¼Ç)¸¦ ¸í½ÃÇÏ¿© ¸í½ÃÇÑ Backup Date ÀÌÀü¿¡ BackupÀÌ ÀÌ·ç¾îÁø ¸ðµç Backup SetµéÀ» »èÁ¦ÇÒ ¼ö ÀÖ´Ù.
RMGRÀº ControlfileÀ» ÂüÁ¶ÇÏ¿© »èÁ¦ ´ë»óÀ¸·Î ÁöÁ¤µÈ Backup SetÀÇ Á¸Àç À¯¹«¿Í ¹é¾÷ °æ·Î¸¦ È®ÀÎÇÑ ÈÄ »èÁ¦¸¦ ÁøÇàÇÑ´Ù. µû¶ó¼ Controlfile¿¡¼ ÂüÁ¶ÇÒ ¼ö ¾ø´Â Backup SetÀº RMGRÀ» ÀÌ¿ëÇÏ¿© »èÁ¦ÇÒ ¼ö ¾øÀ¸¸ç, Backup SetÀÌ Á¸ÀçÇÏ´Â ¹é¾÷ °æ·Î°¡ BackupÇÒ ¶§ Controlfile¿¡ µî·ÏµÈ ¹é¾÷ °æ·Î¿Í ´Ù¸¥ °æ¿ì¿¡´Â Backup Dest(-o ¿É¼Ç)¸¦ Á÷Á¢ ¸í½ÃÇØÁÖ¾î¾ß º¯°æµÈ ¹é¾÷ °æ·Î¿¡¼ ½ÇÁ¦ ¹é¾÷µÈ ÆÄÀÏ¿¡ ´ëÇÑ »èÁ¦¸¦ ÁøÇàÇÒ ¼ö ÀÖ´Ù. Controlfile¿¡ µî·ÏµÇ¾î ÀÖ´Â Backup Set Á¤º¸´Â V$BACKUP_SETÀ» ÅëÇØ Á¶È¸ÇÒ ¼ö ÀÖÀ¸¸ç, °¢ Backup Set¿¡ ¼ÓÇÏ´Â Archive LogÁ¤º¸´Â V$BACKUP_ARCHIVED_LOG¸¦ ÅëÇØ Á¶È¸ÇÒ ¼ö ÀÖ´Ù.
Âü°í
Controlfile¿¡ µî·ÏµÈ Backup SetÀ» »ç¿ëÀÚ°¡ ¼öµ¿À¸·Î »èÁ¦ÇÏ¿´°Å³ª, À߸øµÈ ¹é¾÷ °æ·Î¸¦ ¸í½ÃÇÏ¿© ¹é¾÷ °æ·Î¿¡¼ »èÁ¦ ´ë»óÀ¸·Î ÁöÁ¤µÈ Backup SetÀ» ãÀ» ¼ö ¾ø´Â °æ¿ì¿¡´Â Controlfile¿¡ µî·ÏµÈ Backup Set Entry¸¸À» »èÁ¦ÇÏ°í Á¾·áÇÑ´Ù. ¶ÇÇÑ Å×ÀÌÇÁ Àåºñ¿¡ ÀúÀåµÈ °æ¿ì ¿ª½Ã Controlfile¿¡ µî·ÏµÈ Backup Set Entry¸¸À» »èÁ¦ÇÏ°í Á¾·áÇÑ´Ù.
Backup Set ID¿¡ ±â¹ÝÇÑ ¹é¾÷ »èÁ¦ ½Ã³ª¸®¿À
RMGRÀº »ç¿ëÀÚ°¡ Backup Set ID·Î ÁöÁ¤ÇÑ(--backup_set ¿É¼Ç) ƯÁ¤ Backup Set¸¸À» ¼±ÅÃÀûÀ¸·Î »èÁ¦ÇÒ ¼ö ÀÖ´Ù.
´ÙÀ½ ¿¹Á¦¿¡¼´Â RMGRÀ» ÀÌ¿ëÇÏ¿© Backup Set ID = 1¿¡ ÇØ´çÇÏ´Â Backup SetÀ» »èÁ¦ÇÑ´Ù.
[¿¹ 6.19] Backup Set ID¿¡ ±â¹ÝÇÑ ¹é¾÷ »èÁ¦ ½Ã³ª¸®¿À
$ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; SET_ID START_TIME ---------- ---------------------------------------------------------------- FINISH_TIME START_TSN ---------------------------------------------------------------- ---------- FINISH_TSN RESETLOGS_TSN BASE_SET SIZE(KB) IS_PARTIAL IS_INCREMENTAL ---------- ------------- ---------- ---------- ---------- -------------- WITH_ARCHIVELOG --------------- 1 2018/06/11 2018/06/11 37093 37109 0 0 453588 NO NO YES 2 2018/06/11 2018/06/11 37361 37377 0 0 453588 NO NO YES 3 2018/06/11 2018/06/11 37390 37406 0 0 453588 NO NO YES 3 rows selected. SQL> quit Disconnected. $ tbrmgr delete --backup_set 1 -o /home/tbrdb/work/6/backup ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - delete ============================================= DB connected #1 of #3 backup sets erased RMGR delete ends $ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; SET_ID START_TIME ---------- ---------------------------------------------------------------- FINISH_TIME START_TSN ---------------------------------------------------------------- ---------- FINISH_TSN RESETLOGS_TSN BASE_SET SIZE(KB) IS_PARTIAL IS_INCREMENTAL ---------- ------------- ---------- ---------- ---------- -------------- WITH_ARCHIVELOG --------------- 2 2018/06/11 2018/06/11 37361 37377 0 0 453588 NO NO YES 3 2018/06/11 2018/06/11 37390 37406 0 0 453588 NO NO YES 2 rows selected.
Backup Date¿¡ ±â¹ÝÇÑ ¹é¾÷ »èÁ¦ ½Ã³ª¸®¿À
RMGRÀº »ç¿ëÀÚ°¡ Backup Date·Î ÁöÁ¤ÇÑ(--beforetime ¿É¼Ç) ½Ã°£ ÀÌÀü¿¡ »ý¼ºµÈ ¸ðµç Backup SetÀ» »èÁ¦ÇÒ ¼ö ÀÖ´Ù.
´ÙÀ½ ¿¹Á¦¿¡¼´Â RMGRÀ» ÀÌ¿ëÇÏ¿© "2016³â 06¿ù 17ÀÏ 12½Ã" ÀÌÀü¿¡ »ý¼ºµÈ ¸ðµç Backup SetÀ» »èÁ¦ÇÑ´Ù. Backup Date´Â YYYYMMDDHH(24)mmss ÇüÅ·Π¸í½ÃÇÑ´Ù.
[¿¹ 6.20] Backup Date¿¡ ±â¹ÝÇÑ ¹é¾÷ »èÁ¦ ½Ã³ª¸®¿À ()
$ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; SET_ID START_TIME ---------- ---------------------------------------------------------------- FINISH_TIME START_TSN ---------------------------------------------------------------- ---------- FINISH_TSN RESETLOGS_TSN BASE_SET SIZE(KB) IS_PARTIAL IS_INCREMENTAL ---------- ------------- ---------- ---------- ---------- -------------- WITH_ARCHIVELOG --------------- 2 2018/06/11 2018/06/11 37361 37377 0 0 453588 NO NO YES 3 2018/06/11 2018/06/11 37390 37406 0 0 453588 NO NO YES 2 rows selected. SQL> quit Disconnected. $ tbrmgr delete --beforetime 20180612120000 -o /home/tbrdb/work/6/backup/ ================================================================== = Recovery Manager(RMGR) starts = = = = TmaxData Corporation Copyright (c) 2008-. All rights reserved. = ================================================================== ============================================= RMGR - delete ============================================= DB connected #2 of #2 backup sets erased RMGR delete ends $ tbsql sys/tibero SQL> set line 200 SQL> col START_TIME for a20 SQL> col FINISH_TIME for a20 SQL> select * from V$BACKUP_SET a; 0 rows selected.