01219 oracle,oracle中ORA-01219错误的解决方法

oracle中ORA-01219错误的解决方法

来源：青年人(Qnr.Cn) 2009-11-24 20:07:30

造成的原因是log被损坏。

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;