Database Administration (MOSC)

MOSC Banner

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

edited Feb 26, 2023 1:59PM in Database Administration (MOSC) 5 commentsAnswered ✓

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='

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center