tibero ±âµ¿°ú Á¾·á
1. ±âµ¿ ´Ü°è
1) nomount : parameter Á¶È¸, instance Á¶È¸
2) mount : controlfile¸¸ ÀÖ´Ù¸é Á¶È¸°¡ °¡´É
- openÀÌ ¾Æ´Ò °æ¿ì sys¸¸ Á¢¼Ó, »ç¿ëÀÚ µ¥ÀÌÅÍ Á¶È¸ ºÒ°¡, dictionary view »ç¿ë
- $TB_SID.tipÀÌ Á¤»óÀÏ °æ¿ì instance ±âµ¿¿¡ ¹®Á¦°¡ ¾øÀ½
- c1.ctl : control file(binary)ÀÌ°í redolog ¹× datafile ¸ñ·Ï
size´Â Å©Áö ¾ÊÁö¸¸ tibero instance°¡ ÀÌ¿ëÇÏ°í redolog, datafile¿¡ Á¢±ÙÀÌ °¡´ÉÇÑ °ÍÀº DBÀÇ PATH Á¤º¸¸¦ ´ãÀ½
- controlfileÀº ±â·Ï³»¿ª°ú °æ·Î±îÁö Á¤º¸¸¦ ´ã°í Àֱ⠶§¹®¿¡ ¸ÞŸµ¥ÀÌÅÍ Á¤º¸¿Í ÀÏÄ¡ÇØ¾ß open °¡´É
´ÙÁßÈµÈ controlfile Áß Çϳª¶óµµ ¸Á°¡Áö¸é open¿¡ ¾î·Á¿òÀÌ ÀÖÀ½
- ¼Õ»óµÈ ÆÄÀÏÀº mount¸ðµå¿¡¼ redo recover·Î º¹±¸
3) open
2. ±âµ¿ ¹æ¹ý
1) resetlogs : º¹±¸ ÇÒ ¶§ ÀÚÁÖ »ç¿ë
2) tbboot ÇÒ ¶§ normal ¸ðµå ÀÏ ¶§¸¸ Á¤»óÀûÀ¸·Î ÀÛµ¿
3. Ƽº£·Î ÇÁ·Î¼¼½º È®ÀÎ ¹æ¹ý
[tibero@localhost ~]$ ps -ef | grep tbsvr
tibero 3920 1 15 11:19 pts/1 00:00:01 tbsvr -t NORMAL -SVR_SID tibero
tibero 3922 3920 0 11:19 pts/1 00:00:00 tbsvr_TBMP -t NORMAL -SVR_SID tibero
tibero 3923 3920 0 11:19 pts/1 00:00:00 tbsvr_WP000 -t NORMAL -SVR_SID tibero // ¾²·¹µå¸¦ 10°³
tibero 3924 3920 1 11:19 pts/1 00:00:00 tbsvr_WP001 -t NORMAL -SVR_SID tibero
tibero 3925 3920 0 11:19 pts/1 00:00:00 tbsvr_PEP000 -t NORMAL -SVR_SID tibero // º´·Ä ¾²·¹µå
tibero 3926 3920 0 11:19 pts/1 00:00:00 tbsvr_PEP001 -t NORMAL -SVR_SID tibero
tibero 3927 3920 0 11:19 pts/1 00:00:00 tbsvr_PEP002 -t NORMAL -SVR_SID tibero
tibero 3928 3920 0 11:19 pts/1 00:00:00 tbsvr_PEP003 -t NORMAL -SVR_SID tibero
tibero 3929 3920 7 11:19 pts/1 00:00:00 tbsvr_AGNT -t NORMAL -SVR_SID tibero
tibero 3930 3920 0 11:19 pts/1 00:00:00 tbsvr_DBWR -t NORMAL -SVR_SID tibero
tibero 3931 3920 10 11:19 pts/1 00:00:00 tbsvr_RECO -t NORMAL -SVR_SID tibero
tibero 4036 3861 0 11:19 pts/1 00:00:00 grep --color=auto tbsvr
4. tbdown
1) tbdown -h : tbdown¿¡ ´ëÇÑ ¿É¼Ç ¼³¸í
2) Á¤»ó Á¾·á
- tbdown normal : Á¢¼ÓÇÑ ¼¼¼ÇÀ̳ª ÁøÇàµÇ°í ÀÖ´Â Æ®·£Àè¼ÇÀÌ ÀÖ´Â °æ¿ì ³¡³¯ ¶§±îÁö ±â´Ù¸°´Ù.
- tbdown post_tx : ¸ðµç Æ®·£Àè¼ÇÀÌ ³¡³¯ ¶§±îÁö ±â´Ù¸° ÈÄ Á¾·á, commitÀ» ÇÏÁö ¾ÊÀ» °æ¿ì °è¼Ó ±â´Ù¸°´Ù.
- tbdown immediate : Á¢¼ÓÇÑ ¼¼¼ÇÀ̳ª Æ®·£Àè¼ÇÀ» °Á¦·Î ¼¼¼Ç Á¾·á, rollback ÈÄ Á¾·áµÈ´Ù.
3) ºñÁ¤»ó Á¾·á (°Á¦·Î ¿ÜºÎ¿¡¼ Á×ÀÌ´Â ¹æ¹ý) // ºñÁ¤»ó Á¾·á ÀÌÈÄ¿¡ Àç±âµ¿ ½Ã°£ °É¸®°í tibero monitor process(MTHR)°¡ ¸Þ½ÃÁö¸¦ ¹Þ°í ´Ù¸¥ process¿¡°Ô °Á¦ Á¾·á ½Ã±×³ÎÀ» Àü´ÞÇÑ´Ù.
- tbdown abort : Æ®·£Àè¼ÇÀ» Á¤¸®ÇÏÁö ¾Ê°í instance°¡ ³»·Á°£´Ù.(rollback ¾È ÇÔ)
- tbdown sitchover
- tbdown abnormal : process¸¦ kill·Î Á¾·á½ÃÅ°±â ¶§¹®¿¡ log¿¡ ³²Áö ¾Ê´Â´Ù.
- tbdown clean : log°¡ ³²Áö ¾Ê°í °øÀ¯¸Þ¸ð¸®³ª ¾²·¹µå ÀÚ¿øÀ» ÇØÁ¦½ÃŲ´Ù.
tibero°¡ ºñÁ¤»ó Á¾·áÀÏ ¶§ Ãæµ¹ÀÌ ³ª¼ ±âµ¿µÇÁö ¾Ê´Â °æ¿ì tbdown cleanÀ» ¼öÇàÇÏ¿© instance¸¦ °Á¦ Á¾·áÇÑ´Ù.
** CPU°¡ 100% »ç¿ëÇÏ°í ÀÖÀ» ¶§ ºñÁ¤»óÀûÀÎ Á¾·á¸¦ Çϸé abort¶óµµ Á¾·á°¡ ¾È µÉ ¼ö ÀÖ´Ù.
¼·Î ¸Þ½ÃÁö¸¦ ÁÖ°í ¹ÞÀ» ¼ö ¾øÀ» ¶§ OS kill ¸í·É¾î°¡ Á¤»ó ÀÛµ¿ÇÏ´õ¶óµµ abnormal·Î Á¾·á°¡ µÈ´Ù.
-------------------- ¿¬½À --------------------
¢º 1¹ø ¼¼¼Ç(terminal_1)
[tibero@localhost ~]$ tbsql sys/tibero
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Connected to Tibero.
SQL> create table t1(c1 number);
Table 'T1' created.
SQL> insert into t1 values(10);
1 row inserted.
¢º 2¹ø ¼¼¼Ç(terminal_2)
[tibero@localhost ~]$ tbsql sys/tibero
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Connected to Tibero.
SQL> select count(1) from v$transaction;
COUNT(1)
----------
1
1 row selected.
SQL> tbdown post_tx
¢º 1¹ø ¼¼¼Ç(terminal_1)
SQL> commit;
¢º 2¹ø ¼¼¼Ç(terminal_2)
DB instance was terminated.
¢º Á¾·á ÈÄ ÇÁ·Î¼¼½º È®ÀÎ : »ì¾ÆÀÖ´Â ÇÁ·Î¼¼½º ¾øÀ½
[tibero@localhost ~]$ ps -ef | grep tbsvr
5. Á¾·á ´Ü°è
1) database close : TSM¿¡ ÀÖ´Â ¸ðµç database data¿Í recover data¸¦
datafile, redologfile¿¡ °¢°¢ ±â·Ï ¡æ dirty blockÀ» disk¿¡ ³»¸®°í close
2) dismounting database : controlfile¿¡ ÀÌÀüÀÇ log¸¦ ±â·Ï
3) instance shutdown : TSM¿¡ ÀÖ´Â memory°¡ Á¦°ÅµÇ°í process°¡ Á¾·á
abnormal shutdownÀÌ µÇ¾úÀ» °æ¿ì TSM¿¡ memory°¡ »óÁֵǾî Àְųª process°¡ Á¾·áµÇÁö ¾ÊÀ» ¼ö ÀÖ´Ù.
µû¶ó¼ ÀÌÀü instance¸¦ Á¦°ÅÇϰųª tbdown abort ¸í·É¾î·Î »õ·Î¿î instance¸¦ °Á¦ Á¾·áÇÏ°í tbdown clean ÇÑ´Ù.