ORA-38760: This database instance failed to turn on flashback database

jiawang

报错现象：
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
问题分析：
    该错误通过查看Metalink 后得知是由于Flash back信息不完整导致。

尝试关闭闪回
SQL> alter database flashback off;
Database altered.

再次打开数据库，依旧报错

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database


查看下闪回的状态
SQL>  select flashback_on from v$database;

FLASHBACK_ON
------------------
RESTORE POINT ONLY


SQL> select name from v$restore_point;

NAME
--------------------------------------------------------------------------------
UPDATE_RSP

SQL> drop restore point UPDATE_RSP;

Restore point dropped.

SQL> alter database flashback off;

Database altered.

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
NO

SQL> alter database open;

Database altered.

SQL>