RMAN large trace (*.trc) file generate in Oracle 12c

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'

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.