Ora-38760:this database instance failed to turn on flashback database

Ora-38760:this database instance failed to turn on flashback database

Issue background:
Test database execution shutdown immediate, log inside error message: Ora-19815:warning:db_recovery_file_dest_size of 4322230272 bytes is 99.77% Used, and has 9814016 remaining bytes available.
I then executed the startup force mount and forced the database to shut down and boot into Mount state, and the database error ORA-38760 was started after Rman had deleted the historical backup and archived information.

problem Phenomenon:

Sql> Startup Mount;oracle instance started. Total System Global area 2872786944 bytesfixed size                  2256712 bytesvariable size            2634023096 bytesdatabase buffers< c2/>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 FLASHB ACK Database

Problem Analysis:
This error is due to the incomplete flash back information after viewing Metalink.

[Email protected] ~]$ Oerr or 38760oerr:unknown facility ' or ' [[email protected] ~]$ oerr ora 3876038760, 00000, "This Da Tabase instance failed to turn on flashback database "//*cause:database flashback are 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.
   

Workaround:

#1, close Flash backup again open databasesql> ALTER DATABASE flashback off; sql> ALTER DATABASE open; #2, another way to shut down databases directly before starting is also possible sql> startup Force Mount;oracle instance started. Total System Global area 2872786944 bytesfixed size                  2256712 bytesvariable size            2634023096 bytesdatabase buffers< c2/>218103808 Bytesredo buffers               18403328 bytesdatabase mounted. sql> ALTER DATABASE Open;database altered. Sql>

Ora-38760:this database instance failed to turn on flashback database