| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
 |
 |