造成的原因是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.