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


Sql> altere database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
Solution1: Delete Unneeded files
Rman> delete obsolete;
Solution2: Increase Space
Sql>alter system set db_recovery_file_dest_size=30G;
Solution3: Remove Restore Points
Sql>select name,storage_size from v$restore_point;
NAME                    Storage_Size
----------------- --------------------------
GRP1                       0 
GRP2                  52428800 
GRP3                    52428800
RP1                         0
Rp2                       0
Sql> drop restore pint grp2;
Restore point dropped.
Sql> drop restore pint grp3;
Restore point dropped.
Solution4: Disabe Flashback
Sql> alter database flashback off;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: