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.

[@more@]

如果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博客 ” ，链接：http://blog.itpub.net/12472709/viewspace-1043347/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12472709/viewspace-1043347/