Home » RDBMS Server » Server Administration » Switching Logfile
Switching Logfile [message #193407] Sat, 16 September 2006 06:01 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Unable to drop the user using the system login
Next Topic: Rename a oracle database
Goto Forum:
  


Current Time: Thu Dec 08 06:21:11 CST 2016

Total time taken to generate the page: 0.26157 seconds