本帖最后由 kongkongde 于 2013-10-24 14:23 编辑
因意外断电,造成控制文件不一致。
oem linux rac 11g r2 ,已停止所有节点 oracle 实例。
只在一个节点 nomount 模式开启。
报错信息
SQL> startup
ORACLE instance started.
Total System Global Area 3.9685E+10 bytes
Fixed Size 2236848 bytes
Variable Size 6039801424 bytes
Database Buffers 3.3554E+10 bytes
Redo Buffers 88227840 bytes
ORA-00214: control file '+DATA/zhdb/controlfile/current.260.812281505' version
4392751 inconsistent with file '+FLASH/zhdb/controlfile/current.256.812281505'
version 4392745
SQL> startup nomount
ORACLE instance started.
Total System Global Area 3.9685E+10 bytes
Fixed Size 2236848 bytes
Variable Size 6039801424 bytes
Database Buffers 3.3554E+10 bytes
Redo Buffers 88227840 bytes
SQL> exit
[oracle@hhoradb1 ~]$ rman target/
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Oct 24 14:11:59 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZHDB (not mounted)
RMAN> restore controlfile to '+FLASH/zhdb/controlfile' from '+DATA/zhdb/controlfile/current.260.812281505';
Starting restore at 2013/10/24 14:12:22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=570 instance=ZHDB1 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/24/2013 14:12:24
ORA-19504: failed to create file "+FLASH/zhdb/controlfile"
ORA-17502: ksfdcre:3 Failed to create file +FLASH/zhdb/controlfile
ORA-15113: alias name 'CONTROLFILE' refers to a directory
ORA-19600: input file is control file (+DATA/zhdb/controlfile/current.260.812281505)
ORA-19601: output file is control file (+FLASH/zhdb/controlfile)
该如何 解决?