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

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

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

Error: ORA-38760 

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.


Solution A:

To Enable flashback:

1.Shutdown the database either in immediate or normal mode.

2.Mount the database.

3.Enable flashback. 

SQL>Alter database flashback on;

4.Open the database.

Sometimes even after solution A you are still getting errors:

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1.4798E+10 bytes
Fixed Size 2046472 bytes
Variable Size 671090168 bytes
Database Buffers 1.4110E+10 bytes
Redo Buffers 14729216 bytes
Database mounted.
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

SQL> 

Then you should apply solution B.

Solution B:

1. Startup mount.

2. Check db_recovery_file_dest parameter and ensure this directory exists.

3. Check restore points:

select NAME,SCN,GUARANTEE_FLASHBACK_DATABASE,DATABASE_INCARNATION# 
from v$restore_point;

4. Drop restore point:

Drop restore point ;

5. alter database flashback off;

6. Shutdown immediate;

7. Startup