Oracle 11g uses ASM storage migration

I. Environment Description RHEL 6.6 + Oracle 11.2.0.4 storage replacement, need to add a new disk, replace the old storage disk, the following is the test steps. II. test process [[[email protected] ~]# cd/etc/udev[[email protected] udev]# lsmakedev.d rules.d udev.conf[[email  protected] udev]# CD rules.d/[[email protected] rules.d]# ls55-usm.rules 60-pcmcia.rules 70- Persistent-net.rules 98-kexec.rules60-fprint-autosuspend.rules 60-raw.rules 90-alsa.rules 99- Oracle-asmdevices.rules60-openct.rules 70-persistent-cd.rules 90-hal.rules[[email protected] rules.d]# cat 99- Oracle-asmdevices.rules kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace-- device=/dev/$name ", result==" 1ata_vbox_harddisk_vb134477b8-eb4c906a ", name=" ASM-DISKB ", owner=" grid ", GROUP=" Asmadmin ", mode=" 0660 "????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name", RESULT= = "1ata_vbox_harddisk_vb02fff4da-d0a0c3a3", name= "ASM-DISKC", owner= "grid", group= "Asmadmin", mode= "0660"????? kernel== "sd*", bus== "scsi", program== "/SBin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name ", result==" 1ata_vbox_harddisk_ vbdfa1c4b9-379f6810 ", name=" ASM-DISKD ", owner=" grid ", group=" Asmadmin ", mode=" 0660 "????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name", RESULT= = "1ata_vbox_harddisk_vb47ca97bf-4f2e68c0", name= "Asm-diske", owner= "grid", group= "Asmadmin", mode= "0660"????? [[email protected] rules.d]# [[email protected] rules.d]# # #添加一块新盘 [[email protected] rules.d]# Scsi_ ID--whitelisted--replace-whitespace--device=/dev/sdf1ata_vbox_harddisk_vbf00cea14-af091329[[email  protected] rules.d]# [[email protected] rules.d]# [[email protected] rules.d]# [[email protected] rules.d]# ls55-usm.rules 60-pcmcia.rules 70-persistent-net.rules 98-kexec.rules60-fprint-autosuspend.rules 60- Raw.rules 90-alsa.rules 99-oracle-asmdevices.rules60-openct.rules 70-persistent-cd.rules 90-hal.rules# #修改配置文件 [[ Email protected] rules.d]# VI 99-oracle-asmdevices.rules kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace-- device=/dev/$name ", result==" 1ata_vbox_harddisk_vb134477b8-eb4c906a ", name=" ASM-DISKB ", owner=" grid ", GROUP=" Asmadmin ", mode=" 0660 "?????????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name", RESULT= = "1ata_vbox_harddisk_vb02fff4da-d0a0c3a3", name= "ASM-DISKC", owner= "grid", group= "Asmadmin", mode= "0660"?????????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name", RESULT= = "1ata_vbox_harddisk_vbdfa1c4b9-379f6810", name= "ASM-DISKD", owner= "grid", group= "Asmadmin", mode= "0660"?????????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name", RESULT= = "1ata_vbox_harddisk_vb47ca97bf-4f2e68c0", name= "Asm-diske", owner= "grid", group= "Asmadmin", mode= "0660"?????????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--Whitelisted--replace-whitespace--device=/dev/$name ", result==" 1ata_vbox_harddisk_vbf00cea14-af091329 ", NAME=" ASM-DISKF ", owner=" grid ", group=" Asmadmin ", mode=" 0660 "??????? ~ # #传输到节点2 ~ SCP 99-oracle-asmdevices.rules to rac2[[email protected] rules.d]# cat 99-oracle-asmdevices.rules kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name", RESULT= = "1ata_vbox_harddisk_vb134477b8-eb4c906a", name= "ASM-DISKB", owner= "grid", group= "Asmadmin", mode= "0660"????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name", RESULT= = "1ata_vbox_harddisk_vb02fff4da-d0a0c3a3", name= "ASM-DISKC", owner= "grid", group= "Asmadmin", mode= "0660"????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name", RESULT= = "1ata_vbox_harddisk_vbdfa1c4b9-379f6810", name= "ASM-DISKD", owner= "grid", group= "Asmadmin", mode= "0660"????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name ", result==" 1ata_vbox_harddisk_ Vb47ca97bf-4f2e68c0 ", name=" Asm-diske ", owner=" grid ", group=" Asmadmin ", mode=" 0660 "????? kernel== "sd*", bus== "scsi", program== "/sbin/scsi_id--whitelisted--replace-whitespace--device=/dev/$name", RESULT= = "1ata_vbox_harddisk_vbf00cea14-af091329", name= "ASM-DISKF", owner= "grid", group= "Asmadmin", mode= "0660"????? [[email protected] rules.d]# [[email protected] rules.d]# [[email protected] rules.d]# # #重启udev服务, Load configuration file [[email protected] rules.d]# Start_udev starting udev:udevd[5477]: GOTO ' PULSEAUDIO_CHECK_USB ' has no Matching label in: '/lib/udev/rules.d/90-pulseaudio.rules ' # #生产/DEV/ASM-DISKF [OK][[email protected] rules.d]# Ls-l/DEV/ASM*BRW-RW----1 grid asmadmin 8, Jan 19:36/dev/asm-diskbbrw-rw----1 grid asmadmin 8, Jan 30 19:36/ DEV/ASM-DISKCBRW-RW----1 grid asmadmin 8, 19:36/DEV/ASM-DISKDBRW-RW,----1 grid asmadmin 8, from Jan 19:36/de V/ASM-DISKEBRW-RW----1 grid asmadmin 8, Jan 19:36/dev/asm-diskf/dev/asm:total 0# #查看asm磁盘SQL > col name for A40sql > Set line 200sql> Select Name,path,state,header_status from V$asm_disk;name path State header_ STATUS--------------------------------------------------------------------------------------------------------- ---------------/DEV/ASM-DISKF Normal candidate--the disk to be added CRSDG_0002/DEV/ASM-DISKD normal membercrsdg_0000/dev/ ASM-DISKB normal Memberdatadg_0000/dev/asm-diske normal MEMBERCRSDG_0001/DEV/ASM-DISKC normal member## Use SYSASM to add disks alter DiskGroup DATADG add disk '/DEV/ASM-DISKF '; # #加快平衡速度, power=0 is stop rebalance operation, 11alter DiskGroup is not recommended DATADG rebalance Power 11; sql> alter DiskGroup DATADG rebalance power 11;diskgroup altered. Sql> select * from V$asm_operation; Group_number Operation State POWER ACTUAL sofar est_work est_rate est_minutes error_code------------------------------- --------- ---------- ---------- ---------- ---------- ----------- ----------------------------------------------------------------------------------------2 rebal RUN 0 0sql> # # Continue to view disk status, added complete col name for A15col path for A15col, A10set line 200select mode_status,header_status, mode_status,s Tate,total_mb,free_mb,name,path from V$asm_disk; Sql> col name for a15sql> Col path for a15sql> Col State for a10sql> set line 200sql> Select Mode_status,he Ader_status, Mode_status,state,total_mb,free_mb,name,path from V$asm_disk; Mode_status header_status mode_status State total_mb free_mb NAME PATH----------------------------------------------- -----------------------------------------------------------------online MEMBER online NORMAL 4096 3787 crsdg_0002/de V/asm-diskeonline MEMBER Online normal 4096 3788 crsdg_0001/dev/asm-diskdonline MEMBER ONLINE normal 6144 3977 datadg_000 0/dev/asm-diskbonline MEMBER Online normal 4096 3787 crsdg_0000/dev/asm-diskconline MEMBER ONLINE normal 8192 5306 Datad G_0001/dev/asm-diskfsql> # #删除Disk alter DiskGroup DATADG drop disk ' datadg_0000 '; --delete alter DiskGroup DATADG rebalance power 11;col error_code for A5set line 200select * from v$asm_operation;# #查看平衡 by name Speed sql> col error_code for a5sql> set line 200sql> select * from V$asm_operation; Group_number Operation State POWER ACTUAL sofar est_work est_rate est_minutes ERROR------------------------------------ ------------------------------------------------------------2 rebal RUN one 768 2334 0sql> sql> col Name For a15sql> Col Path to a15sql> Col State for a10sql> set line 200sql> select Mode_status,header_status, MOD E_status,state,total_mb,free_mb,name,path from V$asm_disk; Mode_status header_status mode_status State total_mb free_mb NAME PATH----------------------------------------------- -----------------------------------------------------------------online FORMER online NORMAL 0 0/dev/asm-diske # #已删除 ONLINE MEMBER online NORMAL 4096 3788 crsdg_0001/dev/asm-diskconline MEMBER ONLINE normal 4096 3787 crsdg_0000/dev/asm-diskbonline MEMBER ONLINE normal 8192 3095 datadg_0001/dev/asm-diskfonline MEMBER ONLINE NORMAL 4096 3787 crsdg_0002/dev/asm-diskdsql>

Oracle 11g uses ASM storage migration