參照官方文件說明:如果asm庫diskgroup所屬的磁碟發生變化,對資料庫是沒有任何影響的,庫能正常開啟,因為oracle

是會檢查磁碟存放路徑ASM_DISKSTRING 引數和磁碟頭的,即磁碟頭不破壞的話,則沒有任何問題,以下為詳細官方文件說明:

Disk DiscoveryWhen an ASM instance initializes, ASM discovers and examines the contents of all of the disks that are in the paths designated in the ASM_DISKSTRING initialization parameter. For purposes of this discussion, a "disk" is an ASM disk as defined in [url=file:///D:/10.2.0.2文件/server.102/b14231/storeman.htm#i1021951]"Overview of the Components of Automatic Storage Management"[/url]. Disk discovery also takes place when you:

Run the ALTER DISKGROUP...ADD DISK and ALTER DISKGROUP...RESIZE DISK commands.
Query the V$ASM_DISKGROUP and V$ASM_DISK views.

After a disk is successfully discovered, it appears in the V$ASM_DISK view. Disks that belong to a disk group—that is, that have a disk group name in the disk header—have a header status of MEMBER. Disks that were discovered but that have not yet been assigned to a disk group have a header status of either CANDIDATE or PROVISIONED.

When an ASM instance starts, it automatically discovers all available ASM disks. Discovery is the process of determining every disk device to which the ASM instance has been given I/O permissions (by some operating system mechanism), and of examining the contents of the first block of such disks to see if they are recognized as belonging to a disk group. ASM discovers disks in the paths that are listed in an initialization parameter, or if the parameter is NULL, in an operating system–dependent default path.

下面為測試驗證過程:

p570b@root#mpio_get_config -Av
Frame. id 0:
Storage Subsystem worldwide name: 60ab8005112fe00004b6649ef
Controller count: 2
Partition count: 1
Partition 0:
Storage Subsystem Name = 'GDCDC_DS4700'
      hdisk    LUN # Ownership       User Label
      hdisk9       7 A (preferred)    Array0_lun16_5G
      hdisk10       8 A (preferred)    Array1_lun20_5G
      hdisk11       9 B (preferred)    Array0_lun15_60G
      hdisk12    10 A (preferred)    Array0_lun0_200G
      hdisk13    11 B (preferred)    Array0_lun1_200G
      hdisk14    12 A (preferred)    Array0_lun2_200G
      hdisk15    13 B (preferred)    Array0_lun3_200G
      hdisk16    14 A (preferred)    Array0_lun4_200G
      hdisk17    15 A (preferred)    Array1_lun0_200G
      hdisk18    16 B (preferred)    Array1_lun1_200G
      hdisk19    17 A (preferred)    Array1_lun2_200G
      hdisk20    18 B (preferred)    Array1_lun3_200G
      hdisk21    19 A (preferred)    Array1_lun4_200G
lspv
hdisk9       none                               None
hdisk10       none                               None
hdisk11       none                               None
hdisk12       none                               None
hdisk13       none                               None
hdisk14       none                               None
hdisk15       none                               None
hdisk16       none                               None
hdisk17       none                               None
hdisk18       none                               None
hdisk19       none                               None
hdisk20       none                               None
hdisk21       none                               None

asm磁碟組dg_data1使用到的磁碟
SQL> select total_mb,path,name from v$asm_disk;

  TOTAL_MB PATH                NAME
---------- -------------------- --------------------
      0 /dev/rhdisk15
      0 /dev/rhdisk16
      0 /dev/rhdisk19
      0 /dev/rhdisk20
      0 /dev/rhdisk21
   5120 /dev/rhdisk10       CRS_0000
   61440 /dev/rhdisk11       SYSDG_0000
204800 /dev/rhdisk12       DGRECOVER_0000
204800 /dev/rhdisk13       DG_DATA1_0000
204800 /dev/rhdisk14       DG_DATA1_0001
204800 /dev/rhdisk17       DG_DATA1_0002
204800 /dev/rhdisk18       DG_DATA1_0003
   5120 /dev/rhdisk9       CRS_0001

可以看到DG_data1磁碟組用到的磁碟組編號為rhdisk13,rhdisk14,rhdisk17,rhdisk18,對應的lun號
hdisk13    11 B (preferred)    Array0_lun1_200G
hdisk14    12 A (preferred)    Array0_lun2_200G
hdisk17    15 A (preferred)    Array1_lun0_200G
hdisk18    16 B (preferred)    Array1_lun1_200G

停止p570a,p570b節點上的crs
crsctl stop crs
現在從p570a,p570b節點上刪除

rmdev -dl hdisk15
rmdev -dl hdisk16
rmdev -dl hdisk17
rmdev -dl hdisk18
rmdev -dl hdisk19
rmdev -dl hdisk20
rmdev -dl hdisk21

儲存上刪除hdisk15,hdisk16兩個lun,不讓p570a,p570b節點認到
hdisk15    13 B (preferred)    Array0_lun3_200G
hdisk16    14 A (preferred)    Array0_lun4_200G

然後再p570a,p570b上重新cfgmgr -v
lspv
hdisk9       none                               None
hdisk10       none                               None
hdisk11       none                               None
hdisk12       none                               None
hdisk13       none                               None
hdisk14       none                               None
hdisk15       none                               None
hdisk16       none                               None
hdisk17       none                               None
hdisk18       none                               None
hdisk19       none                               None

p570b@root#mpio_get_config -Av
Frame. id 0:
Storage Subsystem worldwide name: 60ab8005112fe00004b6649ef
Controller count: 2
Partition count: 1
Partition 0:
Storage Subsystem Name = 'GDCDC_DS4700'
      hdisk    LUN # Ownership       User Label
      hdisk9       7 A (preferred)    Array0_lun16_5G
      hdisk10       8 A (preferred)    Array1_lun20_5G
      hdisk11       9 B (preferred)    Array0_lun15_60G
      hdisk12    10 A (preferred)    Array0_lun0_200G
      hdisk13    11 B (preferred)    Array0_lun1_200G
      hdisk14    12 A (preferred)    Array0_lun2_200G
      hdisk15    15 A (preferred)    Array1_lun0_200G
      hdisk16    16 B (preferred)    Array1_lun1_200G
      hdisk17    17 A (preferred)    Array1_lun2_200G
      hdisk18    18 B (preferred)    Array1_lun3_200G
      hdisk19    19 A (preferred)    Array1_lun4_200G

可以看到hdisk15,hdisk16,就是原來hdisk17,hdisk18所對應的lun號

重新賦予許可權
chown grid:asmadmin /dev/rhdisk15
chown grid:asmadmin /dev/rhdisk16
chown grid:asmadmin /dev/rhdisk17
chown grid:asmadmin /dev/rhdisk18
chown grid:asmadmin /dev/rhdisk19

chmod 660 /dev/rhdisk15
chmod 660 /dev/rhdisk16
chmod 660 /dev/rhdisk17
chmod 660 /dev/rhdisk18
chmod 660 /dev/rhdisk19

/usr/sbin/chdev -l hdisk15 -a reserve_policy=no_reserve
/usr/sbin/chdev -l hdisk16 -a reserve_policy=no_reserve
/usr/sbin/chdev -l hdisk17 -a reserve_policy=no_reserve
/usr/sbin/chdev -l hdisk18 -a reserve_policy=no_reserve
/usr/sbin/chdev -l hdisk19 -a reserve_policy=no_reserve

然後兩個節點啟動crs
可以看到dg_data1 online,並且資料庫已經開啟
[grid@p570b:/grid/app]$r
crsctl status resource -t
--------------------------------------------------------------------------------
NAME          TARGET  STATE       SERVER                STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
            ONLINE  ONLINE    p570b
ora.DGRECOVER.dg
            ONLINE  ONLINE    p570b
ora.DG_DATA1.dg
            ONLINE  ONLINE    p570b
ora.gdcdc.db
   1       ONLINE  ONLINE    p570a                            open
   2       ONLINE  ONLINE    p570b                            open


這時查詢v$asm_disk

SQL> select path,name from v$asm_disk;

PATH                NAME
-------------------- --------------------
/dev/rhdisk17
/dev/rhdisk18
/dev/rhdisk19
/dev/rhdisk10       CRS_0000
/dev/rhdisk11       SYSDG_0000
/dev/rhdisk12       DGRECOVER_0000
/dev/rhdisk13       DG_DATA1_0000
/dev/rhdisk14       DG_DATA1_0001
/dev/rhdisk15       DG_DATA1_0002
/dev/rhdisk16       DG_DATA1_0003
/dev/rhdisk9       CRS_0001

可以看出hdisk磁碟發生變化

asm diskgroup 磁碟編號發生變化資料庫能正常開啟的測試

相關文章