Oracle ORA-01143 Error: Cannot disable media recovery

Today, a server opened the archive, resulting in a full file system, because we are a development library, no need to open the archive, so we changed the database to a non-archive mode, but at the time of the change encountered ora-01143:cannot disable Media recovery-file 20 Needs media recovery error. The data file was later restored before the database was modified successfully.

The following is an operation procedure

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 36910216  
0 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 needs media recove Ry Ora-01110:data file: '/home/oracle/oradata/orarpt/vms_rpt.dbf ' sql> recover datafile 9:change 1162349663 generated at 11/22/2011 00:03:58 needed for thread 1 ora-00289:suggestion:/home/oracle/produ CT/11.1.0/DB_1/DBS/ARCH1_4578_743881575.DBF ora-00280:change 1162349663 for thread 1 be in sequence #4578 more highlights Capacity: http://www.bianceng.cnhttp://www.bianceng.cn/database/oracle/specify log: {<ret>=suggested | AUTO |  
CANCEL} Log applied.  
     
     
     
Media recovery complete.  
     
sql> ALTER DATABASE Noarchivelog;  
     
     
Database altered.  
     
     
     
ALTER DATABASE datafile online;  
     
sql> ALTER DATABASE open; Database altered.

This article is from "Richard's notes-accumulate micro Cheng" blog, please be sure to keep this source http://zxf261.blog.51cto.com/701797/729149