Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Server Administration » alertlog file size (Oracle 9i, 10g on Windows/Linux)
alertlog file size [message #428095] Tue, 27 October 2009 04:15 Go to next message
chetanaZ
Messages: 46
Registered: October 2009
Location: UK
Member
Hi,

How Oracle controls the size of alertSID.log file?

Does it purges the old data in aletSID.log or it just grows?

Also does it purges 'trc' files in bdumop and udump?

In case we remove those keeping last 2-3 days trc files, will it cause any issue?

Thanks and Regards,
Chetana
Report message to a moderator
Re: alertlog file size [message #428098 is a reply to message #428095] Tue, 27 October 2009 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 29419
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Oracle does not purge trace files.
Oracle does not care of what you do with them.
So do what you want, it does not harm.

Regards
Michel
Report message to a moderator
Re: alertlog file size [message #428103 is a reply to message #428095] Tue, 27 October 2009 04:28 Go to previous messageGo to next message
Kamran Agayev
Messages: 76
Registered: February 2009
Location: Azerbaijan, Baku
Member
Read more about trace files and alert.log file from the following link:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/process.htm#sthref1633
Report message to a moderator
Re: alertlog file size [message #428140 is a reply to message #428095] Tue, 27 October 2009 06:09 Go to previous messageGo to next message
chetanaZ
Messages: 46
Registered: October 2009
Location: UK
Member
Kamran and Michel,

Thanks for your reply

Kamran -> I referred the link as mentioned by you however could not make how the content and size of alerSID.log is controlled by Oracle

Could you please suggest me how it controls / purges entry in alerSID.log

Regards,
Chetana
Report message to a moderator
Re: alertlog file size [message #428143 is a reply to message #428140] Tue, 27 October 2009 06:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 9793
Registered: March 2002
Location: oracleDocoVille
Senior Member
As Michel already stated,
Oracle does not purge / rotate the alert logs by default.
You will have to employ external means.
Just google / search this forum for logrotate (an unix utility) or
write your own simple simple script.
Report message to a moderator
Re: alertlog file size [message #428147 is a reply to message #428140] Tue, 27 October 2009 06:27 Go to previous messageGo to next message
Kamran Agayev
Messages: 76
Registered: February 2009
Location: Azerbaijan, Baku
Member
Michel has already answered your question. I've posted that url for you to get more information only about trace files and alert.log file
Report message to a moderator
Re: alertlog file size [message #428151 is a reply to message #428095] Tue, 27 October 2009 06:30 Go to previous messageGo to next message
chetanaZ
Messages: 46
Registered: October 2009
Location: UK
Member
Thanks Mahesh

I will read more on logrotate

However it means Oracle does not purge the AlerSID.log file implicitly

Sorry for my understanding but in that case alertSID.log would have grown in GBs and on top of alertSID.log we would have seen the content of date belonging to the date we started using the database, which is not the case.

Regards,
Chetana
Report message to a moderator
Re: alertlog file size [message #428152 is a reply to message #428095] Tue, 27 October 2009 06:30 Go to previous message
chetanaZ
Messages: 46
Registered: October 2009
Location: UK
Member
Thanks Kamran

Our mails just crossed!

Regards,
Chetana
Report message to a moderator
Previous Topic:Database Creation with files on different machines
Next Topic:locks on oracle 11g (merged 3)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 15:55:06 CST 2009

Total time taken to generate the page: 0.02236 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.