ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
Symptom:
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38707: Media recovery is not enabled.
SQL> show parameter recovery
NAME TYPE VALUE
———————————— ———– ——————————
db_recovery_file_dest string +FLASH
db_recovery_file_dest_size big integer 16G
recovery_parallelism integer 0
remote_recovery_file_dest string
Solution:
alter database archivelog;
alter database flashback on;