oracle控制版本不一致,oem linux 11g r2 asm 控制文件 版本不一致

本帖最后由 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)

该如何 解决?

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值