欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

oracle怎么移動(dòng)OCR,VoteFile,ASMSPILE到新的磁盤(pán)組

本篇內(nèi)容主要講解“oracle怎么移動(dòng)OCR , Vote File , ASM SPILE到新的磁盤(pán)組”，感興趣的朋友不妨來(lái)看看。本文介紹的方法操作簡(jiǎn)單快捷，實(shí)用性強(qiáng)。下面就讓小編來(lái)帶大家學(xué)習(xí)“oracle怎么移動(dòng)OCR , Vote File , ASM SPILE到新的磁盤(pán)組”吧!

創(chuàng)新互聯(lián)建站堅(jiān)持“要么做到，要么別承諾”的工作理念，服務(wù)領(lǐng)域包括：網(wǎng)站設(shè)計(jì)、成都網(wǎng)站建設(shè)、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣等服務(wù)，滿足客戶于互聯(lián)網(wǎng)時(shí)代的臨桂網(wǎng)站設(shè)計(jì)、移動(dòng)媒體設(shè)計(jì)的需求，幫助企業(yè)找到有效的互聯(lián)網(wǎng)解決方案。努力成為您成熟可靠的網(wǎng)絡(luò)建設(shè)合作伙伴！

在11GR2的環(huán)境下，將rac的OCR , Vote File , ASM SPILE遷移到到新的磁盤(pán)組。

現(xiàn)在的磁盤(pán)狀態(tài)：

[root@rac1 ~]# crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

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

 1. ONLINE   0c9ec99614ed4fe4bfdba4cb520dd00e (/dev/raw/raw1) [OCRVOTING]

Located 1 voting  disk(s).

[root@rac1 ~]#  ocrcheck

Status of Oracle  Cluster Registry is as follows :

Version                  :          3

Total space (kbytes)     :     262120

Used space (kbytes)      :       2544

Available space (kbytes) :     259576

ID                       :  827782161

 Device/File Name         : +OCRVOTING

                                    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

SQL> set line 300

SQL> col  failgroup for a40

SQL> col name  for a30

SQL> select  DISK_NUMBER,REDUNDANCY,name,FAILGROUP,VOTING_FILE from v$asm_disk;

DISK_NUMBER REDUNDANCY NAME            FAILGROUP        VOT

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

          1 UNKNOWN    OCRVOTING_0001  OCRVOTING_0001   N

          0 UNKNOWN    RAC_DATA_0000   RAC_DATA_0000    N

          0 UNKNOWN    OCRVOTING_0000  OCRVOTING_0000   Y

          2 UNKNOWN    OCRVOTING_0002  OCRVOTING_0002   N

SQL> select  name,total_mb,free_mb,usable_file_mb from v$asm_diskgroup;

 

NAME            TOTAL_MB    FREE_MB USABLE_FILE_MB

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

OCRVOTING           2997       2597           2597

RAC_DATA            9993       8077           8077   

 

可以看到，ocr磁盤(pán)組冗余度為external，而且是使用的裸設(shè)備，下面將ocr磁盤(pán)組移動(dòng)到冗余度為normal類(lèi)型的磁盤(pán)組里。

首先分配三塊盤(pán)，因?yàn)槭亲约旱臏y(cè)試環(huán)境，不需要太大，每塊盤(pán)1G就可以。

創(chuàng)建共享磁盤(pán)

Cmd命令：

vmware-vdiskmanager.exe  -c -s 1000Mb -a lsilogic -t 2 F:\RAC\sharedisk\ocrdisk01.vmdk

vmware-vdiskmanager.exe  -c -s 1000Mb -a lsilogic -t 2 F:\RAC\sharedisk\ocrdisk02.vmdk

vmware-vdiskmanager.exe  -c -s 1000Mb -a lsilogic -t 2 F:\RAC\sharedisk\ocrdisk03.vmdk

 

兩個(gè)虛擬機(jī)配置文件追加如下內(nèi)容

scsi1:5.present  = "TRUE"

scsi1:5.mode =  "independent-persistent"

scsi1:5.filename  = "F:\RAC\sharedisk\ocrdisk01.vmdk"

