Shulou(Shulou.com)06/01 Report--

Problem description:

The master-slave synchronization interval is very short, only a few seconds, but there are many applied='CURRENT', logs in dba_logstdby_log that were still applied='CURRENT' a few days ago.

Select * from V$DATAGUARD_STATS

Select t WHERE t WHERE t.CURRENT` order by t.first_time ASc

Cause analysis:

The main library has transactions that do not end for a long time.

SELECT t.STATUSret.STARTRETIMEret.XIDUSNrecot t.XIDSLOTpart. XIDSQN.MACHINErese.MODULERESE.USERNAMErese.STATUStitle se.EVENTParent se.SQLexamples ExectorSTART.se.* FROM v$transaction treasting vrecording session se WHERE t.ADDR=se.TADDR ORDER BY t.START_TIME

Solution:

According to the query results of the previous step, kill dropped transactions that did not end for a long time.

Alter system kill session''

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.