处理过程如下:
1、查询数据库存在闪回点UAT_20200527
SQL> SELECT name, guarantee_flashback_database, scn FROM v$restore_point
NAME
--------------------------------------------------------------------------------
GUA SCN
--- ----------
UAT_20200527
YES 26788149
2、删除闪回点UAT_20200527
SQL> drop restore point UAT_20200527;
Restore point dropped.
3、再次关闭闪回和归档后正常。
SQL> shutdown immediate
SQL> startup mount
SQL> ALTER DATABASE FLASHBACK OFF;
SQL> ALTER DATABASE NOARCHIVELOG;
SQL> alter database open;