| Switching Logfile [message #193407] |
Sat, 16 September 2006 06:01  |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Hi,
I have redo log groups 1,2,3,4,5. I have added these groups in the same sequence while creating.
Whenever I say "ALTER SYSTEM SWITHC LOGFILE", it switches in the sequence 1,3,4,5,2,1,3......like.
Can anybody tell me what could be the reason!!!
Brayan.
|
|
|
|
| Re: Switching Logfile [message #193503 is a reply to message #193407] |
Sun, 17 September 2006 21:25  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
I think it just switches them according to the order they were created. Don't let the logfile number bother you.
Pay attention to the size and getting them to switch about every hour when they are full. Check MTTR (MeanTimeToRecover) numbers.
What version are you?
Neil.
|
|
|
|
| Re: Switching Logfile [message #193924 is a reply to message #193407] |
Tue, 19 September 2006 23:39 |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Hi Neil,
My oracle version is
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production and its Datawarehouse DB.
I've created in the same order 1,2,3,4,5. Actually I was bit curious what could be the reason it switches in different order.
Thank you,
Brayan.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
