Oracle数据库教程：ORA-01103错误解析

1、环境介绍：这是一测试库，我将参数文件，控制文件，数据文件全部删除之后，做数据恢复，但是我把控制文件和参数文件都恢复回来了，可数据库却怎么也打不开，报ORA-01103: database name "WWL" in control file is not "DUMMY"错误我的数据库名称是:WWL2、执行过程：恢复参数文件：RMAN> setDBID=5520179executing command: SET DBIDRMAN> restorespfile from autobackup;Starting restore at 23-MAY-12using target database control file insteadof recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=39 devtype=DISK channel ORA_DISK_1: looking for autobackupon day: 20120523channel ORA_DISK_1: autobackup found:c-5520179-20120523-04channel ORA_DISK_1: SPFILE restore fromautobackup completeFinished restore at 23-MAY-12RMAN> 3、恢复控制文件RMAN> restorecontrolfile from autobackup; Starting restore at 23-MAY-12using channel ORA_DISK_1 channel ORA_DISK_1: looking for autobackupon day: 20120523channel ORA_DISK_1: autobackup found:c-5520179-20120523-04channel ORA_DISK_1: control file restorefrom autobackup completeoutput filename=/DBSoft/product/10.2.0/db_1/dbs/cntrlWWL.dbfFinished restore at 23-MAY-12 RMAN> 4、报错信息：RMAN> sql "alterdatabase mount";sql statement: alter database mountRMAN-00571:===========================================================RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============RMAN-00571:===========================================================RMAN-03009: failure of sql command ondefault channel at 05/23/2012 18:51:31RMAN-11003: failure during parse/executionof SQL statement: alter database mountORA-01103: database name "WWL" in controlfile is not "DUMMY" RMAN> alterdatabase mount;using target database control file insteadof recovery catalogRMAN-00571:===========================================================RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============RMAN-00571:===========================================================RMAN-03002: failure of alter db command at05/23/2012 18:39:47ORA-01103: database name "WWL" in controlfile is not "DUMMY" SQL> alterdatabase mount;alter database mount ERROR at line 1:ORA-01103: database name "WWL" in controlfile is not "DUMMY" 注意：问题是我恢复的控制文件没有错呀，在本机器上也没有部署过DUMMY的数据库呀，只有一个实例是WWL。 查询实例信息，实例信息显示没有错呀是WWL。SQL> selectinstance_name,status from v$instance; INSTANCE_NAME STATUS---------------- ------------WWL STARTED SQL> alterdatabase mount; ----顺便执行了下mount database;alter database mount*ERROR at line 1:ORA-01103: database name "WWL" in controlfile is not "DUMMY" 奇怪的事发生了，现在再次登录到RMAM居然连接到的是DUMMY库：问题是，我确定没有这个库呀，怎么办。。。 [Oracle@wwldb dbs]$rman target /Recovery Manager: Release 10.2.0.1.0 -Production on Wed May 23 19:01:09 2012Copyright （c） 1982, 2005, Oracle. All rights reserved.connected to target database: DUMMY （notmounted）RMAN> exit 我们刚才做了参数文件和控制文件的恢复，要不将数据库重启下，看有没有问题。SQL> shutdownimmediateORA-01507: database not mountedORACLE instance shut down.SQL> startupmount;ORACLE instance started.Total System Global Area 285212672 bytesFixed Size 1218968 bytesVariable Size 79693416 bytesDatabase Buffers 197132288 bytesRedo Buffers 7168000 bytesDatabase mounted.再次登录正常。[oracle@wwldb dbs]$rman target /Recovery Manager: Release 10.2.0.1.0 -Production on Wed May 23 19:04:15 2012Copyright （c） 1982, 2005, Oracle. All rights reserved.connected to target database: WWL（DBID=5520179, not open）这个问题我一兄弟在AIX，Linux，Windows 上分别做实验了，结果是在Windows下不用重启数据库，Rman就可以认到，而不会是DUMMY数据库。B，每小时执行一次，整点执行interval => "trunc（sysdate,"HH"）+1/24"C，一个小时后执行interval => "sysdate+1/24"更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12MySQL中的auto_increment的问题探索Oracle之RMAN_03非一致性备份相关资讯 oracle数据库教程

Oracle raw数据类型介绍（01/29/2013 10:05:53）
监听器注册与ORA-12514 错误分析（11/13/2012 14:30:08）
Oracle SQL的cursor理解（11/13/2012 14:16:17）

Oracle 如何强制刷新Buffer Cache （01/29/2013 10:02:46）
dblink致Oracle库的SCN变成两库的（11/13/2012 14:24:41）
Linux操作系统下完全删除Oracle数（11/13/2012 08:25:52）

本文评论查看全部评论（0）