ORA-38760: This database instance failed to turn on flashback database
Dear Experts,
we need your help.
Oracle database 2 node rac 19c
application R12.2.5
Unfortunately,my team mate deleted the flashback logs. We are unable to start the instance. We tried to drop the restore point but it errors out. This is UAT. Is there is anyway to bring up the 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. SQL> SQL> sho parameter recovery NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string +FRADG db_recovery_file_dest_size big integer 50G recovery_parallelism integer 0 remote_recovery_file_dest string SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +FRADG Oldest online log sequence 27 Next log sequence to archive 28 Current log sequence 28 SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ RESTORE POINT ONLY SQL> select NAME,SCN,GUARANTEE_FLASHBACK_DATABASE,DATABASE_INCARNATION# from v$restore_point; NAME -------------------------------------------------------------------------------- SCN GUA DATABASE_INCARNATION# ---------- --- --------------------- CLEAN_DB 5.9978E+12 YES 2 SQL> drop restore point CLEAN_DB; drop restore point CLEAN_DB * ERROR at line 1: ORA-38780: Restore point 'CLEAN_DB' does not exist. Completed: ALTER DATABASE MOUNT 2023-02-26T18:52:17.462697+05:30 ALTER DATABASE OPEN 2023-02-26T18:52:17.488871+05:30 Errors in file /u02/UAT19CBASE/diag/rdbms/uatcdb/uatcdb1/trace/uatcdb1_ora_17737.trc: ORA-38760: This database instance failed to turn on flashback database ORA-38760 signalled during: ALTER DATABASE OPEN... 2023-02-26T18:52:17.559249+05:30 ALTER SYSTEM SET remote_listener='