OraFAQ Forum: Server Administration » deletion of bdump .trc files

Home » RDBMS Server » Server Administration » deletion of bdump .trc files

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

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,

Report message to a moderator

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?

Report message to a moderator

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.

Code: [Select all] [Show/ hide]

*** 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

Report message to a moderator

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.

Report message to a moderator

Re: deletion of bdump .trc files [message #297123 is a reply to message #297121]

Wed, 30 January 2008 03:57

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?

Report message to a moderator

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.

Report message to a moderator

Re: deletion of bdump .trc files [message #297129 is a reply to message #297128]

Wed, 30 January 2008 04:27

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Perfect reply.
Thanks a lot.

Report message to a moderator

Previous Topic:	Flashback query(!?)
Next Topic:	Confusion over DBA authentication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 03 06:39:46 CDT 2025