- 03 Dec, 2023
- 0 Comments
- 44 Secs Read
ORA-38706: Cannot Turn On FLASHBACK DATABASE Logging.
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 2. 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> 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