Lokeshaggarwal's DBA

Live the life you love. Love the life you live

amdu – ASM Metadata Dump Utility


  • Allows to dump ASM contents without opening diskgroups, allows to check ASM file mirroring when using normal redundancy
  • powerful tool for troubleshooting, introduced in 11g, usable in 10g too.

In the below demonstration, we will try to extract the controlfile, although. the diskgorups are in mounted state.

[grid@rac2 bin]$ . oraenv
ORACLE_SID = [grid] ? +ASM2
The Oracle base for ORACLE_HOME=/raczone/grid_home is /raczone/11.2.0
[grid@rac2 bin]$ ./asmcmd find –type controlfile + “*”asmcmd find –type controlfile + “*”

[grid@rac2 bin]$ ./asmcmd find –type controlfile + “*”
+DATA/DEV/CONTROLFILE/Current.260.802353245
+FRA/DEV/CONTROLFILE/Current.256.802353245

[grid@rac2 bin]$ ./asmcmd lsdsk -G DATA
Path
ORCL:DATA1

Let’s extract that controlfile out of the disk group DATA onto the file system:

[grid@rac2 tmp]$ amdu -diskstring=”ORCL:*” -extract DATA.260 -output control.260 -noreport -nodir
AMDU-00204: Disk N0001 is in currently mounted diskgroup DATA
AMDU-00201: Disk N0001: ‘ORCL:DATA1’
[grid@rac2 tmp]$ ll
total 18088
-rw-r–r– 1 grid oinstall 18497536 Dec 19 15:53 control.260

[grid@rac2 tmp]$ ls -lrt
total 18088
-rw-r–r– 1 grid oinstall 18497536 Dec 19 15:53 control.260
[grid@rac2 tmp]$ /raczone/grid_home/bin/./amdu -dump DATA -noimage
amdu_2012_12_19_15_55_41/
AMDU-00204: Disk N0001 is in currently mounted diskgroup DATA
AMDU-00201: Disk N0001: ‘ORCL:DATA1’
[grid@rac2 tmp]$ ls
amdu_2012_12_19_15_55_41 control.260
[grid@rac2 tmp]$ cd amdu_2012_12_19_15_55_41/
[grid@rac2 amdu_2012_12_19_15_55_41]$ ll
total 20
-rw-r–r– 1 grid oinstall 8320 Dec 19 15:55 DATA.map
-rw-r–r– 1 grid oinstall 4791 Dec 19 15:55 report.txt
[grid@rac2 amdu_2012_12_19_15_55_41]$ more report.txt
-*-amdu-*-

******************************* AMDU Settings ********************************
ORACLE_HOME = /raczone/grid_home
System name: Linux
Node name: rac2.raczone.com
Release: 2.6.18-128.el5
Version: #1 SMP Wed Dec 17 11:42:39 EST 2008
Machine: i686
amdu run: 19-DEC-12 15:55:41
Endianess: 1

——————————— Operations ———————————
-dump DATA

——————————- Disk Selection ——————————-
-diskstring ”

—————————— Reading Control ——————————-

——————————- Output Control ——————————-
-noimage

********************************* DISCOVERY **********************************

—————————– DISK REPORT N0001 ——————————
Disk Path: ORCL:DATA1
Unique Disk ID:
Disk Label: DATA1
Physical Sector Size: 512 bytes
Disk Size: 14306 megabytes
Group Name: DATA
Disk Name: DATA1
Failure Group Name: DATA1
Disk Number: 0
Header Status: 3
Disk Creation Time: 2012/12/18 11:38:24.527000
Last Mount Time: 2012/12/19 11:50:59.308000
Compatibility Version: 0x0b200000(11020000)
Disk Sector Size: 512 bytes
Disk size in AUs: 14306 AUs
Group Redundancy: 1
Metadata Block Size: 4096 bytes
AU Size: 1048576 bytes
Stride: 113792 AUs
Group Creation Time: 2012/12/18 11:38:24.388000
File 1 Block 1 location: AU 2
OCR Present: NO

—————————– DISK REPORT N0002 ——————————
Disk Path: ORCL:FRA
Unique Disk ID:
Disk Label: FRA
Physical Sector Size: 512 bytes
Disk Size: 7814 megabytes
Group Name: FRA
Disk Name: FRA
Failure Group Name: FRA
Disk Number: 0
Header Status: 3
Disk Creation Time: 2012/12/18 11:42:08.078000
Last Mount Time: 2012/12/19 11:50:59.843000
Compatibility Version: 0x0b200000(11020000)
Disk Sector Size: 512 bytes
Disk size in AUs: 7814 AUs
Group Redundancy: 1
Metadata Block Size: 4096 bytes
AU Size: 1048576 bytes
Stride: 113792 AUs
Group Creation Time: 2012/12/18 11:42:07.927000
File 1 Block 1 location: AU 2
OCR Present: NO

—————————– DISK REPORT N0003 ——————————
Disk Path: ORCL:VOTE1
Unique Disk ID:
Disk Label: VOTE1
Physical Sector Size: 512 bytes
Disk Size: 1953 megabytes
Group Name: CRS
Disk Name: VOTE1
Failure Group Name: VOTE1
Disk Number: 0
Header Status: 3
Disk Creation Time: 2012/12/17 16:39:42.078000
Last Mount Time: 2012/12/19 11:50:58.746000
Compatibility Version: 0x0b200000(11020000)
Disk Sector Size: 512 bytes
Disk size in AUs: 1953 AUs
Group Redundancy: 1
Metadata Block Size: 4096 bytes
AU Size: 1048576 bytes
Stride: 113792 AUs
Group Creation Time: 2012/12/17 16:39:41.936000
File 1 Block 1 location: AU 2
OCR Present: YES

***************** Slept for 6 seconds waiting for heartbeats *****************

************************** SCANNING DISKGROUP DATA ***************************
Creation Time: 2012/12/18 11:38:24.388000
Disks Discovered: 1
Redundancy: 1
AU Size: 1048576 bytes
Metadata Block Size: 4096 bytes
Physical Sector Size: 512 bytes
Metadata Stride: 113792 AU
Duplicate Disk Numbers: 0
—————————- SCANNING DISK N0001 —————————–
Disk N0001: ‘ORCL:DATA1’
AMDU-00204: Disk N0001 is in currently mounted diskgroup DATA
AMDU-00201: Disk N0001: ‘ORCL:DATA1’
** HEARTBEAT DETECTED **
Allocated AU’s: 1559
Free AU’s: 12747
AU’s read for dump: 104
Block images saved: 23563
Map lines written: 104
Heartbeats seen: 1
Corrupt metadata blocks: 0
Corrupt AT blocks: 0
————————- SUMMARY FOR DISKGROUP DATA ————————-
Allocated AU’s: 1559
Free AU’s: 12747
AU’s read for dump: 104
Block images saved: 23563
Map lines written: 104
Heartbeats seen: 1
Corrupt metadata blocks: 0
Corrupt AT blocks: 0
******************************* END OF REPORT ********************************

Advertisements

December 19, 2012 - Posted by | ASM

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: