周四和周五，把一套系统的数据库从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<ALTER ROLLBACK SEGMENT R21 SHRINK;
ALTER ROLLBACK SEGMENT R22 SHRINK;
ALTER ROLLBACK SEGMENT R23 SHRINK;
ALTER ROLLBACK SEGMENT R24 SHRINK;
ALTER ROLLBACK SEGMENT R25 SHRINK;
ALTER ROLLBACK SEGMENT R26 SHRINK;
ALTER ROLLBACK SEGMENT R27 SHRINK;
ALTER ROLLBACK SEGMENT R28 SHRINK;
ALTER ROLLBACK SEGMENT R29 SHRINK;
ALTER ROLLBACK SEGMENT R30 SHRINK;
ALTER ROLLBACK SEGMENT R31 SHRINK;
ALTER ROLLBACK SEGMENT R32 SHRINK;
ALTER ROLLBACK SEGMENT R33 SHRINK;
ALTER ROLLBACK SEGMENT R34 SHRINK;
ALTER ROLLBACK SEGMENT R35 SHRINK;
ALTER ROLLBACK SEGMENT R36 SHRINK;
ALTER ROLLBACK SEGMENT R37 SHRINK;
ALTER ROLLBACK SEGMENT R38 SHRINK;
ALTER ROLLBACK SEGMENT R39 SHRINK;
ALTER ROLLBACK SEGMENT R40 SHRINK;
ALTER ROLLBACK SEGMENT R21 SHRINK;
ALTER ROLLBACK SEGMENT R22 SHRINK;
ALTER ROLLBACK SEGMENT R101 SHRINK;
导入过程6个小时，顺利完成。
