user trace files

[naushi]

I am getting trace file in the udump directory so often. user is complaining that some of their updates (about 5%) do not make it. I checked the udump directory and found these trace files which are being generated every day and I am wondering what this has to do with the user. I would appreciate any help. a sample of one of the trace files (they are all the same) is below.

Dump file /ux086oracle/local/TDIRT/udump/ora_49080_tdirt.trc
Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
With the Partitioning option
JServer Release 8.1.7.1.0 - Production
ORACLE_HOME = /ux086oracle/8.1.7
System name: AIX
Node name: tmpux086
Release: 3
Version: 4
Machine: 000F645D4C00
Instance name: TDIRT
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 49080, image: oracle@tmpux086 (TNS V1-V3)

*** SESSION ID9.1431) 2002-04-10 00:32:17.887
*** 2002-04-10 00:32:17.887
# The following commands will create a new control file and use it
# to open the database.
# Data used by the recovery manager will be lost. Additional logs may
# be required for media recovery of offline data files. Use this
# only if the current version of all online logs are available.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "TDIRT" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 200
MAXINSTANCES 8
MAXLOGHISTORY 1134
LOGFILE
GROUP 1 (
'/ux086oraredo1/TDIRT/tdirtredo01.log',
'/ux086oraredo2/TDIRT/tdirtredo02.log'
) SIZE 10M,
GROUP 2 (
'/ux086oraredo1/TDIRT/tdirtredo03.log',
'/ux086oraredo2/TDIRT/tdirtredo04.log'
) SIZE 10M,
GROUP 3 (
'/ux086oraredo1/TDIRT/tdirtredo05.log',
'/ux086oraredo2/TDIRT/tdirtredo06.log'
) SIZE 10M
DATAFILE
'/ux086orasystem/TDIRT/tdirtsystem01.dbf',
'/ux086orasystem/TDIRT/tdirttools01.dbf',
'/ux086orarbs1/TDIRT/tdirtrbs01.dbf',
'/ux086orasystem/TDIRT/tdirttemp01.dbf',
'/ux086orasystem/TDIRT/tdirtusers01.dbf',
'/ux086oradata21/TDIRT/tdirttdird01.dbf',
'/ux086oradata21/TDIRT/tdirttdird02.dbf'
CHARACTER SET US7ASCII
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN;
# No tempfile entries found to add. Regards,
Naushi Hussain
Naushi.hussain@honeywell.com

 

[karluk]

These files look like the result of doing an "alter database backup controlfile to trace;" command. Your dba must be doing this as part of your database backup strategy. I don't think they have anything to do with the problems your users are having.