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/