scsi1:5.deviceType  = "plainDisk"

 

scsi1:6.present  = "TRUE"

scsi1:6.mode =  "independent-persistent"

scsi1:6.filename  = "F:\RAC\sharedisk\ocrdisk02.vmdk"

scsi1:6.deviceType  = "plainDisk"

 

scsi1:8.present  = "TRUE"

scsi1:8.mode =  "independent-persistent"

scsi1:8.filename  = "F:\RAC\sharedisk\ocrdisk03.vmdk"

scsi1:8.deviceType  = "plainDisk"

 

注意這里不能用7,7是系統(tǒng)保留的，不可用。

查看新增盤(pán):

[root@rac1 ~]#  fdisk -l|grep sd

Disk /dev/sda:  19.3 GB, 19327352832 bytes

/dev/sda1   *           1          64      512000   83  Linux

/dev/sda2              64        1306     9972736   8e  Linux LVM

/dev/sda3            1306        1566     2093135   8e  Linux LVM

/dev/sda4            1567        2349     6289447+  8e  Linux LVM

Disk /dev/sdb:  1048 MB, 1048576000 bytes

/dev/sdb1               1        1000     1023984   83  Linux

Disk /dev/sdc:  1048 MB, 1048576000 bytes

/dev/sdc1               1        1000     1023984   83  Linux

Disk /dev/sdd:  10.5 GB, 10485760000 bytes

/dev/sdd1               1        1274    10233373+  83  Linux

Disk /dev/sde:  1048 MB, 1048576000 bytes

/dev/sde1               1        1000     1023984   83  Linux

Disk /dev/sdf:  1048 MB, 1048576000 bytes

Disk /dev/sdg:  1048 MB, 1048576000 bytes

Disk /dev/sdh:  1048 MB, 1048576000 bytes

 

sdf,sdg,sdh是我們新分配的三塊盤(pán)。

編輯60-raw.rules文件：

[root@rac1  rules.d]# more 60-raw.rules

# Enter raw  device bindings here.

#

# An example  would be:

#   ACTION=="add", KERNEL=="sda", RUN+="/bin/raw  /dev/raw/raw1 %N"

# to bind  /dev/raw/raw1 to /dev/sda, or

#   ACTION=="add",  ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw  /dev/raw/raw2 %M %m"

# to bind  /dev/raw/raw2 to the device with major 8, minor 1.

ACTION=="add",  KERNEL=="sdb1",RUN+="/bin/raw /dev/raw/raw1 %N"

ACTION=="add",  KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw2 %N"

ACTION=="add",  KERNEL=="sdd1",RUN+="/bin/raw /dev/raw/raw3 %N"

ACTION=="add",  KERNEL=="sde1",RUN+="/bin/raw /dev/raw/raw4 %N"

ACTION=="add",  KERNEL=="sdf",RUN+="/bin/raw /dev/raw/raw5 %N"

ACTION=="add",  KERNEL=="sdg",RUN+="/bin/raw /dev/raw/raw6 %N"

ACTION=="add",  KERNEL=="sdh",RUN+="/bin/raw /dev/raw/raw7 %N"

ACTION=="add",KERNEL=="raw[1-7]",  OWNER="grid", GROUP="oinstall", MODE="660"

重啟udev并檢查

[root@rac1 ~]#  start_udev

Starting udev:  [  OK  ]

[grid@rac1 ~]$  cd /dev/raw

[grid@rac1 raw]$  ll

total 0

crw-rw---- 1  grid oinstall 162, 1 Jun 10 23:44 raw1

crw-rw---- 1  grid oinstall 162, 2 Jun 10 23:43 raw2

crw-rw---- 1  grid oinstall 162, 3 Jun 10 23:43 raw3

crw-rw---- 1  grid oinstall 162, 4 Jun 10 23:43 raw4

crw-rw---- 1  grid oinstall 162, 5 Jun 10 23:43 raw5

crw-rw---- 1  grid oinstall 162, 6 Jun 10 23:43 raw6

crw-rw---- 1  grid oinstall 162, 7 Jun 10 23:43 raw7

