ora-01033和ora-01219

造成的原因是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;
shutdown;
startup mount;
alter database open;

done.

  • 本文作者: 帐前卒
  • 本文链接: http://chillyc.info/2009/4091501/
  • 版权声明: 本博客所有文章除特别声明外,只能复制超链接地址,且必须注明出处!