ORA-38714: Instance recovery required.

Hi,

Sometimes You can get ” ORA-38714: Instance recovery required.  ” error.

Details of error are as follows.

ORA-38714: Instance recovery required.

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/