熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

oracle問題解決ORA-01219

2013-11-13 15:28:05  來源: Oracle 

  之前遇到過這個問題當時不知怎麼解決就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
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.