SOLVED

ORA-38880: Cannot Advance Compatibility From 12.1.0.2.0 To 12.2.0.1.0 Due To Guaranteed Restore Points

Asked by OracleDba••12 views•oracle
1
2
3
4
5
ORA-38880: Cannot Advance Compatibility From 12.1.0.2.0 To 12.2.0.1.0 Due To Guaranteed Restore Points

Problem :

After Successful Database Upgradation, I tried to update the compatible parameter and restart the database. I got this error.
#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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
The error is because, I have enabled flashback and created a guaranteed restore point, before the upgrade. So while trying to update the compatible parameter, it is not allowing. Because ,once compatible parameter is changed, we can’t downgrade.

To fix it, we need to drop the restore point.

Follow the below steps:

SQL> alter system set compatible="12.1.0.2.0" scope=spfile;

System altered.

SQL> startup force

ORACLE instance started.

Total System Global Area 1.4663E+10 bytes

Fixed Size 15697000 bytes

Variable Size 8455723928 bytes

Database Buffers 6140461056 bytes

Redo Buffers 51404800 bytes

Database mounted.

Database opened.

Check the flashback restore point and drop it:

SQL> select GUARANTEE_FLASHBACK_DATABASE,NAME from v$restore_point;

GUARANTEE_FLASHBACK_DATABASE NAME

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

YES GRP_1457629236734

SQL> select flashback_On from v$database;

FLASHBACK_ON

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

YES

SQL> alter database flashback off;

Database altered.

SQL> select flashback_On from v$database;

FLASHBACK_ON

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

RESTORE POINT ONLY

SQL> drop restore point GRP_1457629236734;

Restore point dropped.

SQL> select flashback_On from v$database;

FLASHBACK_ON

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

NO

Now update the compatible parameter in spfile and restart.

SQL> show parameter comp

NAME TYPE VALUE

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

cell_offload_compaction string ADAPTIVE

compatible string 12.1.0.2.0

db_index_compression_inheritance string NONE

nls_comp string BINARY

noncdb_compatible boolean FALSE

plsql_v2_compatibility boolean FALSE

SQL> alter system set compatible="12.2.0.1" scope=spfile;

System altered.

SQL> startup force;

ORACLE instance started.

Total System Global Area 1.4663E+10 bytes

Fixed Size 15697000 bytes

Variable Size 8455723928 bytes

Database Buffers 6140461056 bytes

Redo Buffers 51404800 bytes

Database mounted.

Database opened.

SQL> show parameter comp

NAME TYPE VALUE

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

cell_offload_compaction string ADAPTIVE

compatible string 12.2.0.1

db_index_compression_inheritance string NONE

nls_comp string BINARY

noncdb_compatible boolean FALSE

plsql_v2_compatibility boolean FALSE
OracleDba•

Post Your Solution