OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » alertlog file size (Oracle 9i, 10g on Windows/Linux) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

alertlog file size [message #428095]

Tue, 27 October 2009 04:15

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

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

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

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

Mahesh Rajendran
Messages: 10707
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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 01:19:17 CDT 2024