11.2.0.3 RAC替换ocr 和 votedisk位置

最新推荐文章于 2024-05-23 14:01:05 发布
最新推荐文章于 2024-05-23 14:01:05 发布
阅读量161 收藏
点赞数

首先先停止rac1和rac2节点的实例

[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
  Version                  :          3
  Total space (kbytes)     :     262120
  Used space (kbytes)      :       3052
  Available space (kbytes) :     259068
  ID                       :  513026633
  Device/File Name         :   +OCRVOTE
                                    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 succeeded

[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   3e2c54bd44864fa3bf681a6d2c14e158 (ORCL:OCRVOTE3) [OCRVOTE]
 2. ONLINE   96134cd84b4b4f5ebf1f345d7ebbb09a (ORCL:OCRVOTE1) [OCRVOTE]
 3. ONLINE   a99e219504f94f08bf6f5be0aa0af6bc (ORCL:OCRVOTE2) [OCRVOTE]
Located 3 voting disk(s).
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# su - grid
[grid@rac1 ~]$
[grid@rac1 ~]$ asmcmd
ASMCMD>
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  EXTERN  N         512   4096  1048576     10236     8146                0            8146              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576     10236    10141                0           10141              0             N  NEWOCR/
MOUNTED  NORMAL  N         512   4096  1048576      6141     5215             2047            1584              0             Y  OCRVOTE/
ASMCMD>
ASMCMD>
ASMCMD> lsdsk -k
Total_MB  Free_MB  OS_MB  Name      Failgroup  Failgroup_Type  Library                                               Label     UDID  Product  Redund   Path
   10236     8146  10236  DATA1     DATA1      REGULAR         ASM Library - Generic Linux, version 2.0.4 (KABI_V2)  DATA1                    UNKNOWN  ORCL:DATA1
   10236    10141  10236  NEWOCR    NEWOCR     REGULAR         ASM Library - Generic Linux, version 2.0.4 (KABI_V2)  NEWOCR                   UNKNOWN  ORCL:NEWOCR
    2047     1737   2047  OCRVOTE1  OCRVOTE1   REGULAR         ASM Library - Generic Linux, version 2.0.4 (KABI_V2)  OCRVOTE1                 UNKNOWN  ORCL:OCRVOTE1
    2047     1740   2047  OCRVOTE2  OCRVOTE2   REGULAR         ASM Library - Generic Linux, version 2.0.4 (KABI_V2)  OCRVOTE2                 UNKNOWN  ORCL:OCRVOTE2
    2047     1738   2047  OCRVOTE3  OCRVOTE3   REGULAR         ASM Library - Generic Linux, version 2.0.4 (KABI_V2)  OCRVOTE3                 UNKNOWN  ORCL:OCRVOTE3
ASMCMD>
ASMCMD>
ASMCMD> exit
[grid@rac1 ~]$ exit
logout
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# oocrconfig -showbackup
-bash: oocrconfig: command not found
[root@rac1 ~]#
[root@rac1 ~]# ocrconfig -showbackup
PROT-24: Auto backups for the Oracle Cluster Registry are not available

rac2     2015/02/11 14:23:52     /u01/app/11.2.0/grid/cdata/rac-scan/backup_20150211_142352.ocr
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# ocrconfig -manualbackup

rac1     2015/02/11 15:57:28     /u01/app/11.2.0/grid/cdata/rac-scan/backup_20150211_155728.ocr

rac2     2015/02/11 14:23:52     /u01/app/11.2.0/grid/cdata/rac-scan/backup_20150211_142352.ocr
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# ocrconfig -add +NEWOCR
[root@rac1 ~]#
[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
  Version                  :          3
  Total space (kbytes)     :     262120
  Used space (kbytes)      :       3072
  Available space (kbytes) :     259048
  ID                       :  513026633
  Device/File Name         :   +OCRVOTE
                                    Device/File integrity check succeeded
  Device/File Name         :    +NEWOCR
                                    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@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# ocrconfig -delete +OCRVOTE
[root@rac1 ~]#
[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
  Version                  :          3
  Total space (kbytes)     :     262120
  Used space (kbytes)      :       3072
  Available space (kbytes) :     259048
  ID                       :  513026633
  Device/File Name         :    +NEWOCR
                                    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 succeeded

[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# crsctl replace votedisk +NEWOCR
Successful addition of voting disk 4922fdf83b144f32bf52fe7d2bf43fb6.
Successful deletion of voting disk 3e2c54bd44864fa3bf681a6d2c14e158.
Successful deletion of voting disk 96134cd84b4b4f5ebf1f345d7ebbb09a.
Successful deletion of voting disk a99e219504f94f08bf6f5be0aa0af6bc.
Successfully replaced voting disk group with +NEWOCR.
CRS-4266: Voting file(s) successfully replaced
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   4922fdf83b144f32bf52fe7d2bf43fb6 (ORCL:NEWOCR) [NEWOCR]
Located 1 voting disk(s).
[root@rac1 ~]#
[root@rac1 ~]#


rac1和 rac2 同时执行

[root@rac1 ~]# su - grid
[grid@rac1 ~]$
[grid@rac1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 11 16:02:22 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Real Application Clusters and Automatic Storage Management options

SQL> show parameter spfile;

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
spfile         string  +OCRVOTE/rac-scan/asmparameter
       file/registry.253.868489489
SQL> create pfile='/home/grid/asminit.ora' from spfile='+OCRVOTE/rac-scan/asmparameterfile/registry.253.868489489';

File created.

SQL>
SQL> ! more /home/asminit.ora
+ASM1.asm_diskgroups='DATA','NEWOCR'#Manual Mount
+ASM2.asm_diskgroups='FRA','DATA','ARCH','NEWOCR'#Manual Mount
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$

修改新的磁盘组位置

[grid@rac1 ~]$ vi /home/grid/asminit.ora
"~/asminit.ora"
"~/asminit.ora" 7L, 251C+ASM1.asm_diskgroups='DATA','NEWOCR'#Manual Mount
+ASM2.asm_diskgroups='FRA','DATA','ARCH','NEWOCR'#Manual Mount
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

[grid@rac1 ~]$
[grid@rac1 ~]$
[grid@rac1 ~]$ cat  /home/grid/asminit.ora
+ASM1.asm_diskgroups='DATA','NEWOCR'#Manual Mount
+ASM2.asm_diskgroups='DATA','NEWOCR'#Manual Mount
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
[grid@rac1 ~]$
[grid@rac1 ~]$
[grid@rac1 ~]$
[grid@rac1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 11 16:08:03 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Real Application Clusters and Automatic Storage Management options

SQL> shutdown immediate;
ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 7453)
SQL>
SQL> shutdown abort;
ASM instance shutdown
SQL>
SQL>
SQL> startup pfile='/home/grid/asminit.ora';
ASM instance started

Total System Global Area  284565504 bytes
Fixed Size      1344456 bytes
Variable Size    258055224 bytes
ASM Cache     25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
SQL>
SQL>
SQL> select name from v$asm_disk;

NAME
------------------------------

DATA1
NEWOCR
OCRVOTE1
OCRVOTE2
OCRVOTE3

6 rows selected.

SQL> select name from v$asm_diskgroup;

NAME
------------------------------
DATA
NEWOCR
OCRVOTE

SQL>
SQL> create spfile='+NEWOCR' from pfile='/home/griasminit.ora';

File created.

SQL>
SQL> shutdown abort;
ASM instance shutdown
SQL>
SQL> startup
ASM instance started

Total System Global Area  284565504 bytes
Fixed Size      1344456 bytes
Variable Size    258055224 bytes
ASM Cache     25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
SQL>
SQL>
SQL> show parameter spfile;

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
spfile         string  +NEWOCR/rac-scan/asmparameterf
       ile/registry.253.871402673
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$
[grid@rac1 ~]$ exit
logout
[root@rac1 ~]#


rac1和 rac2 同时执行

[root@rac1 ~]# crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.NEWOCR.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'rac2'
CRS-2677: Stop of 'ora.cvu' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'rac2'
CRS-2676: Start of 'ora.cvu' on 'rac2' succeeded
CRS-2676: Start of 'ora.oc4j' on 'rac2' succeeded
CRS-2677: Stop of 'ora.NEWOCR.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rac1 ~]#
[root@rac1 ~]#

启动后的结果如下

[root@rac1 ~]#
[root@rac1 ~]# ps -ef |grep smon
root     12936     1  0 16:26 ?        00:00:01 /u01/app/11.2.0/grid/bin/osysmond.bin
grid     13320     1  0 16:27 ?        00:00:00 asm_smon_+ASM1
root     14353  9549  0 16:35 pts/2    00:00:00 grep smon
[root@rac1 ~]#
[root@rac1 ~]# su - grid
[grid@rac1 ~]$
[grid@rac1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 11 16:35:37 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Real Application Clusters and Automatic Storage Management options


SQL>  select name,state from v$asm_diskgroup;

NAME          STATE
------------------------------ -----------
DATA          MOUNTED
NEWOCR          MOUNTED
OCRVOTE          MOUNTED

SQL> alter diskgroup ocrvote dismount;

Diskgroup altered.

SQL> select name,state from v$asm_diskgroup;

NAME          STATE
------------------------------ -----------
DATA          MOUNTED
NEWOCR          MOUNTED
OCRVOTE          DISMOUNTED

SQL> drop diskgroup ocrvote including contents;
drop diskgroup ocrvote including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "OCRVOTE" does not exist or is not mounted


在rac1节点执行卸载磁盘报错，然后登陆到rac2节点，查看磁盘组状态如下

SQL> select name,state from v$asm_diskgroup;

NAME          STATE
------------------------------ -----------
DATA          MOUNTED
NEWOCR          MOUNTED
OCRVOTE          MOUNTED


然后在rac2节点执行卸载即可

SQL>  drop diskgroup ocrvote including contents;

Diskgroup dropped.

SQL>  select name,state from v$asm_diskgroup;

NAME          STATE
------------------------------ -----------
DATA          MOUNTED
NEWOCR          MOUNTED


然后在rac1节点会自动发现原来的ocrvote磁盘组已经删除，无需再手动删除

SQL>  select name,state from v$asm_diskgroup;

NAME          STATE
------------------------------ -----------
DATA          MOUNTED
NEWOCR          MOUNTED

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$
[grid@rac1 ~]$
[grid@rac1 ~]$ exit
logout
[root@rac1 ~]#
[root@rac1 ~]# crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1       
ora.NEWOCR.dg  ora....up.type ONLINE    ONLINE    rac1       
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1       
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1       
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              
ora....network ora....rk.type ONLINE    ONLINE    rac1       
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1       
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1       
ora....SM1.asm application    ONLINE    ONLINE    rac1       
ora....C1.lsnr application    ONLINE    ONLINE    rac1       
ora.rac1.gsd   application    OFFLINE   OFFLINE              
ora.rac1.ons   application    ONLINE    ONLINE    rac1       
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1       
ora....SM2.asm application    ONLINE    ONLINE    rac2       
ora....C2.lsnr application    ONLINE    ONLINE    rac2       
ora.rac2.gsd   application    OFFLINE   OFFLINE              
ora.rac2.ons   application    ONLINE    ONLINE    rac2       
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2       
ora.racdb.db   ora....se.type OFFLINE   OFFLINE              
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1       
[root@rac1 ~]#

启动rac1和rac2两个节点的数据库实例

[root@rac1 ~]#
[root@rac1 ~]# srvctl start database -d racdb


[root@rac1 ~]# crs
_stat -t

Name           Type           Target    State     Host       
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1       
ora.NEWOCR.dg  ora....up.type ONLINE    ONLINE    rac1       
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1       
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1       
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              
ora....network ora....rk.type ONLINE    ONLINE    rac1       
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1       
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1       
ora....SM1.asm application    ONLINE    ONLINE    rac1       
ora....C1.lsnr application    ONLINE    ONLINE    rac1       
ora.rac1.gsd   application    OFFLINE   OFFLINE              
ora.rac1.ons   application    ONLINE    ONLINE    rac1       
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1       
ora....SM2.asm application    ONLINE    ONLINE    rac2       
ora....C2.lsnr application    ONLINE    ONLINE    rac2       
ora.rac2.gsd   application    OFFLINE   OFFLINE              
ora.rac2.ons   application    ONLINE    ONLINE    rac2       
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2       
ora.racdb.db   ora....se.type ONLINE    ONLINE    rac1       
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1       
[root@rac1 ~]#

[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 11 16:44:15 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select instance_name,status from gv$instance;

INSTANCE_NAME  STATUS
---------------- ------------
racdb1   OPEN
racdb2   OPEN

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$ exit
logout
[root@rac1 ~]#

[root@rac1 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   4922fdf83b144f32bf52fe7d2bf43fb6 (ORCL:NEWOCR) [NEWOCR]
Located 1 voting disk(s).
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
  Version                  :          3
  Total space (kbytes)     :     262120
  Used space (kbytes)      :       3052
  Available space (kbytes) :     259068
  ID                       :  513026633
  Device/File Name         :    +NEWOCR
                                    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 succeeded

[root@rac1 ~]# exit
logout

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

转载于:http://blog.itpub.net/24862808/viewspace-1448635/

congji3615
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle rac换磁盘组,19c RAC 更换OCR磁盘组方法
weixin_33260484的博客
04-03 883
旧的OCR磁盘组名称：+OCRDG新的OCR磁盘组名称：+CRSDG涉及文件有：ocr文件voting文件asm实例spfile文件如下是整个迁移替换过程，大体分四部份，迁移ocr=>迁移voting==>重建spfile==>重启集群。注：前面4步都可以在线操作，只有重启集群需要停业务一、准备迁移OCR文件检查ocr状态[grid@xydb5node1 ~]$ ocrcheck...
11gr2rac替换ocr和votedisk
huoshuyinhua的专栏
05-17 2642
11gr2rac替换ocr和votedisk 11gR2rac替换ocr磁盘 说明：      操作系统是linux 6.5      oracle 数据库是oracle11.2.0.4      其中用到的磁盘组                   OCR是最初安装时放置ocr和votedisk的磁盘组也是本实验要替换的磁盘组，此组为normal（3块1g盘）
Oracle rac如何替换OCR和VOTE磁盘组
最新发布
xiaofan23z的专栏
05-23 458
翻文档，找到了之前给一套Solaris 10+oracle 11g rac 环境替换ocr和vote log在这里分享给大家，背景是存储换代由原来的HP EVA6000替换为HDS VSP400，具体的步骤如下​。昨天公众号发了利用ASM实现存储的零停机存储迁移，有粉丝后台私信，DATA/ARCH DG可以这样加盘踢盘实现零停机存储迁移​。小机平台发现新加存储盘命令 ，有一定的概率怎么都无法发现新加存储，需要无法发现需要重启OS。创建新的ocr磁盘组 用来替换原有旧存储OCR磁盘组。
RAC 11.2.0.3 重建votedisk和OCR
cuibaodun6837的博客
07-06 137
整个实验步骤不多，但是耗时很长，需要有耐心等待。我是一边玩着2048，一边做的实验。 1，在节点node1执行清空clusterware的配置信息 [root@node1 ~]# /g01/grid/app/11.2.0...
Oracle RAC OCRVOTE 迁移替换
喝醉酒的小白
11-18 2569
asmcd 添加一个+ORCVOTE 替换OCR #ocrcheck #ocrconfig -add +OCRVOTE #more /etc/oracle/ocr.loc #ocrconfig -delete +MGMT (可选) #ocrconfig -replace +MGMT -replacement +OCRVOTE #orccheck 替换votedisk $crsctl query css votedisk $crsctl replace votedisk +OCRVOTE $crsctl qu
11gR2 RAC：更换OCR、votedisk
weixin_30709061的博客
08-04 110
要点： ocrconfig 备份-恢复 ocrconfig 导出-导入 crsctl querry css votedisk crsctl replace votedisk {+dsikgroup|sharefilepath} crsctl start crs -excl -nocrs crsctl stop crs -f 转载于:https://www.cnblog...
Oracle 11.2.0.3 使用 ADG 搭建Data Guard 案例
04-20
Oracle 11.2.0.3 数据保护技术在企业级数据库管理中扮演着至关重要的角色，其中Active Data Guard（ADG）是Oracle提供的一种高级数据保护解决方案，用于构建高可用性和灾难恢复策略。本案例将详细介绍如何使用ADG来...
Oracle 11.2.0.3 RAC 重建 OCR 和 Voting Disk 案例
04-20
Oracle 11.2.0.3 RAC (Real Application Clusters) 是Oracle数据库的一个重要版本，它提供了高可用性和可伸缩性，允许数据库在多台服务器上共享和处理数据。在RAC环境中，OCR（Oracle Cluster Registry）和Voting ...
Oracle 11G 11.2.0.3 Client for windows 64位
12-13
11.2.0.3是11.2系列的一个维护更新，包含错误修复和性能改进。 - 在11g中，Oracle引入了高级特性，如自动存储管理（ASM）、实时应用集群（RAC）、数据仓库优化、SQL优化改进、安全管理增强等。 2. **Oracle客户端...
Oracle 11.2.0.3 RAC 安装 手册
04-20
以上就是Oracle 11.2.0.3 RAC的安装步骤和关键知识点。实际操作中，每个环节都需要谨慎对待，确保每个配置都正确无误，以实现高可用性的数据库环境。对于初学者，建议参考官方文档并配合实际操作进行学习，以便更好...
Oracle 11.2.0.3 RAC 与 RAC 之间搭建Data Guard 案例
04-20
总的来说，Oracle 11.2.0.3 RAC与RAC之间的Data Guard配置是提升数据库高可用性和数据安全性的有效途径。Aactive Data Guard的运用进一步提高了系统的利用率，使得备用数据库在保护生产环境的同时，也能承担一部分非...
Oracle RAC 更换存储实验
weixin_33963189的博客
08-17 265
实验环境准备： RHEL 6.5 + Oracle 11.2.0.4 RAC (2nodes) OCR和Voting Disk使用的是OCR1磁盘组，底层对应3个1G大小的共享LUN，一般冗余； DATA使用的是DATA1磁盘组，底层对应的是3个5G大小的共享LUN，外部冗余； FRA使用的是FRA1磁盘组，底层对应的是1个5G大小的共享LUN，外部冗余； 额外添加7个共享LUN(3个1G大小，...
Oracle更换存储磁盘,oracle RAC 更换存储迁移数据
weixin_39867893的博客
04-03 583
oracle RAC 更换存储迁移数据我们利用ASM rebalance特性实现更换存储迁移数据的需求基本 零宕机时间(操作步骤总结)1)保证新存储和RAC当前节点间的可用性；2)新存储划分LUN，可以重新规划存储方案；3)迁移OCR和表决盘4)给现有ASM磁盘组添加ASM磁盘(新存储分配的)，充分利用ASM REBALANCE技术5)删除原存储的ASM磁盘6)观察期1当前存储信息以下ASM磁盘组...
Oracle 11g rac 生产环境asm磁盘迁移
xwk19870212的博客
09-20 828
oracle 11g rac 生产环境asm磁盘迁移。
Oracle 11g RAC ASM VOTEDISK所在磁盘全部丢失重大故障恢复
05-14 540
Oracle 11g RAC ASM VOTEDISK所在磁盘全部丢失恢复 一、环境描述 系统：AIX 7100-02-03-1334 数据库：Oracle 11.2.0.3.10 RAC ASM 二、故...
redhat 6.4 oracle 11g rac 共享存储更换
hzcyhujw的博客
01-22 315
概述：本文是以前在日常维护中碰到的rac共享存储整个更换的过程做个记录；如有不全请测试，基本过程是正确的。在生产环境操作请先自行在测试环境测试后再实施。 关于EMC存储多路径在linux 6中的权限问题说明： 原来在linux6 里面如果要用这种方法做ASM的话。 需要在/etc/udev/rules.d 目录上新增了50-udev.rules 文件， redhat 5 下面就有这个文件，
ORACLE 10g RAC ocr、vote、data磁盘迁移
空自留的博客
04-11 446
检查DB服务器磁盘映射情况 [root@p550a:/dev]#mpio_get_config -Av Frame id 1: Storage Subsystem worldwide name: B_24325462452523523452352 Controller count: 2 Partition count: 1 Partition 0: St...
oracle 11g r2 rac修改ocr及votedisk所在磁盘组位置
Data & Analysis
05-25 1298
检查OCR盘信息： [root@s2-11g grid]# ocrcheck -config Oracle Cluster Registry configuration is : Device/File Name : +OCRVOT [root@s2-11g grid]# more /etc/oracle/ocr.loc ocrconfig_loc=+OCRVOT local_only=FALSE...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值