SOLVED

ORA-38774: Cannot Disable Media Recovery – Flashback Database Is Enabled

Asked by OracleDba••13 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
ORA-38774: Cannot Disable Media Recovery – Flashback Database Is Enabled

While disabling archive log mode, got the error – ORA-38774

SQL> alter database noarchivelog;

alter database noarchivelog

*

ERROR at line 1:

ORA-38774: cannot disable media recovery – flashback database is 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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
The error is because flashback mode is enabled in the database.

So before disabling archive log mode, we need to disable flashback mode in database and drop restore points if any.

1. Drop restore point if any :

SQL> Select name from v$restore_point;

NAME

------

BEFORE_UPGRADE

SQL> drop restore point BEFORE_UPGRADE;

Restore point dropped.

SQL> Select name from v$restore_point;

no rows selected

2 Disable flashback mode :

SQL> select name,flashback_on from v$database;

NAME FLASHBACK_ON

--------- ------------------

DBATEST YES

SQL> alter database flashback off;

Database altered.

SQL> select name,flashback_on from v$database;

NAME FLASHBACK_ON

--------- ------------------

DBATEST NO

3. Now try to put the database in noarchivelog mode.

SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 136

Current log sequence 138

Hope it Helps!
OracleDba•

Post Your Solution