ORA-38760: This database instance failed to turn on flashback database

brightking716發表於2010-12-20
DatabaseAI

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章