oracle10rac asm hpux,oracle 10g rac asm上面的控制文件损坏既增加方法

最新推荐文章于 2021-04-13 19:19:53 发布
最新推荐文章于 2021-04-13 19:19:53 发布
阅读量121 收藏
点赞数
文章标签： oracle10rac asm hpux

问题描述

在启动数据库的时候，有一个节点的实例没有起来，查看日志发现报下面的错误

Mon Feb 17 14:28:18 CST 2014

Errors in file /oracle/app/admin/hnzz/bdump/hnzz2_ckpt_31237.trc:

ORA-00202: control file: '+FRA/hnzz/controlfile/current.256.839348429'

ORA-15080: synchronous I/O operation to a disk failed

判断是控制文件损坏造成的

解决过程(在正常启动的节点上面执行)，

1，首先备份一下数据库实例的spfile

SQL> create pfile='/tmp/pfile' from spfile;

File created.

2，确定数据库实例当前的控制文件名

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

+ORADATA/hnzz/controlfile/current.256.839348429

+FRA/hnzz/controlfile/current.256.839348429

3，停止所有节点上使用这个实例文件的数据库实例(因为另外一个没起来这里直接停止当前节点的就行)

$ srvctl stop instance -d hnzz -i hnzz1

4，启动数据库到nomount状态

SQL> startup nomount

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size              79692356 bytes

Database Buffers          201326592 bytes

Redo Buffers                2920448 bytes

5，使用rman来复制一个controfile,原文件是实例1启动起来用的控制文件，这里就是+ORADATA/hnzz/controlfile/current.256.839348429，目标时间里到+FRA中

[root@node1 ~]# su - oracle

[oracle@node1 ~]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Feb 18 15:13:40 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: hnzz (not mounted)

RMAN>restore controlfile to '+FRA' from '+ORADATA/hnzz/controlfile/current.256.839348429';

Starting restore at 18-FEB-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=148 instance=hnzz1 devtype=DISK

channel ORA_DISK_1: copied control file copy

Finished restore at 18-FEB-14

6，利用asmcmd找到新复制的controlfile

[oracle@node1 ~]$ export ORACLE_SID=+ASM1

[oracle@node1 ~]$ asmcmd

ASMCMD> ls

FRA/

ORADATA/

ASMCMD> cd fra

ASMCMD> ls

HNZZ/

ASMCMD> cd hnzz

ASMCMD> ls

CONTROLFILE/

ONLINELOG/

ASMCMD> cd controlfile

ASMCMD> ls

Current.256.839348429

current.261.839862881

下面的这个就是新创建的，

7，设置数据库实例的初始化参数来使用新创建的的controlfile文件

[oracle@node1 ~]$ export ORACLE_SID=hnzz1

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Feb 18 15:20:47 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> alter system set control_files='+fra/hnzz/controlfile/current.261.839862881' scope=spfile;

System altered.

SQL> show parameter control_files;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_files                        string      +ORADATA/hnzz/controlfile/curr

ent.256.839348429, +FRA/hnzz/c

ontrolfile/current.256.8393484

29

8，重启实例

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size              79692356 bytes

Database Buffers          201326592 bytes

Redo Buffers                2920448 bytes

Database mounted.

Database opened.

SQL> show parameter control_files;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_files                        string      +FRA/hnzz/controlfile/current.

261.839862881

在节点2上启动

[oracle@node2 ]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Feb 18 15:35:25 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size             138412612 bytes

Database Buffers          142606336 bytes

Redo Buffers                2920448 bytes

Database mounted.

Database opened.

实例恢复正常

增加控制文件

