ASM磁盘组异机迁移 - 数据库编程

lace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules done start_udev [root@zbdba1 ~]# ls /dev/asm* /dev/asm-diskb /dev/asm-diskc /dev/asm-diskd /dev/asm-diske /dev/asm-diskf [root@zbdba2 ~]# ls /dev/asm* /dev/asm-diskb /dev/asm-diskc /dev/asm-diskd /dev/asm-diske /dev/asm-diskf 磁盘映射与原库一样的名字了。

查看磁盘组：

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  NORMAL  N         512   4096  1048576      6144     5218             2048            1585              0             Y  DATA/
ASMCMD>

5、修改ASM参数文件

[grid@zbdba1 dbs]$ more init+ASM1.ora
*.asm_diskstring='/dev/asm*'
*.asm_power_limit=1
*.diagnostic_dest='/opt/ogrid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
改为：
[grid@zbdba1 dbs]$ more init+ASM1.ora 
+ASM1.asm_diskgroups='ZBDBA'#Manual Mount
+ASM2.asm_diskgroups='ZBDBA'#Manual Mount
*.asm_diskstring='/dev/asm*'
*.asm_power_limit=1
*.diagnostic_dest='/opt/ogrid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
 
[grid@zbdba1 dbs]$ pwd
/opt/grid/products/11.2.0/dbs
SQL> startup pfile='init+ASM1.ora'
ASM instance started

Total System Global Area 1135747072 bytes
Fixed Size                  2260728 bytes
Variable Size            1108320520 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled

查看启动日志：

Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options.
ORACLE_HOME = /opt/grid/products/11.2.0
System name:    Linux
Node name:      zbdba1
Release:        2.6.32-279.el6.x86_64
Version:        #1 SMP Wed Jun 13 18:24:36 EDT 2012
Machine:        x86_64
Using parameter settings in server-side spfile +DATA/node-cluster/asmparameterfile/registry.253.871094907
System parameters with non-default values:
  large_pool_size          = 12M
  instance_type            = "asm"
  remote_login_passwordfile= "EXCLUSIVE"
  asm_diskstring           = "/dev/asm*"
  asm_diskgroups           = "ZBDBA"
  asm_power_limit          = 1
  diagnostic_dest          = "/opt/ogrid"
Cluster communication is configured to use the following interface(s) for this instance
  169.254.126.87
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sun Feb 08 02:49:44 2015
PMON started with pid=2, OS id=11140
Sun Feb 08 02:49:44 2015
PSP0 started with pid=3, OS id=11143
Sun Feb 08 02:49:45 2015
VKTM started with pid=4, OS id=11156 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sun Feb 08 02:49:45 2015
GEN0 started with pid=5, OS id=11160
Sun Feb 08 02:49:45 2015
DIAG started with pid=6, OS id=11162
Sun Feb 08 02:49:45 2015
PING started with pid=7, OS id=11164
Sun Feb 08 02:49:45 2015
DIA0 started with pid=8, OS id=11166
Sun Feb 08 02:49:45 2015
LMON started with pid=9, OS id=11168
Sun Feb 08 02:49:45 2015
LMD0 started with pid=10, OS id=11170
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [960 - 1280]
Sun Feb 08 02:49:45 2015
LMS0 started with pid=11, OS id=11172 at elevated priority
Sun Feb 08 02:49:45 2015
LMHB started with pid=12, OS id=11176
Sun Feb 08 02:49:45 2015
MMAN started with pid=13, OS id=1

ASM磁盘组异机迁移(二)