Home » RDBMS Server » Server Administration » alter system switch logfile; (oracle 10g)
alter system switch logfile; [message #337786] Fri, 01 August 2008 03:57 Go to next message
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 #337793 is a reply to message #337786] Fri, 01 August 2008 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2013.htm#sthref4648

Regards
Michel
Re: alter system switch logfile; [message #337801 is a reply to message #337786] Fri, 01 August 2008 04:19 Go to previous messageGo to next message
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

Re: alter system switch logfile; [message #337821 is a reply to message #337801] Fri, 01 August 2008 05:13 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This will answer your question:
http://download.oracle.com/docs/cd/B10501_01/server.920/a96536/ch198.htm#REFRN10092

Note that this parameter is obsolete in 10g.

Regards
Michel
Previous Topic: Problem after upgrading
Next Topic: ORA-0600
Goto Forum:
  


Current Time: Fri Dec 09 05:51:33 CST 2016

Total time taken to generate the page: 0.12545 seconds