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