| deletion of bdump .trc files [message #297113] |
Wed, 30 January 2008 03:26  |
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  |
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 |
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 |
ThomasG
Messages: 3212
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 #297128 is a reply to message #297123] |
Wed, 30 January 2008 04:18 |
ThomasG
Messages: 3212
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
