Home » RDBMS Server » Server Administration » LGWR doing non-clean dismount of group (ASM 11.2.0.3.0)
LGWR doing non-clean dismount of group [message #638228] Sun, 07 June 2015 10:09 Go to next message
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 #638229 is a reply to message #638228] Sun, 07 June 2015 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
2. I wanted to remount the Diskgroup but couldn't,


What does this mean? You can't type the command? Your keyboard failed? Smile
Copy and paste what you do and get.
Before, Please read How to use [code] tags and make your code easier to read.

Re: LGWR doing non-clean dismount of group [message #638230 is a reply to message #638229] Sun, 07 June 2015 11:42 Go to previous messageGo to next message
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 #638231 is a reply to message #638230] Sun, 07 June 2015 12:03 Go to previous messageGo to next message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

It seems you have a corruption in ASM diskgroup (header).

Re: LGWR doing non-clean dismount of group [message #638250 is a reply to message #638231] Mon, 08 June 2015 06:02 Go to previous message
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

Previous Topic: Not able to connect to Oracle Instance : ORA-12514
Next Topic: databse resources
Goto Forum:
  


Current Time: Sun Feb 18 13:01:29 CST 2018

Total time taken to generate the page: 0.02029 seconds