Archive

Archive for March, 2014

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x4)

March 13, 2014 Leave a comment

On the standby dataguardĀ  10.2.3 db, theĀ  xxxxx_mrp0_xxx.trc showed the messages when executing “alter system archive log crrent”

MRP: Prodding archiver at standby for thread 1 seq 45077
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x4)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x4)
MRP: Prodding archiver at standby for thread 2 seq 31006
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x4)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x4)

According to oracle support, it is a bug.( LGWR unconditionally writes to trace file ). The workaround solution is to set log_archive_max_proesses to high count. ( I set it to 10). The warning disappeared after the change.

Categories: Oracle Bug