如果有看到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;