数据库开启了闪回和归档，关闭归档日志alter database noarchivelog的时候报错：ORA-38781: cannot disable media recovery

处理过程如下：

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;