- 论坛徽章:
- 0
|
周四和周五,把一套系统的数据库从HITACHI9970V的存储中迁移到了原IBM7133的存储中,大概的过程如下,这套系统主机是2台IBM的S7A小型机,做了HA,使用ORACLE的OPS,使用了也快10年了,7133的存储也停了2年没使用,而且设备都过保了,做前担心别做着做着就启不来了,呵呵。
首先在9970V连接情况下,做了个全库导出,确认成功后,准备进行HA配置的修改,
1、导出导入VG信息
smitty vg --export vg[9970V上的VG]
import vg[7133上的VG]
2、修改VG配置
Change a Volume Group
Type or select values in entry fields.
Press Enter AFTER making all desired changes.
[Entry Fields]
* VOLUME GROUP name datavg1
* Activate volume group AUTOMATICALLY no +
at system restart?
* A QUORUM of disks required to keep the volume no +
group on-line ?
Convert this VG to Concurrent Capable? no +
* Autovaryon VG in Concurrent Mode? no +
把前2项从YES改为NO,否则OPS的2端无法同时启动HA。或者使用命令chvg -an datavg1
3、修改HA配置
smitty hacmp--
Cluster Configuration--
Cluster Resources --
Change/Show Resources for a Resource Group
Configure Resources for a Resource Group
Type or select values in entry fields.
Press Enter AFTER making all desired changes.
[Entry Fields]
Resource Group Name DB_res
Node Relationship concurrent
Participating Node Names DB_S7A1 DB_S7A2
Service IP label [] +
Filesystems [] +
Filesystems Consistency Check fsck +
Filesystems Recovery Method sequential +
Filesystems to Export [] +
Filesystems to NFS mount [] +
Volume Groups [] +
Concurrent Volume groups [datavg1] +
Raw Disk PVIDs [] +
AIX Connections Services [] +
AIX Fast Connect Services [] +
Application Servers [DB_APP] +
Highly Available Communication Links [] +
Miscellaneous Data []
将Concurrent Volume groups 后面的VG从9970V上的VG修改为7133上的VG。2台主机都要修改。
这样2台机器就可以同时启动HA了,使用的存储就不再是9970V,而是7133。
4、导入数据
由于导出的数据是在管道下导出同时压缩的,2台主机上都没这么大的空间来一次解压这么大的数据文件,也只好再用管道解压来导入,
uncompress /orabackup/dbpipe &
sleep 5
imp userid=username/passwd file='/orabackup/dbpipe' log=log4.log buffer=5000000 fromuser=user1 touser=user1 commit=y ignore=y feedback=100000
再导入前,还先执行回收RBS的命令,如下:
sqlplus user1/passwd
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u2/74483/showart_1098357.html |
|