Problem
Database open hangs after database duplication, or after switchover/failover operation.
Messages reported in alertlog:
TT04 (PID:339013): Sleep 640 seconds and then try to clear SRLs in 70 time(s)
Solution
This is a known bug fixed in 19.9 release
Workaround:
Apply Patch 31747989, or
SQL> alter system set "_min_undosegs_for_parallel_fptr"=0 scope=both sid='*';
and restart database
Reference:
- Bug 31747989 - tracking bug for dependent fixes of first-pass transaction recovery (Doc ID 31747989.8)
- After Switch /Failover Primary Instance Open hangs Because Of SRL Cleanup (Doc ID 2710349.1)
No comments:
Post a Comment