SOLVED

ORA-00392: Log 7 Of Thread 1 Is Being Cleared, Operation Not Allowed

Asked by OracleDba••13 views•oracle
1
2
3
4
5
6
7
ORA-00392: Log 7 Of Thread 1 Is Being Cleared, Operation Not Allowed

ORA-00392: Log 7 Of Thread 1 Is Being Cleared, Operation Not Allowed.

Problem :

I was cloning a database from RMAN backup. After completion of cloning, when I tried to open database with  RESETLOG it failed with ORA-00392 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
RMAN> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS

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

5 1 CLEARING

6 1 CLEARING

7 1 CLEARING_CURRENT ---------->>>

8 1 CLEARING

9 2 CLEARING_CURRENT 

10 2 CLEARING

11 2 CLEARING

12 2 CLEARING

[php]

Group 7 and 9 have status CLEARING_CURRENT. So clear them manually.

[php]

RMAN> alter database clear logfile group 7;

Statement processed

RMAN> alter database clear logfile group 9;

Statement processed

RMAN> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS

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

5 1 CLEARING

6 1 CLEARING

7 1 CURRENT

8 1 CLEARING

9 2 CURRENT

10 2 CLEARING

11 2 CLEARING

12 2 CLEARING

8 rows selected

Now no group is in clearing_current mode. Lets do resetlog again.

RMAN> alter database open resetlogs;

Database altered
OracleDba•

Post Your Solution