crw-rw---- 1  root disk     162, 0 Jun 10 23:43  rawctl

 

圖形界面創(chuàng)建OCRDG,這部分比較簡(jiǎn)單省略:

[grid@rac1 raw]$ asmca

圖形界面創(chuàng)建成功之后，點(diǎn)擊了mount all，下面驗(yàn)證一下新創(chuàng)建的磁盤(pán)組是否已經(jīng)mount：

[grid@rac1 raw]$  sqlplus / as sysasm

SQL> col name  for a20

SQL> select  NAME,GROUP_NUMBER,STATE,type,TOTAL_MB,FREE_MB,usable_file_mb,VOTING_FILES  from v$asm_diskgroup;

 

NAME        GROUP_NUMBER STATE    TYPE      TOTAL_MB    FREE_MB  USABLE_FILE_MB VOT

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

OCRVOTING              1 MOUNTED  EXTERN        2997       2597           2597 N

RAC_DATA               2 MOUNTED  EXTERN        9993       8077           8077 N

OCRDG                  3 MOUNTED  NORMAL        3000       2715           1310 N

可以看到新創(chuàng)建的ocrdg磁盤(pán)組的狀態(tài)已經(jīng)mount，類(lèi)型是normal。

 

磁盤(pán)狀態(tài)：

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,NAME,VOTING_FILE  from v$asm_disk;

 

GROUP_NUMBER  DISK_NUMBER MOUNT_STATUS          NAME                 VOT

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

      1           2 CACHED                OCRVOTING_0002       N

      1           1 CACHED                OCRVOTING_0001       N

      1           0 CACHED                OCRVOTING_0000       Y

     2           0 CACHED                RAC_DATA_0000        N

      3           2 CACHED                OCRDG_0002           N

    3           1 CACHED                OCRDG_0001           N

     3           0 CACHED                OCRDG_0000           N

 

7 rows selected.

 

也可以用下面命令驗(yàn)證：

[grid@rac1 raw]$ asmcmd lsdg

asm pfile文件位置：

[grid@rac1 ~]$ asmcmd spget

+OCRVOTING/rac-cluster/asmparameterfile/registry.253.952478315

備份之前的OCR,OLR，單節(jié)點(diǎn):

[root@rac1  rules.d]# ocrconfig -manualbackup

[root@rac1  rules.d]# ocrconfig -local -manualbackup

將新磁盤(pán)組增加到OCR，root用戶：

[root@rac1 rules.d]# /tpsys/app/11.2.0/grid/bin/ocrconfig -add +OCRDG

檢查crs日志，命令行確認(rèn)：

此時(shí)的crs日志：

2018-06-12  06:19:30.517: [  OCRRAW][2996766464]propriowv_bootbuf: Vote information on disk 1  [+OCRDG] is adjusted from [0/0] to [1/2]

2018-06-12  06:19:30.546: [  OCRRAW][2996766464]propriowv_bootbuf:  Vote information on disk 0 [+OCRVOTING] is adjusted from [2/2] to [1/2]

 

[root@rac1  rules.d]# ocrcheck

Status of Oracle  Cluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       2596

         Available space (kbytes) :     259524

         ID                       :  827782161

         Device/File Name         : +OCRVOTING

                                    Device/File  integrity check succeeded

         Device/File Name         :     +OCRDG

                                    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

 

將舊的磁盤(pán)組踢出：

 [root@rac1 rules.d]# /tpsys/app/11.2.0/grid/bin/ocrconfig -delete +OCRVOTING

檢查crs日志，命令行確認(rèn)：

此時(shí)的crs日志：

2018-06-12  06:28:07.526: [  OCRRAW][2986276608]propriowv_bootbuf: Vote information on disk 1 [] is  adjusted from [1/2] to [2/2]

2018-06-12  06:28:07.647: [  OCRASM][2986276608]proprasmo: ASM cache size is [5MB]

2018-06-12  06:28:07.647: [  OCRASM][2986276608]proprasmo: ASM cache [5MB] enabled for disk group  [OCRDG].

