Site icon IT Tutorial

ORA-38760: This database instance failed to turn on flashback database and Drop Restore Point

When you startup Oracle Database, you can get ” ORA-38760: This database instance failed to turn on flashback database ” error.

 

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

 

When I startup Oracle database, I got following error.

[oracle@MehmetSalih ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue May 28 14:51:53 2019

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2.1379E+10 bytes
Fixed Size 2237776 bytes
Variable Size 8522828464 bytes
Database Buffers 1.2818E+10 bytes
Redo Buffers 36098048 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database

 

 

 

 

 

Try to disable Flashback and open database, or try to enable Flashback to see What is going on.

SQL> alter database flashback off;

Database altered.

SQL> 
SQL> 
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database


SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38714: Instance recovery required.

 

 

Database is not opened, so we need to drop restore point that is created in the past. Find it and drop this restore point like following.

 

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

NAME
--------------------------------------------------------------------------------
SCN GUA DATABASE_INCARNATION#
---------- --- ---------------------
RESTORE_POINT_17052019
5.9932E+12 YES 1


SQL> 
SQL> 

SQL> drop restore point RESTORE_POINT_17052019;

Restore point dropped.

 

After Restore point is dropped, we can open database like following.

 

SQL> alter database open;

Database altered.

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

Exit mobile version