【ORA-38760】This database instance failed to turn on flashback database

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


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;
SQL> select name from v$restore_point;

SQL> drop restore point ;
SQL> alter database flashback off;
SQL> select flashback_on from v$database;
SQL> alter database open;

总结：从冷备恢复数据库，restore point的存在导致的无法打开闪回数据库。删除即可。   
btw：此类故障较为常见，网上很容易搜到解决办法，就不详细解释了；

2014-08-27
ocm6场景训练时；

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29319205/viewspace-1259688/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29319205/viewspace-1259688/