2018-06-12  06:28:07.693: [  OCRRAW][2986276608]proprioo: for disk 0 (+OCRDG), id match (1), total  id sets, (2) need recover (0), my votes (2), total votes (2), commit_lsn (68),  lsn (68)

[root@rac1 rules.d]# ocrcheck

Status of Oracle  Cluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       2596

         Available space (kbytes) :     259524

         ID                       :  827782161

         Device/File Name         :     +OCRDG

                                    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

替換vote disk：

[root@rac1 rules.d]# crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

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

 1. ONLINE   0c9ec99614ed4fe4bfdba4cb520dd00e (/dev/raw/raw1) [OCRVOTING]

Located 1 voting  disk(s).         

 

[root@rac1 rules.d]#  /tpsys/app/11.2.0/grid/bin/crsctl replace votedisk +OCRDG

 

Successful  addition of voting disk 0a80756b9eb44f9abfae577e0e8ed2dd.

Successful  addition of voting disk 000808a364544f11bf48969149e2bf2a.

Successful  addition of voting disk 8714d5dd04634f70bf3bbd8ae1a467ac.

Successful  deletion of voting disk 0c9ec99614ed4fe4bfdba4cb520dd00e.

Successfully  replaced voting disk group with +OCRDG.

CRS-4266: Voting  file(s) successfully replaced

 

驗(yàn)證，root用戶：

[root@rac1 rules.d]# crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

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

 1. ONLINE   0a80756b9eb44f9abfae577e0e8ed2dd (/dev/raw/raw5) [OCRDG]

 2. ONLINE   000808a364544f11bf48969149e2bf2a (/dev/raw/raw6) [OCRDG]

 3. ONLINE   8714d5dd04634f70bf3bbd8ae1a467ac (/dev/raw/raw7) [OCRDG]

Located 3 voting  disk(s).

 

創(chuàng)建asm pfile到新的磁盤(pán)組：

[grid@rac1 ~]$  sqlplus / as sysasm

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

File created.

 

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

File created.

 

[grid@rac1 ~]$  asmcmd spget

+OCRDG/rac-cluster/asmparameterfile/registry.253.978589927

 

使用新的pfile文件重啟集群：

crsctl stop crs

crsctl start crs

[grid@rac2 ~]$ crsctl stat res -t

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

NAME           TARGET  STATE        SERVER                   STATE_DETAILS      

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

Local Resources

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

ora.LISTENER.lsnr

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.OCRDG.dg

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.OCRVOTING.dg

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.RAC_DATA.dg

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                        

ora.asm

               ONLINE  ONLINE       rac1                     Started            

               ONLINE  ONLINE       rac2                     Started             

ora.eons

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.gsd

               OFFLINE OFFLINE      rac1                                        

               OFFLINE OFFLINE      rac2                                        

ora.net1.network

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                        

ora.ons

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                         

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       rac1                                         

ora.oc4j

      1        OFFLINE OFFLINE                                                  

ora.rac1.vip

      1        ONLINE  ONLINE       rac1                                        

ora.rac2.vip

      1        ONLINE  ONLINE       rac2                                        

ora.ractest.db

      1        ONLINE  ONLINE       rac1                     Open               

      2        ONLINE  ONLINE       rac2                     Open               

ora.scan1.vip

      1        ONLINE  ONLINE       rac1                                        

成功完成！

到此，相信大家對(duì)“oracle怎么移動(dòng)OCR , Vote File , ASM SPILE到新的磁盤(pán)組”有了更深的了解，不妨來(lái)實(shí)際操作一番吧！這里是創(chuàng)新互聯(lián)網(wǎng)站，更多相關(guān)內(nèi)容可以進(jìn)入相關(guān)頻道進(jìn)行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！

本文名稱：oracle怎么移動(dòng)OCR,VoteFile,ASMSPILE到新的磁盤(pán)組
文章鏈接：http://chinadenli.net/article0/gohjoo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供做網(wǎng)站、動(dòng)態(tài)網(wǎng)站、云服務(wù)器、企業(yè)網(wǎng)站制作、定制網(wǎng)站、小程序開(kāi)發(fā)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)

網(wǎng)站托管運(yùn)營(yíng)