BUG 23300142 – Redo Transport Slave Process

A semana começou com o filesystem /u01 alarmando ocupação elevada. Iniciei então uma investigação para encontrar o que estava ocupando o disco.

My week started with a filesystem high occupation alarm. I then started looking for what was going on.

Utilizei o comando find abaixo para buscar por arquivos grandes:

I usually use the find command bellow to search for huge files:

find / -type f -size +800M -exec ls -lh {} \; | awk '{ print $NF ": " $5 }'

Bingo! encontrei o arquivo de trace do processo TT01 (Redo Transport Slave Process) consumindo 6Gb !

Yes ! found a trace file from process TT01 (Redo Transport Slave Process) consuming 6 Gb!

Olhando o conteúdo do arquivo, a mensagem:

Looking at the contents of the trace file the messages:

Error in determining current logfile for thread 1
ASYNC ignored current log: KCCLENAL clear thread open

era repetida continuamente.

was happening on an on.

Uma pesquisa rápida no MOS e confirmado mais um BUG para coleção: Bug 23300142 – TT background process trace file message: async ignored current log: kcclenal clear thread open (Doc ID 23300142.8)

A quick search on MOS and I have hit another BUG for my collection: Bug 23300142 – TT background process trace file message: async ignored current log: kcclenal clear thread open (Doc ID 23300142.8)

A correção está disponível nos patches:

Bug fix is included on patches:

12.2.0.1.170919 (Sep 2017) Database Release Update (DB RU)
12.1.0.2.180116 (Jan 2018) Database Proactive Bundle Patch
12.2.0.1.171017 (Oct 2017) Bundle Patch for Windows Platforms

 

Author: reguchi

Oracle OCP 11g/12c, Oracle OCE Exadata, MySQL DBA, RHCE, technology geek, homebrewer, dad

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