My Oracle Support Banner

After Switch /Failover Primary Instance Open hangs Because Of SRL Cleanup (Doc ID 2710349.1)

Last updated on OCTOBER 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

2020-08-22T16:22:20.172813+02:00
TT05 (PID:339034): SRL selected for T-2.S-7297 for LAD:2
2020-08-22T16:22:21.167782+02:00
TT04 (PID:339013): Sleep 10 seconds and then try to clear SRLs in 3 time(s)
2020-08-22T16:22:31.171341+02:00
TT04 (PID:339013): Sleep 20 seconds and then try to clear SRLs in 4 time(s)
2020-08-22T16:22:51.174015+02:00
TT04 (PID:339013): Sleep 40 seconds and then try to clear SRLs in 5 time(s)
2020-08-22T16:23:31.177369+02:00
TT04 (PID:339013): Sleep 80 seconds and then try to clear SRLs in 6 time(s)
2020-08-22T16:24:48.513050+02:00

Chain 1

 

is waiting for 'row cache lock' with wait info:

current sql: update /*+ rule */ undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12,spare1=:13 where us#=:1

short stack: ksedsts()+426<-ksdxfstk()+58<-ksdxcb()+872<-sspuser()+200<-__sighandler()<-epoll_wait()+19<-ipcor_wseti_wait()+94<-ipclw_wait()+520<-ksxpwait_ipclw()+920<-ksxpwait_int()+155<-ksxpwait()+319<-ksliwat()+2321<-kslwaitctx()+188<-kjusuc()+5580<-ksipgetctxia()+1968<-ksixpgetia()+124<-kqrInstanceLock()+667<-kqrGetClusterLock()+2547<-kqrLockPo()+407<-kqrpre2()+1106<-kqrpre1()+40<-ktuGetRowCache1()+82<-ktuGetUsegDba()+589<-ktuGetCommitTimesMain_Int()+626<-ktuGetCommitTimesMain()+542<-ktuGetCommitTimes()+149<-ktbgcl1()+2614

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.