You may get ORA-38706: Cannot turn on FLASHBACK DATABASE logging while enabling flashback


SQL> alter database flashback on;
alter database flashback on
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38709: Recovery Area is not enabled.




  1. Put database in archivelog mode , if not

            How to enable archivelog mode 


Set  db_recovery_file_dest and  db_recovery_file_dest_size parameter.

SQL> alter system set db_recovery_file_dest_size=10g scope=spfile;

System altered.

SQL> alter system set db_recovery_file_dest='/u01/arch' scope=spfile;

system altered.

SQL>SQL> startup force;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 5346328576 bytes
Fixed Size                  3862648 bytes
Variable Size            3623882632 bytes
Database Buffers         1577058304 bytes
Redo Buffers              141524992 bytes
Database mounted.
Database opened


Now enable flashback

SQL> alter database flashback on;

Database altered.

SQL>  select flashback_on from v$database;





How to use flashback queries