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

Problem:

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.

 

solution:

 

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;

FLASHBACK_ON
------------------
YES

 

SEE  ALSO:

how-to-enable-and-disable-flashback-in-oracle-database

How to use flashback queries