oracle的ORA-01143錯誤：cannot disable media recovery

今天一台伺服器的開啟了歸檔，導致檔案系統撐滿了，由於我們是開發庫，沒必要開啟歸檔，所以就把資料庫改為非歸檔模式，但是在修改的時候碰到ORA-01143: cannot disable media recovery - file 20 needs media recovery錯誤。後來將資料檔案恢複後才將資料庫修改成功。

下面為操作過程

SQL> shutdown immediate;  Database closed.  Database dismounted.  ORACLE instance shut down.  SQL>   SQL>   SQL> startup mount  ORACLE instance started.       Total System Global Area  630521856 bytes  Fixed Size                  2146992 bytes  Variable Size             369102160 bytes  Database Buffers          251658240 bytes  Redo Buffers                7614464 bytes  Database mounted.  SQL>   SQL>   SQL> alter database noarchivelog;  alter database noarchivelog  *  ERROR at line 1:  ORA-01143: cannot disable media recovery - file 20 needs media recovery  ORA-01110: data file 20: '/home/oracle/oradata/orarpt/vms_rpt.dbf'          SQL> recover datafile 20  ORA-00279: change 1162349663 generated at 11/22/2011 00:03:58 needed for thread  1  ORA-00289: suggestion :  /home/oracle/product/11.1.0/db_1/dbs/arch1_4578_743881575.dbf  ORA-00280: change 1162349663 for thread 1 is in sequence #4578       更多精彩內容：http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/Specify log: {<RET>=suggested | filename | AUTO | CANCEL}  Log applied.  Media recovery complete.                 SQL> alter database noarchivelog;       Database altered.            alter database datafile 20 online;                 SQL> alter database open;       Database altered.

本文出自 “richard的筆記-積微成著” 部落格，請務必保留此出處http://zxf261.blog.51cto.com/701797/729149