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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s