设为首页 加入收藏

TOP

ASM磁盘组异机迁移(四)
2015-07-24 11:12:20 来源: 作者: 【 】 浏览:26
Tags:ASM 磁盘 迁移
ath:/dev/asm-diskf NOTE: cache mounting (first) external redundancy group 2/0x266B8137 (ZBDBA) * allocate domain 2, invalid = TRUE NOTE: attached to recovery domain 2 NOTE: starting recovery of thread=1 ckpt=7.284 group=2 (ZBDBA) NOTE: advancing ckpt for group 2 (ZBDBA) thread=1 ckpt=7.284 NOTE: cache recovered group 2 to fcn 0.2892 NOTE: redo buffer size is 256 blocks (1053184 bytes) NOTE: LGWR attempting to mount thread 1 for diskgroup 2 (ZBDBA) NOTE: LGWR found thread 1 closed at ABA 7.283 NOTE: LGWR mounted thread 1 for diskgroup 2 (ZBDBA) NOTE: LGWR opening thread 1 at fcn 0.2892 ABA 8.284 NOTE: cache mounting group 2/0x266B8137 (ZBDBA) succeeded NOTE: cache ending mount (success) of group ZBDBA number=2 incarn=0x266b8137 NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1 SUCCESS: diskgroup DATA was mounted NOTE: Instance updated compatible.asm to 10.1.0.0.0 for grp 2 SUCCESS: diskgroup ZBDBA was mounted ORACLE_BASE value has been saved for future startups SUCCESS: ALTER DISKGROUP ALL MOUNT SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL SUCCESS: ALTER DISKGROUP ALL ENABLE VOLUME ALL NOTE: diskgroup resource ora.DATA.dg is online NOTE: diskgroup resource ora.ZBDBA.dg is online NOTE: Attempting voting file refresh on diskgroup DATA NOTE: Refresh completed on diskgroup DATA . Found 3 voting file(s). NOTE: Voting file relocation is required in diskgroup DATA NOTE: Attempting voting file relocation on diskgroup DATA NOTE: Successful voting file relocation on diskgroup DATA Sun Feb 08 02:50:00 2015 ALTER SYSTEM SET local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.52)(PORT=1521))))' SCOPE=MEMORY SID='+ASM1'; Sun Feb 08 02:50:01 2015 NOTE: [crsd.bin@zbdba1 (TNS V1-V3) 11280] opening OCR file Starting background process ASMB Sun Feb 08 02:50:01 2015 ASMB started with pid=26, OS id=11293 Sun Feb 08 02:50:01 2015 NOTE: client +ASM1:+ASM registered, osid 11295, mbr 0x0 Sun Feb 08 02:50:18 2015 Reconfiguration started (old inc 2, new inc 4) List of instances: 1 2 (myinst: 1) Global Resource Directory frozen Communication channels reestablished Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out Sun Feb 08 02:50:18 2015 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived Set master node info Submitted all remote-enqueue requests Dwn-cvts replayed, VALBLKs dubious All grantable enqueues granted Submitted all GCS remote-cache requests Fix write in gcs resources Reconfiguration complete查看磁盘组状态:

ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576      6144     5218             2048            1585              0             Y  DATA/
MOUNTED  EXTERN  N         512   4096  1048576     10240     8179                0            8179              0             N  ZBDBA/

创建spfile:
create spfile='+DATA' from pfile;


启动另外一个节点ASM








7、创建数据库参数文件

[oracle@zbdba1 dbs]$ cat inittest1.ora 
test1.__db_cache_size=264241152
test2.__db_cache_size=264241152
test1.__java_pool_size=4194304
test2.__java_pool_size=4194304
test1.__large_pool_size=8388608
test2.__large_pool_size=8388608
test1.__pga_aggregate_target=318767104
test2.__pga_aggregate_target=318767104
test1.__sga_target=469762048
test2.__sga_target=469762048
test1.__shared_io_pool_size=0
test2.__shared_io_pool_size=0
test1.__shared_pool_size=184549376
test2.__shared_pool_size=184549376
test1.__stre
首页 上一页 1 2 3 4 5 6 7 下一页 尾页 4/8/8
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇如何诊断rac环境下sysdate返回错.. 下一篇统计对象大小函数性能比较

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·数据库:推荐几款 Re (2025-12-25 12:17:11)
·如何最简单、通俗地 (2025-12-25 12:17:09)
·什么是Redis?为什么 (2025-12-25 12:17:06)
·对于一个想入坑Linux (2025-12-25 11:49:07)
·Linux 怎么读? (2025-12-25 11:49:04)