成人午夜视频全免费观看高清-秋霞福利视频一区二区三区-国产精品久久久久电影小说-亚洲不卡区三一区三区一区

更改votingdisk和OCR到其他asm磁盤組

1.查看ocr和votedisk
[oracle:/home/oracle:RACTEST1] ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3104
Available space (kbytes) : 259016
ID : 44728649
Device/File Name : +OCR1
Device/File integrity check succeeded

成都創(chuàng)新互聯(lián)主營(yíng)太平網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營(yíng)網(wǎng)站建設(shè)方案,成都app軟件開發(fā)公司,太平h5重慶小程序開發(fā)公司搭建,太平網(wǎng)站營(yíng)銷推廣歡迎太平等地區(qū)企業(yè)咨詢

                                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

[oracle:/home/oracle:RACTEST1] crsctl query css votedisk
*## STATE File Universal Id File Name Disk group


  1. ONLINE a5ef8885d1564f99bf0e0d77286c3b1f (/dev/oracleasm/disks/OCR11) [OCR1]
    Located 1 voting disk(s).

SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;

GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT


       1 DATA               512              1048576 MOUNTED    EXTERN     N
       2 OCR1               512              1048576 MOUNTED    EXTERN     Y

2.創(chuàng)建新的ASM diskgroup(asmca圖形界面創(chuàng)建)
create diskgroup OCR normal redundancy disk '/dev/oracleasm/disks/OCR01','/dev/oracleasm/disks/OCR02','/dev/oracleasm/disks/OCR03' attribute 'compatible.asm'='11.2';

SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;

GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT


       1 DATA               512              1048576 MOUNTED    EXTERN     N
       2 OCR1               512              1048576 MOUNTED    EXTERN     Y
       3 OCR                512              1048576 MOUNTED    NORMAL     N

3.votedisk從+OCR1 更改到 +OCR
[oracle:/home/oracle:RACTEST1] crsctl replace votedisk +OCR
Successful addition of voting disk 9b4ac868901f4f89bf191e59baa3442b.
Successful addition of voting disk 2c2eff1ca2ad4f7bbfcdf8fc913dcc45.
Successful addition of voting disk 652d503ff1154fd6bfdfe3273a12d529.
Successful deletion of voting disk a5ef8885d1564f99bf0e0d77286c3b1f.
Successfully replaced voting disk group with +OCR.
CRS-4266: Voting file(s) successfully replaced
[oracle:/home/oracle:RACTEST1] crsctl query css votedisk
*## STATE File Universal Id File Name Disk group


  1. ONLINE 9b4ac868901f4f89bf191e59baa3442b (/dev/oracleasm/disks/OCR01) [OCR]
  2. ONLINE 2c2eff1ca2ad4f7bbfcdf8fc913dcc45 (/dev/oracleasm/disks/OCR02) [OCR]
  3. ONLINE 652d503ff1154fd6bfdfe3273a12d529 (/dev/oracleasm/disks/OCR03) [OCR]
    Located 3 voting disk(s).

4.更改ocr
[root@ractest1 disks]# ocrconfig -add +OCR
[root@ractest1 disks]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3108
Available space (kbytes) : 259012
ID : 44728649
Device/File Name : +OCR1
Device/File integrity check succeeded
Device/File Name : +OCR
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@ractest1 disks]# ocrconfig -delete +OCR1
[root@ractest1 disks]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3108
Available space (kbytes) : 259012
ID : 44728649
Device/File Name : +OCR
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    

5.查看asm參數(shù)文件存放的位置并修改到+OCR上
SQL> show parameter spfile

NAME TYPE VALUE


spfile string +OCR1/ractest-cluster/asmparam
eterfile/registry.253.10297677
13

SQL> create pfile='/oracle/app/product/grid/dbs/pfile_ASM1.ora' from spfile;

File created.

SQL> create spfile='+OCR' from pfile='/oracle/app/product/grid/dbs/pfile_ASM1.ora';

File created.

SQL> show parameter spfile

NAME TYPE VALUE


spfile string +OCR1/ractest-cluster/asmparam
eterfile/registry.253.10297677
13

6.一節(jié)點(diǎn)重啟crs
[root@ractest1 disks]# crsctl stop crs
[root@ractest1 disks]# crsctl start crs
[root@ractest1 disks]# su - oracle
[oracle:/home/oracle:RACTEST1] srvctl start instance -d RACTEST -n ractest1
[oracle:/home/oracle:RACTEST1] crs
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
*--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE ractest1
ONLINE ONLINE ractest2
ora.LISTENER.lsnr
ONLINE ONLINE ractest1
ONLINE ONLINE ractest2
ora.OCR.dg
ONLINE ONLINE ractest1
ONLINE ONLINE ractest2
ora.OCR1.dg
ONLINE ONLINE ractest1
ONLINE ONLINE ractest2
ora.asm
ONLINE ONLINE ractest1 Started
ONLINE ONLINE ractest2 Started
ora.gsd
OFFLINE OFFLINE ractest1
OFFLINE OFFLINE ractest2
ora.net1.network
ONLINE ONLINE ractest1
ONLINE ONLINE ractest2
ora.ons
ONLINE ONLINE ractest1
ONLINE ONLINE ractest2
ora.registry.acfs
ONLINE ONLINE ractest1
ONLINE ONLINE ractest2

Cluster Resources

