amdu抽取asm磁盘组中的datafile到本地文件系统

来源:互联网 发布:航天发票数据管理软件 编辑:程序博客网 时间:2024/06/05 18:22
[grid@ectonb ~]$ amdu -diskstring '/dev/asm*' -extract DATAFILE.260amdu_2016_10_27_16_46_10/[grid@ectonb ~]$ pwd/home/grid[grid@ectonb ~]$ ls -lrttotal 8drwxrwxr-x 3 grid oinstall 4096 Oct 30  2015 oradiag_griddrwxr-xr-x 2 grid oinstall 4096 Oct 27 16:46 amdu_2016_10_27_16_46_10[grid@ectonb ~]$ cd amdu_2016_10_27_16_46_10/[grid@ectonb amdu_2016_10_27_16_46_10]$ lltotal 18140-rw-r--r-- 1 grid oinstall 18563072 Oct 27 16:46 DATAFILE_260.f-rw-r--r-- 1 grid oinstall    11328 Oct 27 16:46 report.txt[grid@ectonb amdu_2016_10_27_16_46_10]$ dateThu Oct 27 16:49:02 CST 2016[grid@ectonb amdu_2016_10_27_16_46_10]$ 

解释:
1. '/dev/asm*'就是v$asm_disk.path的值
2. DATAFILE.260是datafile磁盘组的260号file,这个260号不是dba_data_file.file_id,是asm磁盘组中对asm file的命令规则.

report.txt的内容:

