SOLVED

ORA-38706: Cannot Turn On FLASHBACK DATABASE Logging.

Asked by OracleDba10 viewsoracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
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

Hope it Helps!
OracleDba

Post Your Solution