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

最新推荐文章于 2021-07-27 14:39:21 发布

msdnchina

最新推荐文章于 2021-07-27 14:39:21 发布

阅读量1.3k

点赞数

分类专栏： Oracle DB 文章标签： amdu extract

本文链接：https://blog.csdn.net/msdnchina/article/details/52958560

版权

Oracle DB 专栏收录该内容

773 篇文章 3 订阅

订阅专栏

[grid@ectonb ~]$ amdu -diskstring '/dev/asm*' -extract DATAFILE.260
amdu_2016_10_27_16_46_10/
[grid@ectonb ~]$ pwd
/home/grid
[grid@ectonb ~]$ ls -lrt
total 8
drwxrwxr-x 3 grid oinstall 4096 Oct 30  2015 oradiag_grid
drwxr-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]$ ll
total 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]$ date
Thu 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/grid
System name:	Linux
Node name:	ectonb
Release:	2.6.32-431.el6.x86_64
Version:	#1 SMP Sun Nov 10 22:19:54 EST 2013
Machine:	x86_64
amdu run:	27-OCT-16 16:46:10
Endianess:	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 ********************************