一、现象说明
$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 18 16:49:19 2024
Version 19.11.0.0.0Copyright (c) 1982, 2020, Oracle. All rights reserved.Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0SQL> conn Test/Oracle123 ---一直hang在这里
二、处理方法
SQL> select flashback_on from v$database;FLASHBACK_ON
------------------
YESSQL> select name from v$restore_point;NAME
---------------------------------------------------------
AUTOUPGRADE_9212_WIND2121020SQL> drop restore point AUTOUPGRADE_9212_WIND2121020;Restore point dropped.SQL> alter database flashback off;Database altered.
此时 Test 用户可以连接了。
附录（实际处理过程记录）：
SQL> select name,open_mode from v$database;NAME OPEN_MODE
--------- --------------------
STUDY READ WRITESQL> select flashback_on from v$database;FLASHBACK_ON
------------------
YESSQL> alter database flashback off;Database altered.SQL> select flashback_on from v$database ;FLASHBACK_ON
------------------
RESTORE POINT ONLYSQL> select name from v$restore_point;NAME
---------------------------------------------------------
AUTOUPGRADE_9212_WIND2121020SQL> drop restore point AUTOUPGRADE_9212_WIND2121020;Restore point dropped.SQL> alter database flashback off;Database altered.SQL> select flashback_on from v$database;FLASHBACK_ON
------------------
NO
