online redo log group switch

From: <oracle-l-bounce_at_freelists.org>
Date: 2006-01-12 23:07:40
Message-id: A6801E8A03316A4DA597866F77A013F7059C9F72@irv2kexch01.tx.bg.corp

Hi List,

Why after Group 8, it goes to Group 2? I always thought it went to Group 1.

Thanks,

Roger

SQL>select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# \ 
FIRST_TIME                    


---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- \ 

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

         1          1      14162  104857600          2 NO  CURRENT              988252544 \ 
2006-01-12:15:48:49           
         2          1      14161  104857600          2 YES ACTIVE               988241829 \ 
2006-01-12:15:44:35           
         3          1      14155  104857600          2 YES INACTIVE             988159814 \ 
2006-01-12:12:34:53           
         4          1      14156  104857600          2 YES INACTIVE             988169442 \ 
2006-01-12:13:46:45           
         5          1      14157  104857600          2 YES INACTIVE             988181499 \ 
2006-01-12:14:54:26           
         6          1      14158  104857600          2 YES INACTIVE             988199038 \ 
2006-01-12:15:21:05           
         7          1      14159  104857600          2 YES INACTIVE             988206483 \ 
2006-01-12:15:26:25           
         8          1      14160  104857600          2 YES INACTIVE             988222273 \ 
2006-01-12:15:32:46           

8 rows selected.

This e-mail is intended solely for the person or entity to which it is addressed and may \ contain confidential and/or privileged information. Any review, dissemination, copying, \ printing or other use of this e-mail by persons or entities other than the addressee is \ prohibited. If you have received this e-mail in error, please contact the sender \ immediately and delete the material.

---

This email has been scanned for all viruses by the MessageLabs Email Security System. Any \ questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 12 2006 - 23:07:40 CST