1

amdu -diskstring '/dev/asm*' 生成 report.txt 可以檢視磁碟組和磁碟資訊

具體資訊如下:

[grid@node1 ~]$ amdu -diskstring /dev/asm*

LRM-00110: syntax error at '/dev/asm-diskb'

AMDU-00101: LRM error [110] while parsing command line arguments

[grid@node1 ~]$ amdu -diskstring '/dev/asm*'

amdu_2012_12_24_03_50_20/

[grid@node1 ~]$ cd amdu_2012_12_24_03_50_20/

[grid@node1 amdu_2012_12_24_03_50_20]$ ls

report.txt

[grid@node1 amdu_2012_12_24_03_50_20]$ more report.txt

-*-amdu-*-

******************************* AMDU Settings ********************************

ORACLE_HOME = /u01/app/11.2.0/grid

System name: Linux

Node name: node1

Release: 2.6.18-194.el5

Version: #1 SMP Mon Mar 29 22:10:29 EDT 2010

Machine: x86_64

amdu run: 24-DEC-12 03:50:20

Endianess: 1

--------------------------------- Operations ---------------------------------

------------------------------- Disk Selection -------------------------------

-diskstring '/dev/asm*'

------------------------------ Reading Control -------------------------------

------------------------------- Output Control -------------------------------

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

----------------------------- DISK REPORT N0001 ------------------------------

Disk Path: /dev/asm-diske

Unique Disk ID:

Disk Label:

Physical Sector Size: 512 bytes

Disk Size: 5120 megabytes

Group Name: DATA

Disk Name: DATA_0000

Failure Group Name: DATA_0000

Disk Number: 0

Header Status: 3

Disk Creation Time: 2012/12/03 15:01:43.870000

Last Mount Time: 2012/12/10 02:48:13.466000

Compatibility Version: 0x0b200000(11020000)

Disk Sector Size: 512 bytes

Disk size in AUs: 5120 AUs

Group Redundancy: 1

Metadata Block Size: 4096 bytes

AU Size: 1048576 bytes

Stride: 113792 AUs

Group Creation Time: 2012/12/03 15:01:43.230000

File 1 Block 1 location: AU 2

OCR Present: NO

----------------------------- DISK REPORT N0002 ------------------------------

Disk Path: /dev/asm-diskc

Unique Disk ID:

Disk Label:

Physical Sector Size: 512 bytes

Disk Size: 1024 megabytes

Group Name: CRS

Disk Name: CRS_0001

Failure Group Name: CRS_0001

Disk Number: 1

Header Status: 3

Disk Creation Time: 2012/12/03 13:25:51.807000

Last Mount Time: 2012/12/24 02:26:03.402000

Compatibility Version: 0x0b200000(11020000)

Disk Sector Size: 512 bytes

Disk size in AUs: 1024 AUs

Group Redundancy: 2

Metadata Block Size: 4096 bytes

AU Size: 1048576 bytes

Stride: 113792 AUs

Group Creation Time: 2012/12/03 13:25:50.675000

File 1 Block 1 location: AU 2

OCR Present: YES

----------------------------- DISK REPORT N0003 ------------------------------

Disk Path: /dev/asm-diskf

Unique Disk ID:

Disk Label:

Physical Sector Size: 512 bytes

Disk Size: 5120 megabytes

Group Name: DATA

Disk Name: DATA_0001

Failure Group Name: DATA_0001

Disk Number: 1

Header Status: 3

Disk Creation Time: 2012/12/03 15:01:43.870000

Last Mount Time: 2012/12/10 02:48:13.466000

Compatibility Version: 0x0b200000(11020000)

Disk Sector Size: 512 bytes

Disk size in AUs: 5120 AUs

Group Redundancy: 1

Metadata Block Size: 4096 bytes

AU Size: 1048576 bytes

Stride: 113792 AUs

Group Creation Time: 2012/12/03 15:01:43.230000

File 1 Block 1 location: AU 0

OCR Present: NO

----------------------------- DISK REPORT N0004 ------------------------------

Disk Path: /dev/asm-diskd

Unique Disk ID:

Disk Label:

Physical Sector Size: 512 bytes

Disk Size: 1024 megabytes

Group Name: CRS

Disk Name: CRS_0002

Failure Group Name: CRS_0002

Disk Number: 2

Header Status: 3

Disk Creation Time: 2012/12/03 13:25:51.807000

Last Mount Time: 2012/12/24 02:26:03.402000

Compatibility Version: 0x0b200000(11020000)

Disk Sector Size: 512 bytes

Disk size in AUs: 1024 AUs

Group Redundancy: 2

Metadata Block Size: 4096 bytes

AU Size: 1048576 bytes

Stride: 113792 AUs

Group Creation Time: 2012/12/03 13:25:50.675000

File 1 Block 1 location: AU 2

OCR Present: YES

----------------------------- DISK REPORT N0005 ------------------------------

Disk Path: /dev/asm-diskb

Unique Disk ID:

Disk Label:

Physical Sector Size: 512 bytes

Disk Size: 1024 megabytes

Group Name: CRS

Disk Name: CRS_0000

Failure Group Name: CRS_0000

Disk Number: 0

Header Status: 3

Disk Creation Time: 2012/12/03 13:25:51.807000

Last Mount Time: 2012/12/24 02:26:03.402000

Compatibility Version: 0x0b200000(11020000)

Disk Sector Size: 512 bytes

Disk size in AUs: 1024 AUs

Group Redundancy: 2

Metadata Block Size: 4096 bytes

AU Size: 1048576 bytes

Stride: 113792 AUs

Group Creation Time: 2012/12/03 13:25:50.675000

File 1 Block 1 location: AU 2

OCR Present: YES

******************************* END OF REPORT ********************************

2 從rman 中恢復spfile startup nomount 狀態檢視控制檔案資訊

SQL> show parameter control_files

NAME TYPE VALUE

———————————— ———– ——————————

control_files string +DATA/prodb/controlfile/curren

t.261.794687955, +FRA/prodb/co

ntrolfile/current.256.79468795 261為檔案號

3 恢復控制檔案

amdu -diskstring '/dev/asm*' -extract data.261 (磁碟組.檔案號)

3 使用恢復的控制檔案啟動mount 狀態

以此類推恢復資料檔案

注：oracle 10g 需要下載AMDU 並安裝

參考文件：

https://blogs.oracle.com/askmaclean/entry/%E4%BD%BF%E7%94%A8amdu%E5%B7%A5%E5%85%B7%E4%BB%8E%E6%97%A0%E6%B3%95mount%E7%9A%84diskgroup%E4%B8%AD%E6%8A%BD%E5%8F%96%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6

[ORACLE ASM] AMDU 恢復資料檔案

相關文章