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/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值