online redo log group switch
- To: "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2006 16:07:40 -0600
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@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
