BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡

±Û¾´ÀÌ: °³¶óŬ [º¹±¸]Member of Online Redo Log Group Á¶È¸¼ö: 7190


Work for Archive Log Mode ON and OFF
No shutdown is required
1. To investigate what status is the missing redo log is -
Select * from v$logfile shows which group and member is INVALID
2. From step 1, you will have the full path of the member that went corrupted. Drop this member -
Alter database drop logfile member 'fullpath/log_filename.log'
3. Add a new member to the group -
Alter database add logfile member '/fullpath/log_filename.log' reuse to group n; where log_filename.log and group n follow step 1
4. DONE

(Note: the size of the new redo log member should be the same as the other group members if you decide to use the same name and the option REUSE)


°ü·Ã±Û : ¾øÀ½ ±Û¾´½Ã°£ : 2005/07/26 15:47 from 218.38.148.205

  ³¯Â¥ Ç¥±â ¸ñ·Ïº¸±â »õ±Û ¾²±â Áö¿ì±â ÀÀ´ä±Û ¾²±â ±Û ¼öÁ¤ ÄÁÆ®·ÑÆÄÀÏ º¹±¸  
BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