Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

3

主题
1#
发表于 2013-3-6 17:02:47 | 查看: 3959| 回复: 3
准备重装RAC,卸载数据库正常,目前到卸载集群软件这一步,貌似有点儿问题,如下:
######################## CLEAN OPERATION START ########################
ASM de-configuration trace file location: /tmp/deinstall2013-03-06_03-05-23PM/logs/asmcadc_clean2013-03-06_03-12-28-PM.log
ASM Clean Configuration START
停在这大概1个小时了


日志如下:
[main] [ 2013-03-06 15:12:31.014 CST ] [USMCleanConfig.dropDiskgroups:751]  Started true
[main] [ 2013-03-06 15:12:31.015 CST ] [USMCleanConfig.dropDiskgroups:754]  ASM instance is up +ASM1
[main] [ 2013-03-06 15:12:31.015 CST ] [USMCleanConfig.dropDiskgroups:759]  Setting asm_diskstring /dev/
[main] [ 2013-03-06 15:12:31.015 CST ] [SQLEngine.doSQLSubstitution:2414]  The substituted sql statement:=alter system set asm_diskstring='/dev/' scope=memory
[main] [ 2013-03-06 15:21:01.620 CST ] [USMCleanConfig.dropDiskgroups:794]  Dropping diskgroup: ASMDATA
[main] [ 2013-03-06 15:21:01.620 CST ] [SQLEngine.doSQLSubstitution:2414]  The substituted sql statement:=select state from v$asm_diskgroup where name='ASMDATA'
[main] [ 2013-03-06 15:25:17.067 CST ] [USMCleanConfig.dropDiskgroups:800]  Diskgroup not mounted, Mounting ASMDATA
[main] [ 2013-03-06 15:25:17.067 CST ] [SQLEngine.doSQLSubstitution:2414]  The substituted sql statement:=alter diskgroup ASMDATA MOUNT
[main] [ 2013-03-06 15:29:38.891 CST ] [USMCleanConfig.dropDiskgroups:809]  Dropping diskgroup ASMDATA
[main] [ 2013-03-06 15:29:38.891 CST ] [SQLEngine.doSQLSubstitution:2414]  The substituted sql statement:=drop diskgroup ASMDATA including contents
[main] [ 2013-03-06 15:33:54.782 CST ] [USMCleanConfig.dropDiskgroups:812]  Dropped diskgroup ASMDATA
[main] [ 2013-03-06 15:33:54.782 CST ] [USMCleanConfig.dropDiskgroups:827]  Removing diskgroup resource ASMDATA
[main] [ 2013-03-06 15:33:54.788 CST ] [CRSNative.internalQueryResources:1577]  About to doQueryResources: eType resource, nodeName null, filter (TYPE == ora.diskgroup.type)
[main] [ 2013-03-06 15:33:54.875 CST ] [CRSNative.internalQueryResources:1585]  found 2 resources
[main] [ 2013-03-06 15:33:54.876 CST ] [CRSNative.internalQueryResources:1587]          ora.ASMDATA.dg
[main] [ 2013-03-06 15:33:54.877 CST ] [CRSNative.internalQueryResources:1587]          ora.DATA.dg
[main] [ 2013-03-06 15:33:54.877 CST ] [DiskGroupImpl.<init>:108]  name = ora.ASMDATA.dg, display name = ASMDATA
[main] [ 2013-03-06 15:33:54.961 CST ] [CRSNativeResult.addComp:162]  add comp: name ora.ASMDATA.dg, rc 210, msg CRS-0210: Could not find resource 'ora.ASMDATA.dg'.
[main] [ 2013-03-06 15:33:54.963 CST ] [CRSNative.isEntityRegistered:737]  entity: ora.ASMDATA.dg, type: 1, registered: false
[main] [ 2013-03-06 15:33:54.969 CST ] [DiskGroupImpl.<init>:108]  name = ora.DATA.dg, display name = DATA
[main] [ 2013-03-06 15:33:54.998 CST ] [CRSNative.isEntityRegistered:737]  entity: ora.DATA.dg, type: 1, registered: true
[main] [ 2013-03-06 15:33:54.998 CST ] [USMCleanConfig.dropDiskgroups:829]  Removed diskgroup resource ASMDATA
[main] [ 2013-03-06 15:33:54.998 CST ] [SQLEngine.done:2189]  Done called
[main] [ 2013-03-06 15:33:55.004 CST ] [KfodUtil.kfodOutput:232]  /tmp/deinstall2013-03-06_03-05-23PM/bin/kfod
[main] [ 2013-03-06 15:33:55.004 CST ] [KfodUtil.kfodOutput:232]  nohdr=TRUE
[main] [ 2013-03-06 15:33:55.004 CST ] [KfodUtil.kfodOutput:232]  OP=DISKS DISK=ASM DS=TRUE
[main] [ 2013-03-06 15:33:55.004 CST ] [KfodUtil.kfodOutput:232]  status=true
[main] [ 2013-03-06 15:33:55.004 CST ] [KfodUtil.kfodOutput:232]  asm_diskstring=/dev/
4#
发表于 2013-3-6 21:40:33
嗯 ,如果还慢 strace /truss 看一下情况

回复 只看该作者 道具 举报

3#
发表于 2013-3-6 21:39:14
版本:11.2.0.3
平台:AIX 6.1
执行的卸载命令:./deinstall
卡了很久,我取消了命令 然后又重新试了一下 可以卸载了

回复 只看该作者 道具 举报

2#
发表于 2013-3-6 21:30:39
至少说明版本和 你之前执行的命令吧?

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 11:25 , Processed in 0.058319 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569