今天在Xdata上犯了个小错误。。 上午忙活了半天
几个DG一直没办法MOUNT,显示问题很难看。只觉得是disk missing 又没说具体哪个disk,
然后 mount force也不顶用。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
SQL> ALTER DISKGROUP high MOUNT force NOTE: cache registered group HIGH number=1 incarn=0x9679682f NOTE: cache began mount (first) of group HIGH number=1 incarn=0x9679682f Sun Dec 26 22:01:38 2010 ERROR: no PST quorum in group: required 2, found 0 NOTE: cache dismounting (not clean) group 1/0x9679682F (HIGH) NOTE: dbwr not being msg'd to dismount NOTE: lgwr not being msg'd to dismount NOTE: cache dismounted group 1/0x9679682F (HIGH) NOTE: cache ending mount (fail) of group HIGH number=1 incarn=0x9679682f NOTE: cache deleting context for group HIGH 1/0x9679682f GMON dismounting group 1 at 31 for pid 29, osid 19112 ERROR: diskgroup HIGH was not mounted ORA-15032: not all alterations performed ORA-15017: diskgroup "HIGH" cannot be mounted ORA-15063: ASM discovered an insufficient number of disks for diskgroup "HIGH" ERROR: ALTER DISKGROUP high MOUNT force |
找了半天发现是重启instance时候不小心,discovery_string改掉了,
是我以前本用来建OCRVD时候,DG太多用来过滤的,于是只好改了回来。。
1 2 3 |
asm_diskstring = "/o/*/PCW_CD_01*" ... ALTER SYSTEM SET asm_diskstring='/o/*/*' SCOPE=BOTH SID='*'; |
然后mount就一切顺利了。。。看来有时候小细节不能忽视啊。。