ora.cvu
1 ONLINE ONLINE ractest2
ora.oc4j
1 OFFLINE OFFLINE
ora.ractest.db
1 ONLINE ONLINE ractest1 Open
2 ONLINE ONLINE ractest2 Open
ora.ractest1.vip
1 ONLINE ONLINE ractest1
ora.ractest2.vip
1 ONLINE ONLINE ractest2
ora.testdb.db
1 ONLINE OFFLINE Instance Shutdown

SQL> show parameter spfile

NAME TYPE VALUE


spfile string +OCR/ractest-cluster/asmparame
terfile/registry.253.102983977
5

7.2節(jié)點(diǎn)重啟crs
[root@ractest2 ~]# crsctl stop crs
[root@ractest2 ~]# crsctl start crs
[root@ractest2 ~]# su - oracle
[oracle:/home/oracle:RACTEST2] srvctl start instance -d RACTEST -n ractest2
SQL> show parameter spfile

NAME TYPE VALUE


spfile string +OCR/ractest-cluster/asmparame
terfile/registry.253.102983977
5

8.刪除 +OCR1

SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;
GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT


       1 DATA               512              1048576 MOUNTED                           EXTERN             N
       2 OCR1               512              1048576 MOUNTED                           EXTERN             N
       3 OCR                512              1048576 MOUNTED                           NORMAL             Y

SQL> drop diskgroup OCR1 including contents;
drop diskgroup OCR1 including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15073: diskgroup OCR1 is mounted by another ASM instance

SQL> alter diskgroup OCR1 dismount;

Diskgroup altered.

SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;

GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT


       1 DATA               512              1048576 MOUNTED                           EXTERN             N
       0 OCR1                 0                    0 DISMOUNTED                                           N
       3 OCR                512              1048576 MOUNTED                           NORMAL             Y

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

SQL> alter diskgroup OCR1 mount;

Diskgroup altered.

SQL> drop diskgroup OCR1 including contents;

Diskgroup dropped.

SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;

GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT


       1 DATA               512              1048576 MOUNTED                           EXTERN             N
       3 OCR                512              1048576 MOUNTED                           NORMAL             Y

2節(jié)點(diǎn)查看:
SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;

GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT


       1 DATA                                                                                               512              1048576 MOUNTED                           EXTERN             N
       3 OCR                                                                                                512              1048576 MOUNTED                           NORMAL             Y                    

9.最后在2個(gè)節(jié)點(diǎn)都查看一下
[oracle:/home/oracle:+ASM1] crsctl query css votedisk
*## STATE File Universal Id File Name Disk group


  1. ONLINE 9b4ac868901f4f89bf191e59baa3442b (/dev/oracleasm/disks/OCR01) [OCR]
  2. ONLINE 2c2eff1ca2ad4f7bbfcdf8fc913dcc45 (/dev/oracleasm/disks/OCR02) [OCR]
  3. ONLINE 652d503ff1154fd6bfdfe3273a12d529 (/dev/oracleasm/disks/OCR03) [OCR]
    Located 3 voting disk(s).
    [oracle:/home/oracle:+ASM1] ocrcheck
    Status of Oracle Cluster Registry is as follows :
    Version : 3
    Total space (kbytes) : 262120
    Used space (kbytes) : 3088
    Available space (kbytes) : 259032
    ID : 44728649
    Device/File Name : +OCR
    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

[oracle:/home/oracle:+ASM2] crsctl query css votedisk
*## STATE File Universal Id File Name Disk group


  1. ONLINE 9b4ac868901f4f89bf191e59baa3442b (/dev/oracleasm/disks/OCR01) [OCR]
  2. ONLINE 2c2eff1ca2ad4f7bbfcdf8fc913dcc45 (/dev/oracleasm/disks/OCR02) [OCR]
  3. ONLINE 652d503ff1154fd6bfdfe3273a12d529 (/dev/oracleasm/disks/OCR03) [OCR]
    Located 3 voting disk(s).
    [oracle:/home/oracle:+ASM2] ocrcheck
    Status of Oracle Cluster Registry is as follows :
    Version : 3
    Total space (kbytes) : 262120
    Used space (kbytes) : 3088
    Available space (kbytes) : 259032
    ID : 44728649
    Device/File Name : +OCR
    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

網(wǎng)站欄目:更改votingdisk和OCR到其他asm磁盤組
本文地址:http://jinyejixie.com/article0/gpgdoo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供關(guān)鍵詞優(yōu)化、手機(jī)網(wǎng)站建設(shè)、定制網(wǎng)站企業(yè)網(wǎng)站制作、App開發(fā)、全網(wǎng)營(yíng)銷推廣

廣告

聲明:本網(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)站建設(shè)網(wǎng)站維護(hù)公司
丰城市| 沙坪坝区| 宁陕县| 桐梓县| 上高县| 雷波县| 灵武市| 宜宾市| 班戈县| 镇原县| 常德市| 青铜峡市| 隆子县| 丹巴县| 池州市| 城步| 上栗县| 武邑县| 福鼎市| 五家渠市| 尉氏县| 景泰县| 封丘县| 班戈县| 抚远县| 益阳市| 西林县| 安康市| 玉门市| 苍南县| 即墨市| 浠水县| 淅川县| 华蓥市| 闽侯县| 灵丘县| 唐海县| 额敏县| 武定县| 简阳市| 双辽市|