LGWR doing non-clean dismount of group [message #638228] |
Sun, 07 June 2015 10:09 |
|
pazbarkai
Messages: 6 Registered: December 2014 Location: Israel
|
Junior Member |
|
|
We needed to move the storage area, so I run asmcmd umount -f and saw the following in the alert log:
SQL> /* ASMCMD */ALTER DISKGROUP BBX_G DISMOUNT FORCE
NOTE: cache dismounting (not clean) group 1/0x0F97AFA7 (BBX_G)
NOTE: messaging CKPT to quiesce pins Unix process pid: 4586, image: oracle@Recoverer (TNS V1-V3)
Wed Jun 03 08:08:05 2015
NOTE: halting all I/Os to diskgroup 1 (BBX_G)
Wed Jun 03 08:08:05 2015
NOTE: LGWR doing non-clean dismount of group 1 (BBX_G)
NOTE: LGWR sync ABA=61.6171 last written ABA 61.6171
NOTE: cache dismounted group 1/0x0F97AFA7 (BBX_G)
Wed Jun 03 08:08:05 2015
GMON dismounting group 1 at 62 for pid 18, osid 4586
NOTE: Disk in mode 0x8 marked for de-assignment
SUCCESS: diskgroup BBX_G was dismounted
NOTE: cache deleting context for group BBX_G 1/0x0f97afa7
SUCCESS: /* ASMCMD */ALTER DISKGROUP BBX_G DISMOUNT FORCE
Wed Jun 03 08:08:05 2015
NOTE: diskgroup resource ora.BBX_G.dg is offline
NOTE: diskgroup resource ora.BBX_G.dg is updated
1. What can cause 'LGWR doing non-clean dismount of group 1'?
2. I wanted to remount the Diskgroup but couldn't,
Only after restarting the asm instance , I was able to mount it again.
How can I avoid the asm instance restart next time?
Thanks
Pazit Barkai Zimerman
Oracle DBA
Axxana Ltd.
|
|
|
|
Re: LGWR doing non-clean dismount of group [message #638230 is a reply to message #638229] |
Sun, 07 June 2015 11:42 |
|
pazbarkai
Messages: 6 Registered: December 2014 Location: Israel
|
Junior Member |
|
|
Hi,
I run via asmcmd
ASMCMD> umount -f BBX_G
It seemed OK but the alert log showed
-----------------------------------------------------------------------------
NOTE: cache dismounting (not clean) group 1/0x0F97AFA7 (BBX_G)
NOTE: messaging CKPT to quiesce pins Unix process pid: 4586, image: oracle@Recoverer (TNS V1-V3)
Wed Jun 03 08:08:05 2015
NOTE: halting all I/Os to diskgroup 1 (BBX_G)
Wed Jun 03 08:08:05 2015
NOTE: LGWR doing non-clean dismount of group 1 (BBX_G)
-----------------------------------------------------------------------------
Then when device was back, I run -
asmcmd> mount BBX_G
It failed and only after ASM instance restart, i was able to mount the diskgroup .
The alert log showed the following errors:
-----------------------------------------------------------------------------
[i]ORA-00600: internal error code, arguments: [ksbasend_bgnoproc], [RBAL], [0x000000000], [0], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/asm/+asm/+ASM/incident/incdir_25964/+ASM_ora_3311_i25964.trc
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Wed Jun 03 08:41:00 2015
SQL> ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:2} */
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:0:2} */
SQL> ALTER DISKGROUP BBX_G MOUNT /* asm agent *//* {0:0:2} */
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
NOTE: cache registered group BBX_G number=1 incarn=0xdb77ac94
NOTE: cache began mount (first) of group BBX_G number=1 incarn=0xdb77ac94
NOTE: Assigning number (1,0) to disk (/dev/asmdisk_udev_dm-0)
Dumping diagnostic data in directory=[cdmp_20150603084101], requested by (instance=1, osid=3311), summary=[incident=25964].
Wed Jun 03 08:41:03 2015
Sweep [inc][25964]: completed
Sweep [inc2][25964]: completed
NOTE: GMON heartbeating for grp 1
GMON querying group 1 at 3 for pid 18, osid 3341
NOTE: cache opening disk 0 of grp 1: BBX_G_0000 path:/dev/asmdisk_udev_dm-0
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 1/0xDB77AC94 (BBX_G)
NOTE: cache recovered group 1 to fcn 0.37867
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (BBX_G)
NOTE: LGWR found thread 1 closed at ABA 67.6183
NOTE: LGWR mounted thread 1 for diskgroup 1 (BBX_G)
NOTE: LGWR opening thread 1 at fcn 0.37867 ABA 68.6184
NOTE: cache mounting group 1/0xDB77AC94 (BBX_G) succeeded
NOTE: cache ending mount (success) of group BBX_G number=1 incarn=0xdb77ac94
GMON querying group 1 at 4 for pid 14, osid 3333
NOTE: Instance updated compatible.asm to 10.1.0.0.0 for grp 1
SUCCESS: diskgroup BBX_G was mounted
SUCCESS: ALTER DISKGROUP BBX_G MOUNT /* asm agent *//* {0:0:2} */
NOTE: diskgroup resource ora.BBX_G.dg is updated
Wed Jun 03 08:41:08 2015
SQL> /* ASMCMD */ALTER DISKGROUP BBX_G MOUNT
ORA-15032: not all alterations performed
ORA-15017: diskgroup "BBX_G" cannot be mounted
ORA-15013: diskgroup "BBX_G" is already mounted
ERROR: /* ASMCMD */ALTER DISKGROUP BBX_G MOUNT
Wed Jun 03 08:41:09 2015
Starting background process ASMB
Wed Jun 03 08:41:09 2015
ASMB started with pid=19, OS id=3577
Wed Jun 03 08:41:09 2015
NOTE: client +ASM:+ASM registered, osid 3581, mbr 0x0
Wed Jun 03 08:46:21 2015
NOTE: ASMB process exiting due to lack of ASM file activity for 301 seconds
Wed Jun 03 09:12:04 2015[/i]
-----------------------------------------------------------------------------
Thanks
Pazit Barkai
|
|
|
|
Re: LGWR doing non-clean dismount of group [message #638250 is a reply to message #638231] |
Mon, 08 June 2015 06:02 |
|
pazbarkai
Messages: 6 Registered: December 2014 Location: Israel
|
Junior Member |
|
|
Hi Michel,
I don't think it's ASM diskgroup corruption, since I was able to mount the diskgroup after ASM instance restart.
It could be related to Oracle Bug 19155797 ('Doc ID 19155797.8') , but there is no Workaround and Patch Exist only for 12c .
What's more important to me than knowing why it happen, is knowing how to solve this.
If I encounter the same situation again, where I can't reach an asm diskgroup that I mounted, is there a way to avoid asm instance restart?
Thanks
Pazit
[Updated on: Mon, 08 June 2015 06:03] Report message to a moderator
|
|
|