Oracle数据库教程:ORA-01103错误解析
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle数据库教程:ORA-01103错误解析,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3808字,纯文字阅读大概需要6分钟。
内容图文
这是一测试库,我将参数文件,控制文件,数据文件全部删除之后,做数据恢复,但是我把控制文件和参数文件都恢复回来了,可数据库
1、环境介绍:
这是一测试库,我将参数文件,控制文件,数据文件全部删除之后,做数据恢复,但是
我把控制文件和参数文件都恢复回来了,可数据库却怎么也打不开,报ORA-01103: database name 'WWL' in control file is not 'DUMMY'错误
我的数据库名称是:WWL
2、执行过程:
恢复参数文件:
RMAN> setDBID=5520179
executing command: SET DBID
RMAN> restorespfile from autobackup;
Starting restore at 23-MAY-12
using target database control file insteadof recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=39 devtype=DISK
channel ORA_DISK_1: looking for autobackupon day: 20120523
channel ORA_DISK_1: autobackup found:c-5520179-20120523-04
channel ORA_DISK_1: SPFILE restore fromautobackup complete
Finished restore at 23-MAY-12
RMAN>
3、恢复控制文件
RMAN> restorecontrolfile from autobackup;
Starting restore at 23-MAY-12
using channel ORA_DISK_1
channel ORA_DISK_1: looking for autobackupon day: 20120523
channel ORA_DISK_1: autobackup found:c-5520179-20120523-04
channel ORA_DISK_1: control file restorefrom autobackup complete
output filename=/DBSoft/product/10.2.0/db_1/dbs/cntrlWWL.dbf
Finished restore at 23-MAY-12
RMAN>
4、报错信息:
RMAN> sql 'alterdatabase mount';
sql statement: alter database mount
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03009: failure of sql command ondefault channel at 05/23/2012 18:51:31
RMAN-11003: failure during parse/executionof SQL statement: alter database mount
ORA-01103: database name 'WWL' in controlfile is not 'DUMMY'
RMAN> alterdatabase mount;
using target database control file insteadof recovery catalog
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002: failure of alter db command at05/23/2012 18:39:47
ORA-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'
。
SQL> selectinstance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
WWL STARTED
alter database mount
*
ERROR at line 1:
ORA-01103: database name 'WWL' in controlfile is not 'DUMMY'
库:
问题是,我确定没有这个库呀,怎么办。。。
[Oracle@wwldb dbs]$rman target /
Recovery Manager: Release 10.2.0.1.0 -Production on Wed May 23 19:01:09 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DUMMY (notmounted)
RMAN> exit
我们刚才做了参数文件和控制文件的恢复,要不将数据库重启下,,看有没有问题。
SQL> shutdownimmediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startupmount;
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 79693416 bytes
Database Buffers 197132288 bytes
Redo Buffers 7168000 bytes
Database mounted.
再次登录正常。
[oracle@wwldb dbs]$rman target /
Recovery Manager: Release 10.2.0.1.0 -Production on Wed May 23 19:04:15 2012
Copyright (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 专题页面 ?tid=12
内容总结
以上是互联网集市为您收集整理的Oracle数据库教程:ORA-01103错误解析全部内容,希望文章能够帮你解决Oracle数据库教程:ORA-01103错误解析所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。