Oracle数据库服务器磁盘满导致数据库无法登陆,通过清理归档文件解决(二)

2014-11-24 18:44:07 · 作者: · 浏览: 1
ecification does not match any archive log in the recovery catalog


如果有看到specification does not match any archive log in the recovery catalog返回信息,那说明数据库已经正常了。


8。退出rman,登陆oracle数据库改归档模式为到非归档模式


RMAN> exit

Recovery Manager complete.
[oracle@dev2_180db archive]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 12 01:11:38 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options



SQL>shutdown immediate;


SQL>start mount;


SQL>alter database noarchivelog;


SQL>alter database open;