Home » RDBMS Server » Server Administration » deletion of bdump .trc files
deletion of bdump .trc files [message #297113] Wed, 30 January 2008 03:26 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi,
I have one question regarding .trc files.
In /home/oracle/admin/ora01/bdump folder there are lot of files with extension .trc

I dont want those files any more.
I would like to know that if i will delete those files then will it cause any problem?

I think there should not be any problem. But as i want to delete those files from production database so please assist so i can delete those files.

Thanks,
Re: deletion of bdump .trc files [message #297116 is a reply to message #297113] Wed, 30 January 2008 03:34 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Trace files according to oracle gets generated only when you have some anomalies in the functioning of your background processes.

Did you look in to the trace files as to what information they contain?
Re: deletion of bdump .trc files [message #297119 is a reply to message #297116] Wed, 30 January 2008 03:46 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Some .trc files with filename ora01_arc0_4787.trc contains.

*** SERVICE NAME:() 2008-01-17 16:37:19.288
*** SESSION ID:(157.3) 2008-01-17 16:37:19.288
kcrrwkx: nothing to do (start)
*** 2008-01-17 16:38:18.668
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:39:18.669
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:40:18.670
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:41:18.679
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:42:18.705
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:43:18.724
tkcrrxmp: Stopping ARC2 to reduce ARCH processes from 3 to 2
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:43:39.030
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:44:23.782
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:45:23.814
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:46:23.837
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:47:23.853
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:48:23.861
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:49:23.892
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:50:23.912
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:51:23.957
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:52:23.975
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:53:23.979
kcrrwkx: nothing to do (end)
*** 2008-01-17 16:54:24.005
Re: deletion of bdump .trc files [message #297121 is a reply to message #297119] Wed, 30 January 2008 03:52 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The way I handle it on my system, I have set up a job to get notified when any log or trace files shows up that contain "ORA-" somewhere, which would be most likely an error message, and delete everything else that is older than a month.
Re: deletion of bdump .trc files [message #297123 is a reply to message #297121] Wed, 30 January 2008 03:57 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thats fine.

And i will check out those errors in the file.

So it is safe to delete files before a month. Am i right?

Re: deletion of bdump .trc files [message #297128 is a reply to message #297123] Wed, 30 January 2008 04:18 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
It definitely has no effect on the running database.

You just don't have the ability to look at the files in case some problem turns up to have happened some time ago, and you no longer have the files for that time.

In my situation database related problems show up on my desk pretty quick, usually in a matter of minutes or at least days, so a month is quite enough for me.

If it's a database at a customer site that is only looked at once or twice a year then a longer period might be worth keeping.

You could always just zip them away to some archive if space is a problem, though.
Re: deletion of bdump .trc files [message #297129 is a reply to message #297128] Wed, 30 January 2008 04:27 Go to previous message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Perfect reply.
Thanks a lot.
Previous Topic: Flashback query(!?)
Next Topic: Confusion over DBA authentication
Goto Forum:
  


Current Time: Tue Dec 06 02:33:54 CST 2016

Total time taken to generate the page: 0.08333 seconds