合 数据泵导入卡住，等待事件wait for unread message on broadcast channel
👉 本文共约568个字，系统预计阅读时间或需3分钟。
现象
使用impdp导入数据文件，数据库为Oracle 19.15 标准版，结果卡在如下步骤：
1 | Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT |
在数据库中查询会话信息：
1 | select d.sid, d.sql_id,d.event,d.blocking_session from v$session d where d.username='SYSTEM' AND D.PROGRAM='impdp.exe'; |
等待事件为：“wait for unread message on broadcast channel”，执行的SQL语句为：
1 | BEGIN :1 := sys.kupc$que_int.get_status(:2, :3); END; |
分析
1、查询告警日志，报错“Private strand flush not complete”
1 2 3 4 5 6 7 8 9 10 | 2022-06-17T09:43:07.824203+08:00 Thread 1 advanced to log sequence 613 (LGWR switch), current SCN: 95218456 Current log# 3 seq# 613 mem# 0: E:\ORADATA\ORCL19C\REDO03.LOG 2022-06-17T09:43:49.839988+08:00 Thread 1 cannot allocate new log, sequence 614 Private strand flush not complete Current log# 3 seq# 613 mem# 0: E:\ORADATA\ORCL19C\REDO03.LOG 2022-06-17T09:43:52.840060+08:00 Thread 1 advanced to log sequence 614 (LGWR switch), current SCN: 95221553 Current log# 1 seq# 614 mem# 0: E:\ORADATA\ORCL19C\REDO01.LOG |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