-*-amdu-*-******************************* AMDU Settings ********************************ORACLE_HOME = /u01/app/11.2.0/gridSystem name:LinuxNode name:ectonbRelease:2.6.32-431.el6.x86_64Version:#1 SMP Sun Nov 10 22:19:54 EST 2013Machine:x86_64amdu run:27-OCT-16 16:46:10Endianess:1--------------------------------- Operations ---------------------------------    -extract DATAFILE.260------------------------------- Disk Selection ------------------------------- -diskstring '/dev/asm*'------------------------------ Reading Control -------------------------------------------------------------- Output Control -------------------------------********************************* DISCOVERY **********************************----------------------------- DISK REPORT N0001 ------------------------------                Disk Path: /dev/asmdata1           Unique Disk ID:                Disk Label:      Physical Sector Size: 512 bytes                Disk Size: 10240 megabytes               Group Name: DATAFILE                Disk Name: DATAFILE_0000       Failure Group Name: DATAFILE_0000              Disk Number: 0            Header Status: 3       Disk Creation Time: 2015/10/30 14:02:41.527000          Last Mount Time: 2016/10/26 16:43:26.655000    Compatibility Version: 0x0b200000(11020000)         Disk Sector Size: 512 bytes         Disk size in AUs: 10240 AUs         Group Redundancy: 2      Metadata Block Size: 4096 bytes                  AU Size: 1048576 bytes                   Stride: 113792 AUs      Group Creation Time: 2015/10/30 14:02:41.218000  File 1 Block 1 location: AU 2              OCR Present: NO----------------------------- DISK REPORT N0002 ------------------------------                Disk Path: /dev/asmdata2           Unique Disk ID:                Disk Label:      Physical Sector Size: 512 bytes                Disk Size: 10240 megabytes               Group Name: DATAFILE                Disk Name: DATAFILE_0001       Failure Group Name: DATAFILE_0001              Disk Number: 1            Header Status: 3       Disk Creation Time: 2015/10/30 14:02:41.527000          Last Mount Time: 2016/10/26 16:43:26.655000    Compatibility Version: 0x0b200000(11020000)         Disk Sector Size: 512 bytes         Disk size in AUs: 10240 AUs         Group Redundancy: 2      Metadata Block Size: 4096 bytes                  AU Size: 1048576 bytes                   Stride: 113792 AUs      Group Creation Time: 2015/10/30 14:02:41.218000  File 1 Block 1 location: AU 2              OCR Present: NO----------------------------- DISK REPORT N0003 ------------------------------                Disk Path: /dev/asmocrvd1           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: 2015/10/30 13:05:48.200000          Last Mount Time: 2016/10/26 15:11:35.868000    Compatibility Version: 0x0b200000(11020000)         Disk Sector Size: 512 bytes         Disk size in AUs: 5120 AUs         Group Redundancy: 3      Metadata Block Size: 4096 bytes                  AU Size: 1048576 bytes                   Stride: 113792 AUs      Group Creation Time: 2015/10/30 13:05:46.907000  File 1 Block 1 location: AU 2              OCR Present: YES----------------------------- DISK REPORT N0004 ------------------------------                Disk Path: /dev/asmocrvd2           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: 2015/10/30 13:05:48.200000          Last Mount Time: 2016/10/26 15:11:35.868000    Compatibility Version: 0x0b200000(11020000)         Disk Sector Size: 512 bytes         Disk size in AUs: 5120 AUs         Group Redundancy: 3      Metadata Block Size: 4096 bytes                  AU Size: 1048576 bytes                   Stride: 113792 AUs      Group Creation Time: 2015/10/30 13:05:46.907000  File 1 Block 1 location: AU 2              OCR Present: YES----------------------------- DISK REPORT N0005 ------------------------------                Disk Path: /dev/asmocrvd3           Unique Disk ID:                Disk Label:      Physical Sector Size: 512 bytes                Disk Size: 5120 megabytes               Group Name: DATA                Disk Name: DATA_0002       Failure Group Name: DATA_0002              Disk Number: 2            Header Status: 3       Disk Creation Time: 2015/10/30 13:05:48.200000          Last Mount Time: 2016/10/26 15:11:35.868000    Compatibility Version: 0x0b200000(11020000)         Disk Sector Size: 512 bytes         Disk size in AUs: 5120 AUs         Group Redundancy: 3      Metadata Block Size: 4096 bytes                  AU Size: 1048576 bytes                   Stride: 113792 AUs      Group Creation Time: 2015/10/30 13:05:46.907000  File 1 Block 1 location: AU 2              OCR Present: YES----------------------------- DISK REPORT N0006 ------------------------------                Disk Path: /dev/asmocrvd4           Unique Disk ID:                Disk Label:      Physical Sector Size: 512 bytes                Disk Size: 5120 megabytes               Group Name: DATA                Disk Name: DATA_0003       Failure Group Name: DATA_0003              Disk Number: 3            Header Status: 3       Disk Creation Time: 2015/10/30 13:05:48.200000          Last Mount Time: 2016/10/26 15:11:35.868000    Compatibility Version: 0x0b200000(11020000)         Disk Sector Size: 512 bytes         Disk size in AUs: 5120 AUs         Group Redundancy: 3      Metadata Block Size: 4096 bytes                  AU Size: 1048576 bytes                   Stride: 113792 AUs      Group Creation Time: 2015/10/30 13:05:46.907000  File 1 Block 1 location: AU 0              OCR Present: NO----------------------------- DISK REPORT N0007 ------------------------------                Disk Path: /dev/asmocrvd5           Unique Disk ID:                Disk Label:      Physical Sector Size: 512 bytes                Disk Size: 5120 megabytes               Group Name: DATA                Disk Name: DATA_0004       Failure Group Name: DATA_0004              Disk Number: 4            Header Status: 3       Disk Creation Time: 2015/10/30 13:05:48.200000          Last Mount Time: 2016/10/26 15:11:35.868000    Compatibility Version: 0x0b200000(11020000)         Disk Sector Size: 512 bytes         Disk size in AUs: 5120 AUs         Group Redundancy: 3      Metadata Block Size: 4096 bytes                  AU Size: 1048576 bytes                   Stride: 113792 AUs      Group Creation Time: 2015/10/30 13:05:46.907000  File 1 Block 1 location: AU 0              OCR Present: NO----------------------------- DISK REPORT N0008 ------------------------------                Disk Path: /dev/asmofra1           Unique Disk ID:                Disk Label:      Physical Sector Size: 512 bytes                Disk Size: 10240 megabytes               Group Name: FRA                Disk Name: FRA_0000       Failure Group Name: FRA_0000              Disk Number: 0            Header Status: 3       Disk Creation Time: 2015/10/30 14:03:23.157000          Last Mount Time: 2016/10/26 16:43:27.714000    Compatibility Version: 0x0b200000(11020000)         Disk Sector Size: 512 bytes         Disk size in AUs: 10240 AUs         Group Redundancy: 2      Metadata Block Size: 4096 bytes                  AU Size: 1048576 bytes                   Stride: 113792 AUs      Group Creation Time: 2015/10/30 14:03:22.857000  File 1 Block 1 location: AU 2              OCR Present: NO----------------------------- DISK REPORT N0009 ------------------------------                Disk Path: /dev/asmofra2           Unique Disk ID:                Disk Label:      Physical Sector Size: 512 bytes                Disk Size: 10240 megabytes               Group Name: FRA                Disk Name: FRA_0001       Failure Group Name: FRA_0001              Disk Number: 1            Header Status: 3       Disk Creation Time: 2015/10/30 14:03:23.157000          Last Mount Time: 2016/10/26 16:43:27.714000    Compatibility Version: 0x0b200000(11020000)         Disk Sector Size: 512 bytes         Disk size in AUs: 10240 AUs         Group Redundancy: 2      Metadata Block Size: 4096 bytes                  AU Size: 1048576 bytes                   Stride: 113792 AUs      Group Creation Time: 2015/10/30 14:03:22.857000  File 1 Block 1 location: AU 2              OCR Present: NO***************** Slept for 6 seconds waiting for heartbeats ***************************************** SCANNING DISKGROUP DATAFILE *************************            Creation Time: 2015/10/30 14:02:41.218000         Disks Discovered: 2               Redundancy: 2                  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: '/dev/asmdata1'           Allocated AU's: 7371                Free AU's: 2869       AU's read for dump: 0       Block images saved: 0        Map lines written: 0          Heartbeats seen: 0  Corrupt metadata blocks: 0        Corrupt AT blocks: 0---------------------------- SCANNING DISK N0002 -----------------------------Disk N0002: '/dev/asmdata2'           Allocated AU's: 7371                Free AU's: 2869       AU's read for dump: 0       Block images saved: 0        Map lines written: 0          Heartbeats seen: 0  Corrupt metadata blocks: 0        Corrupt AT blocks: 0----------------------- SUMMARY FOR DISKGROUP DATAFILE -----------------------           Allocated AU's: 14742                Free AU's: 5738       AU's read for dump: 0       Block images saved: 0        Map lines written: 0          Heartbeats seen: 0  Corrupt metadata blocks: 0        Corrupt AT blocks: 0************************ EXTRACTING FILE DATAFILE.260 ************************            Creating file: DATAFILE_260.f         Extraction wrote: 18563072 bytes              Stripe size: 131072 bytes           Stripe columns: 8            Mirror copies: 3               Block size: 16384 bytes                File size: 1133 blocks                File type: 1           Extent size #1: 4294967295 extents of  1 AUs           Extent size #2:          0 extents of  1 AUs           Extent size #3:          0 extents of  1 AUs           Extent size #4: 4294967295 extents of  1 AUs            Creation time: 2015/10/30 16:25:46.835000            Modified time: 2016/10/26 16:00:00.000000     Data extents in file: 72       Data extents found: 48         Blocks not found: 0 blocks******************************* END OF REPORT ********************************

0 0
原创粉丝点击