Online redo log group switch

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: 2006-01-13 17:58:54
Message-id: A6801E8A03316A4DA597866F77A013F7059C9F8A@irv2kexch01.tx.bg.corp

Regardless the meaning of the status field, why I see the following? After rede log group 8, it switches to group 2, then 1, 3, 4 ... I used RMAN to copy the whole database to another server, it works fine with group switching order 1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,...

[baddog]root:/>grep "mem# 0" /oracle/PS1/saptrace/background/alert_PS1.log | tail -18
  Current log# 2 seq# 14225 mem# 0: /oracle/PS1/origlogB/log_g16m1.dbf
  Current log# 1 seq# 14226 mem# 0: /oracle/PS1/origlogA/log_g15m1.dbf
  Current log# 3 seq# 14227 mem# 0: /oracle/PS1/origlogA/log_g17m1.dbf
  Current log# 4 seq# 14228 mem# 0: /oracle/PS1/origlogB/log_g18m1.dbf
  Current log# 5 seq# 14229 mem# 0: /oracle/PS1/origlogA/log_g19m1.dbf
  Current log# 6 seq# 14230 mem# 0: /oracle/PS1/origlogB/log_g22m1.dbf
  Current log# 7 seq# 14231 mem# 0: /oracle/PS1/origlogA/log_g21m1.dbf
  Current log# 8 seq# 14232 mem# 0: /oracle/PS1/origlogB/log_g20m1.dbf
  Current log# 2 seq# 14233 mem# 0: /oracle/PS1/origlogB/log_g16m1.dbf
  Current log# 1 seq# 14234 mem# 0: /oracle/PS1/origlogA/log_g15m1.dbf
  Current log# 3 seq# 14235 mem# 0: /oracle/PS1/origlogA/log_g17m1.dbf
  Current log# 4 seq# 14236 mem# 0: /oracle/PS1/origlogB/log_g18m1.dbf
  Current log# 5 seq# 14237 mem# 0: /oracle/PS1/origlogA/log_g19m1.dbf
  Current log# 6 seq# 14238 mem# 0: /oracle/PS1/origlogB/log_g22m1.dbf
  Current log# 7 seq# 14239 mem# 0: /oracle/PS1/origlogA/log_g21m1.dbf
  Current log# 8 seq# 14240 mem# 0: /oracle/PS1/origlogB/log_g20m1.dbf
  Current log# 2 seq# 14241 mem# 0: /oracle/PS1/origlogB/log_g16m1.dbf
  Current log# 1 seq# 14242 mem# 0: /oracle/PS1/origlogA/log_g15m1.dbf

-----Original Message-----

From: Roger Xu
Sent: Thursday, January 12, 2006 4:08 PM To: Oracle-L_at_Freelists. Org (E-mail)
Subject: online redo log group switch

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 13 2006 - 17:58:54 CST