Home » RDBMS Server » Server Administration » how to perform manual redo log switch (11g on solaris 10)
how to perform manual redo log switch [message #422068] Mon, 14 September 2009 03:37 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hello everyone

if some one can help me regarding taking or forcing db to take manual redo log switch so ARc process can write it in Archive log file


regards



shaheer

Report message to a moderator

Re: how to perform manual redo log switch [message #422075 is a reply to message #422068] Mon, 14 September 2009 03:57 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
 
alter system switch logfile;

Report message to a moderator

Re: how to perform manual redo log switch [message #422088 is a reply to message #422068] Mon, 14 September 2009 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
alter system archive log current;

Regards
Michel

Report message to a moderator

Re: how to perform manual redo log switch [message #422261 is a reply to message #422068] Tue, 15 September 2009 05:32 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
sir, thank you very much

regards

Report message to a moderator

Re: how to perform manual redo log switch [message #423224 is a reply to message #422261] Tue, 22 September 2009 16:58 Go to previous messageGo to next message
venucsit
Messages: 2
Registered: September 2009
Junior Member
alter system switch logfile;

Report message to a moderator

Re: how to perform manual redo log switch [message #423242 is a reply to message #423224] Wed, 23 September 2009 01:04 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why do you repeat the same thing a week later?
If you do it for all topics you will have work!

Regards
Michel

Report message to a moderator

Previous Topic: Oracle Scheduled Jobs.
Next Topic: ORA-01092: ORACLE instance terminated. Disconnection forced
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 16:30:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.