oracle问题解决ORA-01219

之前遇到过这个问题当时不知怎么解决就OK了今天又遇到半天才搞定参考网友的方法备忘

造成的原因是log被损坏

cmd > sqlplus

SQL> select group#sequence#archivedstatus from v$log;

GROUP# SEQUENCE# ARC STATUS

NO INACTIVE

NO INVALIDATED

NO INACTIVE

alter database clear logfile group ;

alter database clear logfile group ;

alter database clear logfile group ;

shutdown immediate;

startup mount;

SQL> select group#sequence#archivedstatus from v$log;

GROUP# SEQUENCE# ARC STATUS

NO CURRENT

NO UNUSED

NO UNUSED

alter database clear logfile group ;

alter database clear unarchived logfile group ;

alter database clear logfile group ;

alter database clear unarchived logfile group ;

alter database clear logfile group ;

alter database clear unarchived logfile group ;

shutdown;

startup mount;

alter database open;