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/dbexpallw4.dmp.Z > /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个小时,顺利完成。