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/