RMAN large trace (*.trc) file generate in Oracle 12c
Error
Large trace file generated by RMAN utility in Oracle 12c Environment.
On doing the health checkup of Oracle 12c 12102 version database, i found large trace files is generated in diag/rdbms location.
The size of folder is around 30 GB size.
On checking the db, no trace is enabled at database level. Then checked the trace file by open in notepad editor.
Its related to RMAN utility used for taking hot backup in our database environment.
Example of trace file:
*** 2019-11-20 20:00:02.893
*** SESSION ID:(2279.11206) 2019-11-20 20:00:02.893
*** CLIENT ID:() 2019-11-20 20:00:02.893
*** SERVICE NAME:(ic) 2019-11-20 20:00:02.893
*** MODULE NAME:(rman.exe) 2019-11-20 20:00:02.893
*** CLIENT DRIVER:() 2019-11-20 20:00:02.893
*** ACTION NAME:() 2019-11-20 20:00:02.893
2019-11-20 20:00:02.893473*:KRB:krbi.c@8473:krbitrc(): Got krbitrc
2019-11-20 20:00:02.894941*:KRB:krbi.c@8503:krbiwtrc(): (bkrsmain - Action is NULL)
*** ACTION NAME:(0000001 STARTED70) 2019-11-20 20:00:02.893
2019-11-20 20:00:02.894941*:KRB:krbi.c@8503:krbiwtrc(): (icdstart - Action set to 0000001 STARTED70)
*** ACTION NAME:(0000001 FINISHED70) 2019-11-20 20:00:02.893
*** 2019-11-20 20:00:03.315
2019-11-20 20:00:03.315364*:KRB:krbi.c@7226:krbicrsr(): Got krbicrsr
2019-11-20 20:00:03.328246*:KRB:krbm.c@5725:krbmcrsr(): created; recid=2573
2019-11-20 20:00:03.362233*:KRB:krbi.c@7418:krbicror(): Got krbicror
2019-11-20 20:00:03.362233*:KRB:krbm.c@6028:krbmcror(): ; sameline=0
2019-11-20 20:00:03.362233*:KRB:krbm.c@6200:krbmcror(): allocate rowset; rowset->used_krbmror=0
2019-11-20 20:00:03.362233*:KRB:krbm.c@6208:krbmcror(): update rowset output; rowset->used_krbmror=0
Solution
1. Disable the Trace by Alter command
Alter system set events 'trace[krb.*] disk disable, memory disable';
2. Restart the Database.
Shutdown immediate
Startup
You can also set in PFILE and generate spfile from pfile:
event='trace[krb.*] disk disable, memory disable'
Smart way of Technology 