数据库在startup时,提示ORA-38760: This database instance failed to turn on flashback database错误,该错误大概意思是说数据库启用闪回数据库功能失败,造成这种情况的原因是数据库之前开启了闪回数据库功能,但是闪回数据库的备份文件被删除,所以数据库在打开时,无法找到这些文件导致数据库无法open。
解决方法很简单:先将数据库闪回数据库功能停用再启用就可
SQL> startup
ORACLE instance started.
Total System Global Area 784998400 bytes
Fixed Size 2257352 bytes
Variable Size 478154296 bytes
Database Buffers 301989888 bytes
Redo Buffers 2596864 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database
SQL> alter database flashback off;
Database altered.
SQL> alter database flashback on;
Database altered.
SQL> alter database open;
Database altered.