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

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

0

积分

1

好友

2

主题
1#
发表于 2014-3-31 13:18:04 | 查看: 3219| 回复: 0
OS:OEL 5U8
ORACLE :11.2.0.4

从11.2.0.1 升级到11.2.0.4
清理环境再直接安装11.2.0.4

执行命令的时候遇到的一个问题:
crs_stop -all
ASM 实例abort 了。

Stop of `ora.OCRVOTE.dg` on member `rac2` succeeded.
Attempting to stop `ora.asm` on member `rac2`
Stop of `ora.OCRVOTE.dg` on member `rac1` succeeded.
Attempting to stop `ora.asm` on member `rac1`
Stop of `ora.asm` on member `rac2` succeeded.
Attempting to stop `ora.asm` on member `rac2`
Stop of `ora.asm` on member `rac1` succeeded.
Attempting to stop `ora.asm` on member `rac1`
CRS-0184: Cannot communicate with the CRS daemon.

SQL> ALTER DISKGROUP OCRVOTE DISMOUNT  /* asm agent *//* {2:45314:396} */
Mon Mar 31 11:50:27 2014
SQL> ALTER DISKGROUP DATAVG01 DISMOUNT  /* asm agent *//* {2:45314:396} */
Mon Mar 31 11:50:27 2014
NOTE: ASM client racdb2:racdb disconnected unexpectedly.
NOTE: check client alert log.
NOTE: Trace records dumped in trace file /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_5689.trc
NOTE: cache dismounting (clean) group 2/0x39C8898B (DATAVG01)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5404, image: oracle@eisoo2 (TNS V1-V3)
Mon Mar 31 11:50:28 2014
NOTE: LGWR doing clean dismount of group 2 (DATAVG01)
NOTE: LGWR closing thread 1 of diskgroup 2 (DATAVG01) at ABA 5.364
NOTE: LGWR released thread recovery enqueue
Mon Mar 31 11:50:28 2014
freeing rdom 2
Mon Mar 31 11:50:29 2014
NOTE: detached from domain 2
NOTE: cache dismounted group 2/0x39C8898B (DATAVG01)
Mon Mar 31 11:50:29 2014
GMON dismounting group 2 at 10 for pid 30, osid 5404
"alert_+ASM2.log" 453L, 22323C
ERROR: ALTER DISKGROUP DATAVG01 DISMOUNT  /* asm agent *//* {1:1077:283} */
SQL> ALTER DISKGROUP DATAVG01 DISMOUNT  /* asm agent *//* {1:1077:283} */
ORA-15032: not all alterations performed
ORA-15001: diskgroup "DATAVG01" does not exist or is not mounted
ERROR: ALTER DISKGROUP DATAVG01 DISMOUNT  /* asm agent *//* {1:1077:283} */
NOTE: detached from domain 1
NOTE: cache dismounted group 1/0x33088D21 (ARCH01)
GMON dismounting group 1 at 11 for pid 29, osid 5395
NOTE: Disk ARCH01_0000 in mode 0x7f marked for de-assignment
SUCCESS: diskgroup ARCH01 was dismounted
NOTE: cache deleting context for group ARCH01 1/0x33088d21
SUCCESS: ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
SQL> ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
ORA-15032: not all alterations performed
ORA-15001: diskgroup "ARCH01" does not exist or is not mounted
ERROR: ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
SQL> ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
ORA-15032: not all alterations performed
ORA-15001: diskgroup "ARCH01" does not exist or is not mounted
ERROR: ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
SQL> ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
ORA-15032: not all alterations performed
ORA-15001: diskgroup "ARCH01" does not exist or is not mounted
ERROR: ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
SQL> ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
ORA-15032: not all alterations performed
ORA-15001: diskgroup "ARCH01" does not exist or is not mounted
ERROR: ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
SQL> ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
ORA-15032: not all alterations performed
ORA-15001: diskgroup "ARCH01" does not exist or is not mounted
ERROR: ALTER DISKGROUP ARCH01 DISMOUNT  /* asm agent *//* {1:1077:283} */
Mon Mar 31 12:00:59 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
Mon Mar 31 12:00:59 2014
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "OCRVOTE" precludes its dismount
ERROR: ALTER DISKGROUP OCRVOTE DISMOUNT  /* asm agent *//* {1:1077:283} */
Mon Mar 31 12:11:02 2014
Shutting down instance (abort)
License high water mark = 10
USER (ospid: 7296): terminating the instance
Instance terminated by USER, pid = 7296
Mon Mar 31 12:11:03 2014
Instance shutdown complete

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

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

GMT+8, 2024-12-21 06:25 , Processed in 0.042728 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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