Home » RDBMS Server » Server Administration » alertlog file size (Oracle 9i, 10g on Windows/Linux)  () 1 Vote
alertlog file size [message #428095] Tue, 27 October 2009 04:15 Go to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior 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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
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: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior 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: 132
Registered: October 2009
Location: UK
Senior 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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
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: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior 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: 132
Registered: October 2009
Location: UK
Senior 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: 132
Registered: October 2009
Location: UK
Senior 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: Fri Nov 29 11:29:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.