ORA-38726: Flashback database logging is not on.

Cause:

Flashback was not enabled and due to that flashback logs were not generated to recover the database to previous scn. But there is a guaranteed restore point created without flashback logging.

SQL> flashback database to scn 999545;
flashback database to scn 999545
*
ERROR at line 1:
ORA-38726: Flashback database logging is not on.

If i check the flashback status , it shows ‘ RESTORE POINT ONLY ‘

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
RESTORE POINT ONLY

Workaround:

Only option is to restore the database to previous restore point rather than specification of scn clause

SQL> flashback database to restore point A;

Flashback complete.

Open the database with resetlogs. Anyway you get the previous scn

SQL> alter database open resetlogs;

Database altered.

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
     999935

Leave a Reply