迁移ocr/votedisk/asm spfile所在磁盘组

最新推荐文章于 2024-08-09 21:25:57 发布
最新推荐文章于 2024-08-09 21:25:57 发布
阅读量89 收藏
点赞数
文章标签： 数据库

环境：redhat6.5  oracle11.2.0.3两节点RAC
本实验将ocr/votedisk/asm spfile所在磁盘组迁移到另外一个磁盘组

[grid@hp580-5 ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576   1536000  1418049           512000          453024              0             Y  DATA/
MOUNTED  EXTERN  N         512   4096  1048576    512000   504395                0          504395              0             N  FRA/
MOUNTED  EXTERN  N         512   4096  1048576    512000   511901                0          511901              0             N  SYS/
ASMCMD> exit
[grid@hp580-5 ~]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   2994b1890e944fc7bf13744a8c98f5ea (/dev/asm-diskc) [DATA]
 2. ONLINE   0e8b5764cd5a4fb6bf74fe7058745670 (/dev/asm-diskd) [DATA]
 3. ONLINE   62a1876953964f16bff300704a04717a (/dev/asm-diske) [DATA]
Located 3 voting disk(s).
[grid@hp580-5 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2972
         Available space (kbytes) :     259148
         ID                       : 1794026097
         Device/File Name         :      +DATA
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check bypassed due to non-privileged user

[grid@hp580-5 ~]$ sqlplus   /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 9 15:52:41 2015

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

SQL> connect / as sysdba
Connected.
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/hp580-cluster/asmparamet
                                                 erfile/registry.253.854119569
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@hp580-5 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       hp580-4                                     
               ONLINE  ONLINE       hp580-5                                     
ora.FRA.dg
               ONLINE  ONLINE       hp580-4                                     
               ONLINE  ONLINE       hp580-5                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       hp580-4                                     
               ONLINE  ONLINE       hp580-5                                     
ora.SYS.dg
               ONLINE  ONLINE       hp580-4                                     
               ONLINE  ONLINE       hp580-5                                     
ora.asm
               ONLINE  ONLINE       hp580-4                  Started            
               ONLINE  ONLINE       hp580-5                  Started            
ora.gsd
               OFFLINE OFFLINE      hp580-4                                     
               OFFLINE OFFLINE      hp580-5                                     
ora.net1.network
               ONLINE  ONLINE       hp580-4                                     
               ONLINE  ONLINE       hp580-5                                     
ora.ons
               ONLINE  ONLINE       hp580-4                                     
               ONLINE  ONLINE       hp580-5                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       hp580-5                                     
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       hp580-4                                     
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       hp580-4                                     
ora.cvu
      1        ONLINE  ONLINE       hp580-4                                     
ora.hp580-4.vip
      1        ONLINE  ONLINE       hp580-4                                     
ora.hp580-5.vip
      1        ONLINE  ONLINE       hp580-5                                     
ora.oc4j
      1        ONLINE  ONLINE       hp580-4                                     
ora.orcl.db
      1        ONLINE  ONLINE       hp580-4                  Open               
      2        ONLINE  ONLINE       hp580-5                  Open               
ora.scan1.vip
      1        ONLINE  ONLINE       hp580-5                                     
ora.scan2.vip
      1        ONLINE  ONLINE       hp580-4                                     
ora.scan3.vip
      1        ONLINE  ONLINE       hp580-4                                     
[grid@hp580-5 ~]$ ocrconfig -add  +sys
PROT-20: Insufficient permission to proceed. Require privileged user
[grid@hp580-5 ~]$ echo   $ORACLE_HOME
/g01/app/11.2.0/grid
[grid@hp580-5 ~]$ exit
logout
[root@hp580-5 dev]# cd  /g01/app/11.2.0/grid/bin
[root@hp580-5 bin]# ./ocrconfig  -add  +sys
[root@hp580-5 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2972
         Available space (kbytes) :     259148
         ID                       : 1794026097
         Device/File Name         :      +DATA
                                    Device/File integrity check succeeded
         Device/File Name         :       +sys
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check succeeded

[root@hp580-5 bin]# ./crsctl replace  votedisk  +sys
Successful addition of voting disk 1600c0ff5c084fa9bf2bb00d1381d589.
Successful deletion of voting disk 2994b1890e944fc7bf13744a8c98f5ea.
Successful deletion of voting disk 0e8b5764cd5a4fb6bf74fe7058745670.
Successful deletion of voting disk 62a1876953964f16bff300704a04717a.
Successfully replaced voting disk group with +sys.
CRS-4266: Voting file(s) successfully replaced
[root@hp580-5 bin]# ./ocrconfig  -delete +data
[root@hp580-5 bin]# su   - grid
[grid@hp580-5 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2972
         Available space (kbytes) :     259148
         ID                       : 1794026097
         Device/File Name         :       +sys
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check bypassed due to non-privileged user

[grid@hp580-5 ~]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   1600c0ff5c084fa9bf2bb00d1381d589 (/dev/asm-diskg) [SYS]
Located 1 voting disk(s).


SQL> connect / as sysdba
Connected.
SQL> create pfile='/tmp/pfile.ora'  from spfile;

SQL> create spfile='+SYS'  from pfile='/tmp/pfile.ora';

File created.
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/hp580-cluster/asmparamet
                                                 erfile/registry.253.854119569
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

[root@hp580-5 bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'hp580-5'
CRS-2673: Attempting to stop 'ora.crsd' on 'hp580-5'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'hp580-5'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.SYS.dg' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.orcl.db' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'hp580-5'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.hp580-5.vip' on 'hp580-5'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'hp580-5'
CRS-2677: Stop of 'ora.hp580-5.vip' on 'hp580-5' succeeded
CRS-2672: Attempting to start 'ora.hp580-5.vip' on 'hp580-4'
CRS-2677: Stop of 'ora.scan1.vip' on 'hp580-5' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'hp580-4'
CRS-2677: Stop of 'ora.orcl.db' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'hp580-5'
CRS-2676: Start of 'ora.hp580-5.vip' on 'hp580-4' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'hp580-4' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'hp580-4'
CRS-2677: Stop of 'ora.FRA.dg' on 'hp580-5' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'hp580-4' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.SYS.dg' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'hp580-5'
CRS-2677: Stop of 'ora.asm' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'hp580-5'
CRS-2677: Stop of 'ora.ons' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'hp580-5'
CRS-2677: Stop of 'ora.net1.network' on 'hp580-5' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'hp580-5' has completed
CRS-2677: Stop of 'ora.crsd' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.ctssd' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.evmd' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.asm' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'hp580-5'
CRS-2677: Stop of 'ora.crf' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.evmd' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.asm' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'hp580-5'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'hp580-5'
CRS-2677: Stop of 'ora.cssd' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'hp580-5'
CRS-2677: Stop of 'ora.gipcd' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'hp580-5'
CRS-2677: Stop of 'ora.gpnpd' on 'hp580-5' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'hp580-5' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@hp580-5 bin]#
[root@hp580-5 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@hp580-5 bin]# su  - grid
[grid@hp580-5 ~]$ sqlplus   /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 9 16:26:53 2015

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

SQL> connect / as sysdba
Connected.
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +SYS/hp580-cluster/asmparamete
                                                 rfile/registry.253.873908213
SQL>


重起另一个节点的crs即OK

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26870952/viewspace-1453727/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26870952/viewspace-1453727/

congjuyan5037
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
添加votedisk
juliaputao的专栏
03-17 2053
1.添加votedisk 必须有一半以上的votedisk同时可用，clusterware才能正常工作，否则cluster立刻宕掉。所以最好votedisk保持单数个。添加和删除votedisk的操作非常危险，必须在停止数据库，停止asm，停止CRS stack后操作，并且操作时必须加force。 *在oracle 11.2中已经不需要停cluster了，而且没有add votedisk，可以
SaveJpg.rar_GDI/图象编程_Asm_
08-11
标题中的"SaveJpg.rar_GDI/图象编程_Asm_"揭示了这是一个关于使用图形设备接口（GDI）和汇编语言（Asm）进行图像编程的项目，具体任务是将位图（BMP）文件转换成JPEG（JPG）格式。在Windows系统中，GDI是一个核心...
ASM磁盘组迁移
a149171的博客
09-27 706
1.OCR_VOTE磁盘组更换 添加ASM磁盘,使用asmca创建OCR_NEW磁盘组 SYS@ +ASM1>select group_number,name,type,state,total_mb,free_mb,USABLE_FILE_MB from v$asm_diskgroup; GROUP_NUMBER NAME TYPE STATE TOTAL_MB FREE_MB USABLE_FILE_MB 1 DATA
votedisk在ASM diskgroup上的存放规律
cuiqiong6888的博客
10-21 370
Votedisk在ASM Diskgroup上的存放满足以下条件： External redundancy: A disk group with external redundancy contains ...
管理voting disks
Lixora's DB Home
06-18 1829
管理voting disks 一、关于voting disk 的一些必须要知道的东西： 11g 以前我们可以使用dd 命令来备份voting disk ，但是在11g 以后 oracle 不再支持使用 dd 来备份voting disk。 如果使用 dd or cp 命令可能会破坏 集群件堆栈的正常启动。 voting disk 会作为OCR的一部分自动备份，并且当有新 votin
CAR.rar_嵌入式/单片机/硬件编程_Asm_
08-11
标题中的"CAR.rar_嵌入式/单片机/硬件编程_Asm_"表明这是一个与嵌入式系统、单片机编程以及硬件相关的项目，使用的编程语言是汇编（Asm）。汇编语言是一种低级编程语言，直接对应于机器指令，对于微控制器和嵌入式...
cih.rar_系统/网络安全_Asm_
08-11
cih病毒中文注释源码，英文注释保留原有的
Desktop.rar_编译器/解释器_Asm_
08-11
speedometer source code from seminar projects site
program.zip_嵌入式/单片机/硬件编程_Asm_
08-12
标题中的"program.zip_嵌入式/单片机/硬件编程_Asm_"表明这是一个与嵌入式系统、单片机编程以及使用汇编语言（Asm）相关的项目压缩包。这个项目的具体应用是在火灾报警系统中，使用了PIC 16F877微控制器。以下是对...
votedisk
whb234174124的博客
03-11 263
normal 冗余 最少3块盘也就是3个failgroup 9块盘3个failgroup（每3块一个failgroup） 最多可以offline 同failgroup的3快盘 6块盘3个failgroup（每3块一个failgroup，盘数1,1,4） 最多可以offline 同failgroup的4块盘 6块盘6个failgroup 最多可以offline 1块盘，drop 3块盘 ...
seatunnel2.3.3在centos7上安装
鑫哥
08-09 717
安装前需要准备点环境，因为seatunnel是基于java开发的，因此需要先安装java，我这里使用的java1.8，可以网上搜索下java安装教程，记得配置JAVA_HOME环境变量。在安装的过程中需要用到mysql命令，因此也需要安装下MySQL环境，这里也不具体讲解了，在网上搜索安装就行。接下来就是正式安装seatunnel了，
java笔记 mybatis 基本增删改
qq_63095129的博客
08-05 761
在pom.xml文件中添加依赖。
JDBC详细使用
最新发布
m0_73627305的博客
08-09 411
​ JDBC是一种标准,一种规则,主要作用是使用java语言操作数据库的​ JDBC这个标准中有很多的接口,接口中有很多方法。
04、MySQL-DCL（数据控制语言）
nibabaoo的博客
08-06 317
例：创建用户zhangsan 只能够在当前主机localhost访问 密码123456。例：创建用户xiaoming 可以在任意主机访问该数据库 密码123456。例：修改用户zhangsan的密码为654321。例：删除用户xiaoming。
49 mysql 子查询 加 group by 产生的奇怪现象
970655147的专栏
08-05 386
这里要提到的是一个 之前碰到的一个 很令人诧异的查询, 主要是 和 group 查询有关系查询如下, 按照常规理解, “select id from t_user_02 where name = 'jerry' group by age” 会返回 两条数据, 然后 整个查询 会查询出两条数据但是 结果很令人差异, 查询出了 四条数据测试数据表如下, t_user 和 t_user_02 完全一样, t_user_02 是由 t_user 复制而来测试数据如下查询结果如下。
zabbix的自动发现和注册、proxy代理和SNMP监控
Alone8046的博客
08-09 256
二、zabbix通过代理服务器添加主机：分布式监控，代理服务器的作用就是分担 server 的集中式压力；先有服务器，再有模版，模版当中设置应用集，模版当中设置应用集，再应用集中配置监控项，在监控项之后配置触发器，最后配置图形（可选项）zabbix proxy（代理服务器）：代理服务器也要安装数据库，保存客户端的数据，然后再发送给服务端（代收器）zabbix客户端主动的和服务端联系，将自己的地址和端口发送给服务端，实现自动添加监控主机。snmp：简单网络管理协议，用来监控网络设备，可以监控交换机和路由器。
ORACLE 定时器一般操作数据
lc547913923的专栏
08-08 247
3、单个定时器重新跑数据。1、查询出所有定时器。2、重跑定时器的数据。
Qt拖拽事件详解及代码实现
Isana_Yashiro的博客
08-05 767
qt拖拽事件是一项非常常用并且非常好用的功能，拖拽实际上是一种信息传递的载体，其目的是将信息从一个对象传递给另一个对象。通过拖拽可以简化文件打开或业务操作流程，qt初学者学会拖拽事件后就可以马上开发出许多有趣的项目，本文以一个简单的示例来介绍拖拽事件功能。DragDropWidget类实现了拖拽发起对话框，主要是重写了鼠标事件函数，用于设置拖拽搭载的信息，这里就是一个字符串，实际上也可以是自定义的类或者其他对象。代码详见dragdropwidget.h及dragdropwidget.cpp。
Oracle12c ASM磁盘组管理详解
"Oracle12c的ASM(自动存储管理)磁盘组管理涉及一系列操作，包括创建、修改、删除、挂载和卸载磁盘组。此外，磁盘组有多个可配置属性，这些属性定义了磁盘组的行为和性能特征。了解并熟练掌握这些属性对于优化Oracle ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值