ORA-38760: This database instance failed to turn on flashback database
SQL> alter database open;
ORA-38760: This database instance failed to turn on flashback database
$ vi alert_shenzhen.log
Errors in file /u01/admin/shenzhen/bdump/shenzhen_rvwr_29531.trc:
396 ORA-38701: Flashback database log 6 seq 5842 thread 1: "/u01/flash_recovery_area/SHENZHEN/flashback/o1_mf_6j4dn337_.flb"
397 ORA-27037: unable to obtain file status
398 Linux Error: 2: No such file or directory
$ vi shenzhen_rvwr_29531.trc
17 ORA-38701: Flashback database log 6 seq 5842 thread 1: "/u01/flash_recovery_area/SHENZHEN/flashback/o1_mf_6j4dn337_.flb"
18 ORA-27037: unable to obtain file status
19 Linux Error: 2: No such file or directory
20 Additional information: 3
原因是：删除了flashback文件，在database open的时候turn on flashback database失败， 故将database flashback属性先置为off.
SQL> alter database flashback off;
Database altered.
SQL> alter database open;
Database altered.
如果open过程还有错误，请参照一下文章：
ORA-38760: This database instance failed to turn on flashback database
：
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
SQL> alter database flashback off;
SQL> select flashback_on from v$database;
SQL> alter database open;
Reference: http://hi.baidu.com/anydb/blog/item/3b090cad4fde4af7fbed508f.html
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12472709/viewspace-1043347/ ，如需转载，请注明出处，否则将追究法律责任。
