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

问题背景:

       測试数据库运行shutdown immediate，日志里面报错，错误信息为：ORA-19815: WARNING: db_recovery_file_dest_size of 4322230272 bytes is 99.77% used, and has 9814016 remaining bytes available.

       随即我运行startup force mount将数据库强制关闭并启动到mount状态，通过RMAN把历史备份和归档信息都删除后启动数据库报错ORA-38760.

问题现象：

SQL> startup mount;ORACLE instance started.Total System Global Area 2872786944 bytesFixed Size                  2256712 bytesVariable Size            2634023096 bytesDatabase Buffers          218103808 bytesRedo Buffers               18403328 bytesDatabase mounted.SQL> alter database open;alter database open*ERROR at line 1:ORA-38760: This database instance failed to turn on flashback database

问题分析：

    该错误通过查看Metalink 后得知是由于Flash back信息不完整导致。

[oracle@db01 ~]$ oerr or 38760oerr: Unknown facility 'or'[oracle@db01 ~]$ oerr ora 3876038760, 00000, "This database instance failed to turn on flashback database"// *Cause: Database flashback is on but this instance failed to//         start generating flashback data. Look in alert log for more//         specific errors.// *Action: Correct the error or turn off database flashback.

解决的方法：

#1、关闭flash backup再open databaseSQL> alter database flashback off;SQL> alter database open;#2、第二种办法直接关闭数据库后再启动也是能够的SQL> startup force mount;ORACLE instance started.Total System Global Area 2872786944 bytesFixed Size                  2256712 bytesVariable Size            2634023096 bytesDatabase Buffers          218103808 bytesRedo Buffers               18403328 bytesDatabase mounted.SQL> alter database open;Database altered.SQL>