Tibero DB¹é¾÷ ¹× º¹±¸ ¹æ¹ý
Ƽº£·Î ¹é¾÷ ¹× º¹¿ø¿¡ °üÇÏ¿©
ã´Ù°¡ ÀÇ¿Ü´Ù ½Í¾ú´ø ºÎºÐÀÌ oracleÀÇ °æ¿ì dump¸¦ ¸¸µé¾î ¹é¾÷ÇÑ ´ÙÀ½ º¹±¸ ½ÃÁ¡¿¡¼ Ç®¸é º¹±¸°¡ µÈ´Ù. ±×¸®°í ÀÌ´Â °èÁ¤º°·Î, DBº°·Î, ÄÁÅ×À̳ʺ°·Î °¡´ÉÇߴµ¥ Ƽº£·Îµµ ºñ½ÁÇÒ ÁÙ ¾Ë°í ã´Ù°¡ ´Ù¸¥ ³»¿ëÀÌ ¸¹¾Ò´Ù. ±×·¡¼ ±â·Ï¿ëÀ¸·Î ºí·Î±×¿¡ ³²±ä´Ù.
Tibero DB ¹é¾÷Àº
¼¹ö°¡ °¡µ¿ÁßÀÎ »óÅ¿¡¼ ÇÏ´Â ÇÖ ¹é¾÷ (Hot Backup)°ú
¼¹ö¸¦ ¼Ë´Ù¿î ÇÑ »óÅ¿¡¼ ÇÏ´Â ÄÝµå ¹é¾÷ (Cold Backup)ÀÌ ÀÖ´Ù
1. ÇÖ ¹é¾÷ (¼¹ö ¿î¿µÁß¿¡ ¹é¾÷ ¹æ½Ä)
ÇÖ ¹é¾÷Àº Archive log ¸ðµå¿¡¼¸¸ °¡´ÉÇÏ´Ù.
a. ÄÁÆ®·Ñ ÆÄÀÏ ¹é¾÷
SQL> alter database backup controlfile to trace as
'/home/tibero/tbdata_bak/ctrlfile001.sql' reuse NORESETLOGS;
b. µ¥ÀÌÅÍ ÆÄÀÏ ¹é¾÷
SQL> select * from v$tablespace; (ÇØ´ç ¸ðµç Å×ÀÌºí ½ºÆäÀ̽º ¸ðµÎ ¹é¾÷...TEMP´Â ÇÊ¿ä¾øÀ½)
SQL> ALTER TABLESPACE SYSTEM BEGIN BACKUP; -- ÇÖ¹é¾÷ ½ÃÀÛ(Çü½Ä : ALTER TABLESPACE [TABLESPACE_NAME] BEGIN BACKUP;)
SQL> ALTER TABLESPACE USER BEGIN BACKUP;
SQL> ALTER TABLESPACE UNDO BEGIN BACKUP;
SQL> ALTER TABLESPACE _APM_TS BEGIN BACKUP;
SQL> !cp /home/tibero/tbdata/system001.tdf /home/tibero/tbdata_bak/system001.tdf
SQL> !cp /home/tibero/tbdata/USER001.tdf /home/tibero/tbdata_bak/USER001.tdf
SQL> !cp /home/tibero/tbdata/UNDO001.tdf /home/tibero/tbdata_bak/UNDO001.tdf
SQL> !cp /home/tibero/tbdata/APM_TS001.tdf /home/tibero/tbdata_bak/APM_TS001.tdf
** tdf´Â µ¥ÀÌÅÍÆÄÀÏÀ» ÀǹÌÇÑ´Ù.
SQL> ALTER TABLESPACE SYSTEM END BACKUP; -- ÇÖ ¹é¾÷ Á¾·á(Çü½Ä : ALTER TABLESPACE [TABLESPACE_NAME] END BACKUP;)
SQL> ALTER TABLESPACE USER END BACKUP;
SQL> ALTER TABLESPACE UNDO END BACKUP;
SQL> ALTER TABLESPACE _APM_TS END BACKUP;
º¹±¸
¸¸¾à µ¥ÀÌÅÍ ÆÄÀÏÀ» Çϳª ³¯·È´Ù°í ÇÏÀÚ...
±×·³ ¹é¾÷ ¹ÞÀº µ¥ÀÌÅÍ ÆÄÀÏÀ» ¿øº» µ¥ÀÌÅÍ ÆÄÀÏ À§Ä¡·Î º¹»çÇؼ DB¸¦ ºÎÆÃÇÏ°Ô µÇ¸é mount ¸ðµå·Î Á¢¼ÓÀÌ µÉ°ÍÀÌ´Ù.
±×·¯¸é ¾Æ·¡¿Í °°ÀÌ recovery¸¦ ÇØÁÖ¸é normal ¸ðµå·Î ºÎÆÃÀÌ µÉ°ÍÀÌ´Ù.
SQL> tbsql sys/tibero -- sys°èÁ¤À¸·Î Á¢¼Ó
SQL> alter database recover automatic database;
tibero DB Àç±âµ¿
$ tbdown
$ tbboot
2. ÄÝµå ¹é¾÷ (¼¹ö¸¦ ³»¸° »óÅ¿¡¼ ÇÏ´Â ¹é¾÷)
(ÄÝµå ¹é¾÷Àº noarchive ¸ðµå¿¡¼µµ °¡´É)
SQL> select name from v$datafile; -- ³ª¿À´Â °÷ÀÇ ¸ðµç µ¥ÀÌÅÍÆÄÀÏÀÌ ¹é¾÷´ë»óÀÌ µÊ
SQL> select group#, member from v$logfile; -- ³ª¿À´Â °÷ÀÇ ¸ðµç µ¥ÀÌÅÍÆÄÀÏÀÌ ¹é¾÷´ë»óÀÌ µÊ
SQL> select name from v$controlfile; -- ³ª¿À´Â °÷ÀÇ ¸ðµç µ¥ÀÌÅÍÆÄÀÏÀÌ ¹é¾÷´ë»óÀÌ µÊ
tiberoDB ¼Ë´Ù¿î
$ tbdown
$ cp /home/tibero/tbdata/*.tdf /home/tibero/tbdata_bak/
$ cp /home/tibero/tbdata/*.tdf /home/tibero/tbdata_bak/
$ cp /home/tibero/tbdata/*.redo /home/tibero/tb data_bak/
$ cp /home/tibero/tbdata/*.ctl /home/tibero/tbdata_bak/
¶Ç´Â
$ cp /home/tibero/tbdata/*.* /home/tibero/tbdata_bak/
º¹±¸
ÇØ´ç º¹»çÇÑ ÆÄÀϵéÀ» ¿øº» À§Ä¡¿¡ º×°í DB ºÎÆÃ
Âü°íÇÑ ºí·Î±× : http://blog.naver.com/PostView.nhn?blogId=songsunsang&logNo=110162766256
Ãâó: https://gregsophist.tistory.com/21 [Gregory space]