iWiz ShareBase

IT Specialist À±ÅÂÇöÀÇ iWiz ShareBase´Â IT»Ó ¾Æ´Ï¶ó °¢Á¾ Àâ´ÙÇÑ Áö½ÄµéÀ» ÇÔ²² ³ª´©´Â Áö½Ä°øÀ¯ Ä¿¹Â´ÏƼÀÔ´Ï´Ù.

iWiz,ShareBase,À±ÅÂÇö,Java,JSP,EJB,IT,Á¤º¸±â¼ú,À¥ÇÁ·Î±×·¡¹Ö,PHP,ASP,DBMS,MySQL,¼­¹ö,³×Æ®¿öÅ©,server,network,WAS,À¥¾ÖÇø®ÄÉÀ̼Ç,ºí·Î±×,blog,À¥¼­¹ö,DB,¿À¶óŬ,oracle,mysql,JRun,À¥·ÎÁ÷,ÅèĹ,tomcat,¾ÆÆÄÄ¡,ÀÚµ¿Â÷,EF½î³ªÅ¸,·Î¶Ç 6/45

°¶·¯¸® Pixelgrapher.com | ·Î¶Ç 6/45 ¹øÈ£»ý¼º ¹× Åë°è µ¥ÀÌÅÍ | Àüü±â»çº¸±â | Àüü±Û #1 | Àüü±Û #2 | Àüü±Û #3 | Àüü±Û #4 | Àüü±Û #5 | Àüü±Û #6 | Àüü±Û #7 | Àüü±Û #8 | Àüü±Û #9 | Àüü±Û #10 |
HOME iWiz
ShareBase
Remember 0523 & 0818
Áö½ÄÀº ³ª´­¼ö·Ï Ä¿Áý´Ï´Ù - iWiz's ShareBase
µ¥ÀÌÅͺ£À̽º µ¥ÀÌÅͺ£À̽º(DBMS)¿¡ °ü·ÃµÈ °¢Á¾ ÀÚ·áµéÀÔ´Ï´Ù.


  ¹ÚÁã(2004-04-22 10:46:20, Hit : 7058, Vote : 33

¸®µÎ·Î±× ÆÄÀÏÀÇ drop / add / relocation ¹× rename


¸®µÎ·Î±×ÆÄÀÏÀÇ relocationÀº µÎ°¡Áö ¹æ¹ýÀ¸·Î »ý°¢ÇØ º¼ ¼ö ÀÖ´Ù. Çϳª´Â ¸®µÎ·Î±×ÆÄÀÏÀ» addÇÑ ÈÄ dropÇÏ´Â ¹æ¹ýÀÌ ÀÖ°í, µÎ¹ø°´Â ALTER DATABASE RENAME FILEÀ» ÇÏ´Â ¹æ¹ýÀÌ ÀÖ´Ù. ÇÏÁö¸¸ µÎ¹ø° ¹æ¹ýÀº µ¥ÀÌŸº£À̽º¸¦ NOMOUNT´Ü°è·Î ¼³Á¤ÇØ¾ß µÇ±â ¶§¹®¿¡ ù¹ø° ¹æ¹ýÀÌ È¿À²ÀûÀ̶ó ÆǴܵȴÙ.

¶ÇÇÑ ¸®µÎ·Î±×ÆÄÀÏ°ú µ¥ÀÌŸ ÆÄÀÏ, ¸®µÎ·Î±×ÆÄÀÏ°ú ¾ÆÄ«À̺ê ÆÄÀÏÀº DISK ContentionÀ» ÁÙÀ̱â À§ÇØ °¢°¢ ´Ù¸¥ µð½ºÅ©¿¡ ÀúÀåÇÏ´Â °ÍÀÌ È¿À²ÀûÀÌ´Ù.

 

 

¸®µÎ·Î±× ÆÄÀÏÀÇ relocation

1. ºä¸¦ ÅëÇØ ¸®µÎ·Î±× ÆÄÀÏÀÇ ¼³Á¤ »óÅ ȮÀÎ

    SQL> SELECT L.GROUP#, L.SEQUENCE#, L.STATUS, F.STATUS, F.MEMBER

              FROM V$LOG L, V$LOGFILE F

              WHERE L.GROUP#=F.GROUP#

 

        GROUP#  SEQUENCE# STATUS           STATUS  MEMBER

        -------   ----------- --------          -------- ------------------------------

              1        1253             CURRENT         /home/ora920/oradata/asean3/redo01.log

              1        1253             CURRENT         /data/oradata/redo01b.log

              2        1251             INACTIVE          /home/ora920/oradata/asean3/redo02.log

              2        1251             INACTIVE          /data/oradata/redo02b.log

              3        1252             ACTIVE             /home/ora920/oradata/asean3/redo03.log

              3        1252             ACTIVE             /data/oradata/redo03b.log

 

2. ¸®µÎ·Î±× ÆÄÀÏÀÇ ±×·ì Ãß°¡

    SQL> ALTER DATABASE ADD LOGFILE

             ('/home/ora920/oradata/asean3/redo1a.log',

              '/data/oradata/redo1b.log') SIZE 100M;    

    Database altered.

 

3. ¸®µÎ·Î±×ÆÄÀÏ Ãß°¡ »óÅ ȮÀÎ

    SQL> SELECT L.GROUP#, L.SEQUENCE#, L.STATUS, F.STATUS, F.MEMBER

              FROM V$LOG L, V$LOGFILE F

              WHERE L.GROUP#=F.GROUP#

 

        GROUP#  SEQUENCE# STATUS           STATUS  MEMBER

        -------   ----------- --------          -------- ------------------------------

              1        1253             CURRENT         /home/ora920/oradata/asean3/redo01.log

              1        1253             CURRENT         /data/oradata/redo01b.log

              2        1251             INACTIVE          /home/ora920/oradata/asean3/redo02.log

              2        1251             INACTIVE          /data/oradata/redo02b.log

              3        1252             INACTIVE             /home/ora920/oradata/asean3/redo03.log

              3        1252             INACTIVE             /data/oradata/redo03b.log

              4          0                UNUSED           /home/ora920/oradata/asean3/redo1a.log

              4          0                UNUSED           /data/oradata/redo1b.log

 

4. ¸®µÎ·Î±×ÆÄÀÏÀÇ »èÁ¦ : ¸®µÎ·Î±×ÆÄÀÏÀÇ STATUS°¡ CURRENTÀ̰ųª ACTIVEÀÌ¸é »èÁ¦°¡ ¾ÈµÇ¹Ç·Î ALTER                                      SYSTEM SWITCH LOG FILEÀ̳ª STATUS°¡ INACTIVE°¡ µÉ ¶§ ±îÁö ±â´Ù·Á¾ß ÇÑ´Ù.

   SQL> ALTER DATABASE DROP LOGFILE GROUP 2;

   Database altered.

 

5. ¸®µÎ·Î±×ÆÄÀÏÀÇ »èÁ¦ »óÅ ȮÀÎ

   SQL> SELECT L.GROUP#, L.SEQUENCE#, L.STATUS, F.STATUS, F.MEMBER

              FROM V$LOG L, V$LOGFILE F

              WHERE L.GROUP#=F.GROUP#

 

   GROUP#  SEQUENCE# STATUS           STATUS  MEMBER

   -------   ----------- --------          -------- ------------------------------

         1        1253             CURRENT         /home/ora920/oradata/asean3/redo01.log

         1        1253             CURRENT         /data/oradata/redo01b.log

         3        1252             INACTIVE          /home/ora920/oradata/asean3/redo03.log

         3        1252             INACTIVE          /data/oradata/redo03b.log

         4          0                UNUSED           /home/ora920/oradata/asean3/redo1a.log

         4          0                UNUSED           /data/oradata/redo1b.log

 

6. OS»ó¿¡¼­ ÆÄÀÏ »èÁ¦ : DB³»¿¡¼­ ¸®µÎ·Î±×ÆÄÀÏÀ» »èÁ¦ Çß´õ¶óµµ OS»ó¿¡´Â ÆÄÀÏÀÌ ³²¾Æ ÀÖÀ¸¹Ç·Î ¹°¸®ÀûÀ¸·Î ÆÄÀÏÀ»                                     »èÁ¦ ÇØÁÖ¾î¾ß ÇÑ´Ù.(¼±ÅûçÇ×)

    [oramaster@asean oradata]$ rm redo02b.log

    [oramaster@asean asean3]$ rm redo02.log

* iWiz´Ô¿¡ ÀÇÇؼ­ °Ô½Ã¹° À̵¿µÇ¾ú½À´Ï´Ù (2010-02-03 17:06)



22   ¿À¶óŬ ¹«·á °ü¸® ÅøÀÌ À־ ¼Ò°³ ÇÕ´Ï´Ù. [1]  ±è±â¿µ 2007/04/28 8292 0
21   ¿Ü¿öµµ ¿Ü¿öµµ ±î¸Ô´Â ¿À¶óŬ ÇÔ¼ö (¹Ø¿¡²¨ ÆÛ°¡´Â ´ë½Å ¤¾) [1]  ÀÌÁØÈ£ 2004/07/15 11954 43
20   Default Temporary Tablespace ¼öÁ¤  ¹ÚÁã 2004/05/03 8965 44
  ¸®µÎ·Î±× ÆÄÀÏÀÇ drop / add / relocation ¹× rename  ¹ÚÁã 2004/04/22 7058 33
18   ¿À¶óŬ ±âº» ¸í·É¾î Á¤¸® [2]  iWiz 2004/04/07 9790 42
17   ¿À¶óŬÀÇ Undo Segment [3]  ¹ÚÁã 2004/04/06 9090 38
16   ER Diagram ÀÛ¼º ÇÁ·Î±×·¥ ERWin »ç¿ë ¹æ¹ý  iWiz 2004/04/04 13143 38
15   import À¯Æ¿¸®Æ¼ [3]  ¹ÚÁã 2004/04/01 6537 35
14   ¼¼¼Ç°ü¸®  ¹ÚÁã 2004/03/31 8165 31
13   LogMiner  ¹ÚÁã 2004/03/31 7340 39
12   ¿À¶óŬ¿¡¼­ÀÇ ¹é¾÷...  ¹ÚÁã 2004/03/30 6336 40
11   ¿À¶óŬÀÇ Constraint(Á¦¾àÁ¶°Ç)  ¹ÚÁã 2004/03/26 37575 38
10   Export À¯Æ¿¸®Æ¼ [1]  ¹ÚÁã 2004/03/23 5692 35
9   ºñ±³ / ³í¸® ¿¬»êÀÚ ¹× ¿¬»ê ¿ì¼± ¼øÀ§  ¹ÚÁã 2004/03/22 9336 41
8   NULLÀ̶õ?? [2]  ¹ÚÁã 2004/03/22 7993 32

1 [2]
 

Copyright 1999-2024 Zeroboard / skin by zero
iWiz ShareBase, ¨ÏCopyleft by iWiz.  For more information contact .
º» À¥»çÀÌÆ®¿¡ °Ô½ÃµÈ À̸ÞÀÏ ÁÖ¼Ò°¡ ÀüÀÚ¿ìÆí ¼öÁý ÇÁ·Î±×·¥À̳ª ±× ¹ÛÀÇ ±â¼úÀû ÀåÄ¡¸¦ ÀÌ¿ëÇÏ¿© ¹«´ÜÀ¸·Î ¼öÁýµÇ´Â °ÍÀ» °ÅºÎÇϸç, À̸¦ À§¹Ý½Ã¿¡´Â Á¤º¸Åë½Å¸Á¹ý¿¡ ÀÇÇØ Çü»çó¹úµÊÀ» À¯³äÇϽñ⠹ٶø´Ï´Ù. [°Ô½ÃÀÏ 2004. 1. 31]