这是一测试库,我将参数文件,控制文件,数据文件全部删除之后,做数据恢复,但是我把控制文件和参数文件都恢复回来了,可数据库
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