Home » RDBMS Server » Server Administration » How to clear log1-10orcl.ora?
How to clear log1-10orcl.ora? [message #55150] Tue, 07 January 2003 20:17 Go to next message
sirikunya
Messages: 1
Registered: January 2003
Junior Member
Dear Sir,
I got the problem on my Oracle Server; the log1orcl.ora up to log10orcl.ora becomming too large size. This make C drive allmost full; the system become slow and often show the message "virtual memory error" . So how can I clear these logs to get more disk space?
Thank you in advance for your advise.

Report message to a moderator

Re: How to clear log1-10orcl.ora? [message #55157 is a reply to message #55150] Wed, 08 January 2003 03:31 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
alter system switch logfile;

above sql, forces the logswitch (switches from current to the next available member).
But it is the right way.
you have to properly design your logfiles.
is there any archiving turned on?
then make sure that archived logs are also purged once they are backep up.

Report message to a moderator

Previous Topic: TO MAKE THE DATABASE TIME CLICK INVARIABLE OF OS date & time
Next Topic: operfdll.dll ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:44:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.