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

kongkongde

因意外断电，造成控制文件不一致。
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)

该如何 解决？

Maclean Liu(刘相兵

restore controlfile to '+FLASH/zhdb/controlfile' from '+DATA/zhdb/controlfile/current.260.812281505';

不要这么搞，直接 asmcmd cp 一份current.260.812281505 即可

ps： 没有给出版本信息， 11gR2不是有效的版本信息！

xifenfei

这样的故障，建议修改spfile，每次使用一个控制文件尝试，先open库，然后再处理，免得做无用功

kongkongde

Maclean Liu(刘相兵 发表于 2013-10-24 14:39
restore controlfile to '+FLASH/zhdb/controlfile' from '+DATA/zhdb/controlfile/current.260.812281505 ...

感谢回答。
版本为 11.2.0.3。
asmcmd cp 命令 我执行过了。
目标名 只能为current.260
目标名 不能形成current.260.812281505
cp之后 是不是还需要执行其它命令，来从新应用控制文件？

Maclean Liu(刘相兵

随便cp 一个， 会有对应的alias的， control_files参数指向一下即可

kongkongde

Maclean Liu(刘相兵 发表于 2013-10-24 16:11
随便cp 一个， 会有对应的alias的， control_files参数指向一下即可

alter system set control_files = '+DATA/zhdb/controlfile/current.260.812281505','+FLASH/zhdb/controlfile/current.260'scope=spfile;

执行之后，shutdown，在startup 之后。有如下状态。
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-03113: end-of-file on communication channel
Process ID: 8194
Session ID: 357 Serial number: 1


SQL> show parameter control_files
ERROR:
ORA-03114: not connected to ORACLE

xifenfei

kongkongde 发表于 2013-10-24 16:18
alter system set control_files = '+DATA/zhdb/controlfile/current.260.812281505','+FLASH/zhdb/contr ...

帖出来alert日志，估计控制文件参数修改后，实际文件不一致

kongkongde

xifenfei 发表于 2013-10-24 17:15
帖出来alert日志，估计控制文件参数修改后，实际文件不一致

已上传alter日志

xifenfei

kongkongde 发表于 2013-10-24 17:40
已上传alter日志

/rac/app/oracle/diag/rdbms/zhdb/ZHDB1/trace/alert_*.log文件发给我

control_files = '+DATA/zhdb/controlfile/current.260.812281505','+FLASH/zhdb/controlfile/current.260'

current.260  这个错误的吧

kongkongde

xifenfei 发表于 2013-10-24 19:26
/rac/app/oracle/diag/rdbms/zhdb/ZHDB1/trace/alert_*.log文件发给我

control_files = '+DATA/zhdb/con ...

thanks！！！

xifenfei

  control_files            = "+DATA/zhdb/controlfile/current.260.812281505"


ALTER DATABASE MOUNT /* db agent *//* {0:85:4} */
This instance was first to mount
NOTE: Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database ZHDB and diskgroup resource ora.DATA.dg is established
USER (ospid: 12607): terminating the instance
System state dump requested by (instance=1, osid=12607), summary=[abnormal instance termination].
System State dumped to trace file /rac/app/oracle/diag/rdbms/zhdb/ZHDB1/trace/ZHDB1_diag_12531.trc
Thu Oct 24 18:22:37 2013
Dumping diagnostic data in directory=[cdmp_20131024182237], requested by (instance=1, osid=12607), summary=[abnormal instance termination].
Instance terminated by USER, pid = 12607
alert日志里面只有这些信息，确实比较奇怪， 压缩给我/rac/app/oracle/diag/rdbms/zhdb/ZHDB1/trace/ZHDB1_diag_12531.trc，或者加我qq，上去看下

kongkongde

xifenfei 发表于 2013-10-25 08:37
control_files            = "+DATA/zhdb/controlfile/current.260.812281505"

我 加你 qq了。我这 内外网隔离。

kongkongde

xifenfei 发表于 2013-10-25 08:37
control_files            = "+DATA/zhdb/controlfile/current.260.812281505"

分飞：
日志文件已经离线发给你了。