Ora-01033和ora-01219

Posted on Edited on Word count in article: 785 Reading time ≈ 1 mins.

造成的原因是log被损坏。

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
cmd -> sqlplus  
SQL> select group#,sequence#,archived,status from v$log;  
  
GROUP#  SEQUENCE# ARC STATUS  
\---------- ---------- --- ----------------  
1         86 NO  INACTIVE  
2         87 NO  INVALIDATED  
3         85 NO  INACTIVE  
  
alter database clear logfile group 1;  
alter database clear logfile group 2;  
alter database clear logfile group 3;  
shutdown immediate;  
startup mount;  
SQL> select group#,sequence#,archived,status from v$log;  
GROUP#  SEQUENCE# ARC STATUS  
\---------- ---------- --- ----------------  
1         88 NO  CURRENT  
2          0 NO  UNUSED  
3          0 NO  UNUSED  
alter database clear logfile group 1;  
alter database clear unarchived logfile group 1;  
alter database clear logfile group 2;  
alter database clear unarchived logfile group 2;  
alter database clear logfile group 3;  
alter database clear unarchived logfile group 3;  
shutdown;  
startup mount;  
alter database open;

done.