1,备份数据库。
2.2 扫描磁盘
echo 1 > /sys/class/fc_host/host3/issue_lip
echo 1 > /sys/class/fc_host/host4/issue_lip
3,更改磁盘属性
chown oracle:oinstall /dev/mapper/3PART*
4,备份ocr
./ocrconfig -manualbackup
./ocrconfig -showbackup
5,新建asm磁盘组
create diskgroup SYSDG external redundancy disk '/dev/mapper/3PARVOT01','/dev/mapper/3PARVOT02','/dev/mapper/3PARVOT03';
6,迁移votedisk
crsctl query css votedisk
crsctl replace votedisk +SYSDG
crsctl query css votedisk
7,迁移ocr
ocrcheck
ocrconfig -add +SYSDG
ocrconfig -delete +DATA
ocrcheck
8,迁移asmspfile
sqlplus / as sysasm
show parameter spfile
create pfile='/home/oracle/asmpfilebak.ora' from spfile;
create spfile='+SYSDG' from pfile='/home/oracle/asmpfilebak.ora'
9,更换asm磁盘到新存储
alter diskgroup DATA
add disk
'/dev/mapper/3PARDATA01',
'/dev/mapper/3PARDATA02',
'/dev/mapper/3PARDATA03',
'/dev/mapper/3PARDATA04',
'/dev/mapper/3PARDATA05',
drop disk
DATA_0000,DATA_0001,DATA_0002,DATA_003,DATA_0004 rebalance power 11;
alter diskgroup DATA02
add disk
'/dev/mapper/3PARDATA06',
'/dev/mapper/3PARDATA07',
'/dev/mapper/3PARDATA08',
'/dev/mapper/3PARDATA09',
'/dev/mapper/3PARDATA10',
'/dev/mapper/3PARDATA11',
'/dev/mapper/3PARDATA12',
drop disk
DATA_0005,DATA_0006,DATA_007,DATA_0008,DATA_0009,DATA_0010,DATA02_0006 rebalance power 11;
10,检查集群和数据库状态
crsctl stat res -t
11,添加新磁盘到磁盘组
alter diskgroup DATA02 add disk '/dev/mapper/3PARDATA13' rebalance power 10;
alter diskgroup DATA add disk '/dev/mapper/3PARDATA14' rebalance power 10;
12,检查集群状态,启动数据库
检查机器状态
crsctl stat res -t
启动数据库
startup
2.2 扫描磁盘
echo 1 > /sys/class/fc_host/host3/issue_lip
echo 1 > /sys/class/fc_host/host4/issue_lip
3,更改磁盘属性
chown oracle:oinstall /dev/mapper/3PART*
4,备份ocr
./ocrconfig -manualbackup
./ocrconfig -showbackup
5,新建asm磁盘组
create diskgroup SYSDG external redundancy disk '/dev/mapper/3PARVOT01','/dev/mapper/3PARVOT02','/dev/mapper/3PARVOT03';
6,迁移votedisk
crsctl query css votedisk
crsctl replace votedisk +SYSDG
crsctl query css votedisk
7,迁移ocr
ocrcheck
ocrconfig -add +SYSDG
ocrconfig -delete +DATA
ocrcheck
8,迁移asmspfile
sqlplus / as sysasm
show parameter spfile
create pfile='/home/oracle/asmpfilebak.ora' from spfile;
create spfile='+SYSDG' from pfile='/home/oracle/asmpfilebak.ora'
9,更换asm磁盘到新存储
alter diskgroup DATA
add disk
'/dev/mapper/3PARDATA01',
'/dev/mapper/3PARDATA02',
'/dev/mapper/3PARDATA03',
'/dev/mapper/3PARDATA04',
'/dev/mapper/3PARDATA05',
drop disk
DATA_0000,DATA_0001,DATA_0002,DATA_003,DATA_0004 rebalance power 11;
alter diskgroup DATA02
add disk
'/dev/mapper/3PARDATA06',
'/dev/mapper/3PARDATA07',
'/dev/mapper/3PARDATA08',
'/dev/mapper/3PARDATA09',
'/dev/mapper/3PARDATA10',
'/dev/mapper/3PARDATA11',
'/dev/mapper/3PARDATA12',
drop disk
DATA_0005,DATA_0006,DATA_007,DATA_0008,DATA_0009,DATA_0010,DATA02_0006 rebalance power 11;
10,检查集群和数据库状态
crsctl stat res -t
11,添加新磁盘到磁盘组
alter diskgroup DATA02 add disk '/dev/mapper/3PARDATA13' rebalance power 10;
alter diskgroup DATA add disk '/dev/mapper/3PARDATA14' rebalance power 10;
12,检查集群状态,启动数据库
检查机器状态
crsctl stat res -t
启动数据库
startup
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20747382/viewspace-2130336/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20747382/viewspace-2130336/