博客首页 注册 建议与交流 排行榜 加入友情链接
推荐 投诉 搜索: 帮助

CcdD

微风涌起旧梦,拾起一片恍如叶落,过季的华叶虽美丽,徒奈亦夹进记忆的扉页。
敉平谬葛思如故。旧情怀,消不尽,几时休。
  aixcq.cublog.cn

关于作者
姓名:痴痴地等
职业:跳蚤守望者
年龄:31
位置:金刚塔下地狱十字架
个性介绍:不够成熟理智,不够积极优雅,希望能够觉悟人生,奉献人生,善用其心,善待一切,感恩包容,分享结缘。“真诚、清净、平等、正觉、慈悲”,“看破、放下、自由、随缘、念佛”要用这种心对人、对事、对天地万物!

佛看我们迷惑颠倒,他以种种方便来诱导我们、开启我们,希望我们豁然觉悟,又恢复到本觉,这就是佛度众生。《金刚经》上很坦率地告诉我们,佛不度众生,众生怎么度的?自己度自己。


背景音乐:暂停

|| << >> ||
我的分类


一次数据迁移
周四和周五,把一套系统的数据库从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/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个小时,顺利完成。



 

发表于: 2008-01-23,修改于: 2008-01-23 15:10,已浏览378次,有评论0条 推荐 投诉


网友评论
 发表评论