Hi,
Sometimes You can get ” ORA-38714: Instance recovery required. ” error.
Details of error are as follows.
ORA-38714: Instance recovery required.
Cause: An ALTER DATABASE FLASHBACK ON command failed because the database either crashed or was shutdown with the ABORT option.
Action: Open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE option.
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.
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/