[oracle@node2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Feb 18 16:10:50 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size             138412612 bytes

Database Buffers          142606336 bytes

Redo Buffers                2920448 bytes

SQL>alter system set control_files='+oradata/hnzz/controlfile/Current.256.839348429','+fra/hnzz/controlfile/current.261.839862881' scope=spfile;

System altered.

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

[oracle@node2 ~]$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora....STAF.cs application    OFFLINE   OFFLINE

ora....zz1.srv application    OFFLINE   OFFLINE

ora.hnzz.db    application    OFFLINE   OFFLINE

ora....z1.inst application    OFFLINE   OFFLINE

ora....z2.inst application    OFFLINE   OFFLINE

ora....SM1.asm application    ONLINE    ONLINE    node1

ora....E1.lsnr application    ONLINE    ONLINE    node1

ora.node1.gsd  application    ONLINE    ONLINE    node1

ora.node1.ons  application    ONLINE    ONLINE    node1

ora.node1.vip  application    ONLINE    ONLINE    node1

ora....SM2.asm application    ONLINE    ONLINE    node2

ora....E2.lsnr application    ONLINE    ONLINE    node2

ora.node2.gsd  application    ONLINE    ONLINE    node2

ora.node2.ons  application    ONLINE    ONLINE    node2

ora.node2.vip  application    ONLINE    ONLINE    node2

[oracle@node2 ~]$ srvctl start instance -d hnzz -i hnzz1,hnzz2

PRKP-1001 : Error starting instance hnzz1 on node node1

CRS-0215: Could not start resource 'ora.hnzz.hnzz1.inst'.

PRKP-1001 : Error starting instance hnzz2 on node node2

CRS-0215: Could not start resource 'ora.hnzz.hnzz2.inst'.

[oracle@node2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Feb 18 16:15:33 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size             138412612 bytes

Database Buffers          142606336 bytes

Redo Buffers                2920448 bytes

ORA-00214: control file '+FRA/hnzz/controlfile/current.261.839862881' version

1031 inconsistent with file '+ORADATA/hnzz/controlfile/current.256.839348429'

version 1017     报错说两个控制文件的版本不一致

SQL> startup nomunt

SP2-0714: invalid combination of STARTUP options

SQL> startup nomount;

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

[oracle@node2 ~]$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora....STAF.cs application    OFFLINE   OFFLINE

ora....zz1.srv application    OFFLINE   OFFLINE

ora.hnzz.db    application    OFFLINE   OFFLINE

ora....z1.inst application    ONLINE    OFFLINE

ora....z2.inst application    OFFLINE   OFFLINE

ora....SM1.asm application    ONLINE    ONLINE    node1

ora....E1.lsnr application    ONLINE    ONLINE    node1

ora.node1.gsd  application    ONLINE    ONLINE    node1

ora.node1.ons  application    ONLINE    ONLINE    node1

ora.node1.vip  application    ONLINE    ONLINE    node1

ora....SM2.asm application    ONLINE    ONLINE    node2

ora....E2.lsnr application    ONLINE    ONLINE    node2

ora.node2.gsd  application    ONLINE    ONLINE    node2

ora.node2.ons  application    ONLINE    ONLINE    node2

ora.node2.vip  application    ONLINE    ONLINE    node2

[oracle@node2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Feb 18 16:19:14 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size             138412612 bytes

Database Buffers          142606336 bytes

Redo Buffers                2920448 bytes

SQL>alter system set control_files='+oradata/hnzz/controlfile/Current.256.839348429' scope=spfile;  第一次尝试 重新回到之前的controlfile

System altered.

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size             138412612 bytes

Database Buffers          142606336 bytes

Redo Buffers                2920448 bytes

Database mounted.

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '+ORADATA/hnzz/datafile/system.259.839348441'

ORA-01207: file is more recent than control file - old control file   报错说控制文件的版本太老

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

[oracle@node2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Feb 18 16:23:25 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size             138412612 bytes

Database Buffers          142606336 bytes

Redo Buffers                2920448 bytes

SQL>alter system set control_files='+fra/hnzz/controlfile/current.261.839862881' scope=spfile; 第二次尝试 使用上面刚恢复的controlfile

System altered.

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size             138412612 bytes

Database Buffers          142606336 bytes

Redo Buffers                2920448 bytes

Database mounted.

Database opened.

SQL> select name from v$controfile;

select name from v$controfile

*

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

+FRA/hnzz/controlfile/current.261.839862881

SQL>

数据库正常启动，但是只有一个控制文件

下面是完整的增加步骤(先恢复后增加)

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Feb 18 16:33:30 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> create pfile='/tmp/pfile' from spfile;

File created.

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

+FRA/hnzz/controlfile/current.261.839862881

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size              88080964 bytes

Database Buffers          192937984 bytes

Redo Buffers                2920448 bytes

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

[oracle@node1 ~]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Feb 18 16:36:11 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: hnzz (not mounted)

RMAN> restore controlfile to '+ORADATA' from '+FRA/hnzz/controlfile/current.261.839862881';

Starting restore at 18-FEB-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=149 instance=hnzz1 devtype=DISK

channel ORA_DISK_1: copied control file copy

Finished restore at 18-FEB-14

RMAN> quit

Recovery Manager complete.

[oracle@node1 ~]$ echo $ORACLE_SID

hnzz1

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Feb 18 16:41:59 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size              88080964 bytes

Database Buffers          192937984 bytes

Redo Buffers                2920448 bytes

SQL> alter system set control_files='+oradata/hnzz/controlfile/current.268.839867897','+FRA/hnzz/controlfile/current.261.839862881' scope=spfile;  标红的为新恢复的

System altered.

SQL> show parameter control_files;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_files                        string      +FRA/hnzz/controlfile/current.

261.839862881

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273276 bytes

Variable Size              88080964 bytes

Database Buffers          192937984 bytes

Redo Buffers                2920448 bytes

Database mounted.

Database opened.

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

+ORADATA/hnzz/controlfile/current.268.839867897

+FRA/hnzz/controlfile/current.261.839862881

香浓拉码
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 Conntect by 问题
ghostgant的专栏
11-13 1804
SQL：1、connect by 最常见的写法 select SYS_CONNECT_BY_PATH(sal, ',')   from (select sal,                ROW_NUMBER() over(PARTITION BY deptno ORDER BY sal) rn,                ROW_NUMBER() over(PARTITION B
oracle数据库报04030,ORA-04030处理一例
weixin_30444191的博客
04-07 1513
ORA-04030错误属于常见错误之一oerr ora 0403004030, 00000, "out of process memory when trying to allocate %s bytes (%s,%s)"// *Cause: Operating system process private memory has been exhausted// *Action:头两天一同事遇上...
oracle10g rac搭建,oracle 10g rac环境搭建问题处理一则
weixin_39834788的博客
04-12 136
oracle@sckfdb5:/sbin/init.d $ sh -x init.cssdstartcheck CSS+ ORA_CRS_HOME=/oracle/product/crs+ ORACLE_USER=oracle+ ORACLE_HOME=/oracle/product/crs+ export ORACLE_HOME+ export ORA_CRS_HOME+ DISABLE_OPR...
oracle 10g磁盘管理,oracle 10g中ASM概念以及管理
weixin_42101056的博客
04-06 449
一、关于oracle ASM实例的概念：ASM 实例与 ORACLE 实例差不多，都是 由 sga 和一堆后台进程组成，从功能上来看，区别在于oracle实例管理的是数据库，而asm实例只是管理asm盘阵。通过Oracle EM或DBCA都可以对asm进行一些配置，不过三思觉着管理asm括弧实例的最佳工具仍是sql*plus，在进入sql*plus前也需要设置ORACLE_SID的环境变量，该环境...
oracle 10g rac asm上面的控制文件损坏既增加方法
竹林晚风
10-22 650
oracle 10g rac asm上面的控制文件损坏既增加方法 2014-02-18 16:50:50 分类： Oracle 问题描述 在启动数据库的时候，有一个节点的实例没有起来，查看日志发现报下面的错误 Mon Feb 17 14:28:18 CST 2014 Errors in file /oracle/app/admin/hnzz/bdump/hnzz2_ckpt_31237.
oracle修改10到20,Oracle 10.2.0.5 RMAN迁移并升级11.2.0.4一例
weixin_39977276的博客
04-13 259
一、环境介绍1. 源数据库环境操作系统版本: OEL 5.4 x64数据库版本 : 10.2.0.5 x64数据库sid名 : orclOracle 10g 10.2.0.5(64bit)安装目录如下：数据库软件：/u01/app/oracle/product/10.2.0/db_1数据库文件：/u01/app/oracle/oradata/orcl归档目录：/u01/archivelogRMA...
hpux+slvm+mc/sg+oracle 10g rac实施手册
sage
10-30 1470
 硬件环境:hp rx2660*2+hp eva4400软件环境:hpux 11.23,oracle 10g for hpux,oracle clusterware,mc/serviguard 11.181.安装HPUX2.打补丁,参照文档即可,或打到magepatch dec.12.07以后也可以3.安装mc/sg+SGeRAC(hp MC/Serviceguard为配合oracle rac所使
oracle 10.2.0 常见问题
weixin_34357267的博客
05-22 223
一.数据库的打开与关闭 linux下启动oracle su - oracle sqlplus /nolog conn /as sysdba startup exit lsnrctl start exit linux下关闭oracle su - oracle sqlplus /nolog conn /as sysdba shutdown ...
开启数据库闪回功能
数据库
03-23 464
--关闭数据库，需要将数据库打开到mount状态才能开启闪回功能： SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> show user USER is "SYS" SQL> exit Dis...
数据库启动报错两种情况的解决办法
渐离生死的博客
12-01 5632
通常服务器在突然断电或者频繁关机的情况下很容易造成数据库损坏，然后启动不了数据库，针对这种情况出现最多的有两种， 其一：启动的时候数据文件损坏       这种情况比较简单， 1、  首先关闭数据库      sql>shutdown immediate; 2、 其次启动数据库，      sql>startup;     此时启动数据库会报错，     data file 12:
php连接oracle10g,Oracle10g与各版本的连通性
weixin_29779159的博客
03-12 141
欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 昨天有朋友问到Oracle10g和Oracle8i的连通性问题,一时记不清楚,同事作了一些测试.得到的结论是: Oracle8.1.5可以连接Oracle10g Oracle8.1.7也可以连接Oracle10g Oracle10gR2可以连接Oracle8.1.7,但欢迎进入Oracle社区论坛，与200万技术人员互...
oracle 06502 解决,【故障解决】ORA-06502错误解决
weixin_33267830的博客
04-12 5743
【故障解决】ORA-06502: PL/SQL: numeric or value error: character string buffer too small一.1BLOG文档结构图 一.2前言部分一.2.1导读和注意事项各位技术爱好者，看完本文后，你可以掌握如下的技能，也可以学到一些其它你所不知道的知识，~O(∩_∩)O~：① EXPDP和IMPDP基于scn的导出② ora-06502的...
2024巴黎奥运会中国队奖牌数据
08-17
2024巴黎奥运会中国队奖牌数据
DBO-LightGBM蜣螂优化算法优化LightGBM分类预测，优化前后对比（Matlab完整源码和数据）
08-17
1.Matlab实现DBO-LightGBM蜣螂优化算法优化LightGBM分类预测,优化前后对比，Matlab调用Python的LightGBM库（完整源码和数据）。 2.输出对比图、混淆矩阵图、预测准确率，运行环境Matlab2023及以上，配置Python的LightGBM库。兼容测试链接：https://ww2.mathworks.cn/support/requirements/python-compatibility.html 3.代码特点：参数化编程、参数可方便更改、代码编程思路清晰、注释明细。 4.适用对象：计算机，电子信息工程、数学等专业的大学生课程设计、期末大作业和毕业设计。 5.作者介绍：机器学习之心，博客专家认证，机器学习领域创作者，2023博客之星TOP50，主做机器学习和深度学习时序、回归、分类、聚类和降维等程序设计和案例分析，文章底部有博主联系方式。从事Matlab、Python算法仿真工作8年，更多仿真源码、数据集定制私信。
基于协同过滤的电影推荐系统python代码+数据库
最新发布
08-17
基于协同过滤的电影推荐系统python代码+数据库，基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据库基于协同过滤的电影推荐系统python代码+数据
AIX6.1环境下Oracle 10g RAC与ASM安装指南
"AIX6.1+Oracle 10g RAC+ASM是一个在IBM AIX 6.1操作系统上部署的Oracle Real Application Clusters (RAC)环境，结合了Oracle Automatic Storage Management (ASM)技术。这个环境旨在提供高可用性和负载均衡，通过在...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值