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;

From:http://tw.wingwit.com/Article/program/Oracle/201311/16766.html