alter system switch logfile; [message #337786] |
Fri, 01 August 2008 03:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
I know what the folowing command does,
I do not normally use this command because i do not have necessity to switch log file. My database is in archivelog mode.
alter system switch logfile;
Please tell me in which practical scenario do i need to switch the logfile?
|
|
|
|
Re: alter system switch logfile; [message #337801 is a reply to message #337786] |
Fri, 01 August 2008 04:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Thanks Michel,
While surfing on the internet i found one article .
It says Once database was halted; because the log files were full even if the database is in Archivelog mode.
It was halted because it was not generating archive log.
So he run comand to switch the log file and database starts to run.
So my question is when the log switch occurs that time will it generate ARCHIVE or overwrite the log file?
I think it should generate ARCHIVE am i correct?
[Updated on: Fri, 01 August 2008 04:36] Report message to a moderator
|
|
|
|