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

前言：一个礼拜没有搭理我的数据库服务器，回来查看发现如下问题，经过多方查找，发现解决方案，特此收集整理一下，以备后用.

文章参考来源：http://space.itpub.net/15843490/viewspace-580677 

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

      今天重启 数据库的时候，发现如下错误：

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

       数据库环境： linux  64x86 +   oracle  10.2.3

       在metalink找到解决方法，过程表达的很详细：

Subject:  Unable To Turn Off Database Flashback
  Doc ID:  Note:416929.1

Symptoms

there are problems with flashback database, however, unable to turn off flashback database so that
the database can be opened:
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
.

Cause

there is a restore point in the database

checked v$restore_point
.

Solution

check whether restore points exist:
SQL> select flashback_on from v$database;
SQL> select name from v$restore_point;

If so, drop them:
SQL> drop restore point <name>;
SQL> alter database flashback off;
SQL> select flashback_on from v$database;
SQL> alter database open;

      总结，手工创建 flashback 的 restore_point 要小心，过了一段时间，要及时删除。

转载于:https://www.cnblogs.com/arcer/archive/2013/05/27/3100974.html