| alter system switch logfile; [message #337786] |
Fri, 01 August 2008 03:57  |
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  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
