amdu抽取数据文件

已于 2023-01-12 10:09:11 修改
阅读量431 收藏
点赞数
分类专栏： ORALCE 备份恢复 文章标签： 数据库 oracle 服务器
于 2019-03-15 16:06:56 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/whb234174124/article/details/88558124
版权

一、amdu恢复数据

[grid@rac1 ~]$ amdu
amdu_2019_03_14_13_57_27/
[grid@rac1 ~]$ 
[grid@rac1 ~]$ 
[grid@rac1 ~]$ cd amdu_2019_03_14_13_57_27/
[grid@rac1 amdu_2019_03_14_13_57_27]$ ls
report.txt

1、查看盘信息
[grid@rac1 amdu_2019_03_14_13_57_27]$ more report.txt 


-*-amdu-*-

******************************* AMDU Settings ********************************
ORACLE_HOME = /u01/app/11.2.0/grid
System name:    Linux
Node name:      rac1
Release:        2.6.32-358.el6.x86_64
Version:        #1 SMP Tue Jan 29 11:47:41 EST 2013
Machine:        x86_64
amdu run:       14-MAR-19 13:57:27
Endianess:      1

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

------------------------------- Disk Selection -------------------------------
 -diskstring ''

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

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

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

----------------------------- DISK REPORT N0001 ------------------------------
                Disk Path: /dev/raw/raw1
           Unique Disk ID: 
               Disk Label: 
     Physical Sector Size: 512 bytes
                Disk Size: 1024 megabytes
               Group Name: OCR
                Disk Name: OCR_0000
       Failure Group Name: OCR_0000
              Disk Number: 0
            Header Status: 3
       Disk Creation Time: 2019/01/10 12:39:13.274000
          Last Mount Time: 2019/03/14 13:31:14.547000
    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: 2019/01/10 12:39:12.985000
  File 1 Block 1 location: AU 2
              OCR Present: YES

----------------------------- DISK REPORT N0002 ------------------------------
                Disk Path: /dev/raw/raw2
           Unique Disk ID: 
               Disk Label: 
     Physical Sector Size: 512 bytes
                Disk Size: 1024 megabytes
               Group Name: OCR
                Disk Name: OCR_0001
       Failure Group Name: OCR_0001
              Disk Number: 1
            Header Status: 3
       Disk Creation Time: 2019/01/10 12:39:13.274000
          Last Mount Time: 2019/03/14 13:31:14.547000
    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: 2019/01/10 12:39:12.985000
  File 1 Block 1 location: AU 2
              OCR Present: YES

----------------------------- DISK REPORT N0003 ------------------------------
                Disk Path: /dev/raw/raw3
           Unique Disk ID: 
               Disk Label: 
     Physical Sector Size: 512 bytes
                Disk Size: 1024 megabytes
               Group Name: OCR
                Disk Name: OCR_0002
       Failure Group Name: OCR_0002
              Disk Number: 2
            Header Status: 3
       Disk Creation Time: 2019/01/10 12:39:13.274000
          Last Mount Time: 2019/03/14 13:31:14.547000
    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: 2019/01/10 12:39:12.985000
  File 1 Block 1 location: AU 2
              OCR Present: YES

----------------------------- DISK REPORT N0004 ------------------------------
                Disk Path: /dev/raw/raw4
           Unique Disk ID: 
               Disk Label: 
     Physical Sector Size: 512 bytes
                Disk Size: 20480 megabytes
               Group Name: DATA
                Disk Name: DATA_0000
       Failure Group Name: DATA_0000
              Disk Number: 0
            Header Status: 3
       Disk Creation Time: 2018/11/27 16:43:08.882000
          Last Mount Time: 2019/03/14 13:53:28.541000
    Compatibility Version: 0x0b200000(11020000)
         Disk Sector Size: 512 bytes
         Disk size in AUs: 20480 AUs
         Group Redundancy: 1
      Metadata Block Size: 4096 bytes
                  AU Size: 1048576 bytes
                   Stride: 113792 AUs
      Group Creation Time: 2018/11/27 16:43:08.778000
  File 1 Block 1 location: AU 2
              OCR Present: NO

----------------------------- DISK REPORT N0005 ------------------------------
                Disk Path: /dev/raw/raw5
           Unique Disk ID: 
               Disk Label: 
     Physical Sector Size: 512 bytes
                Disk Size: 8192 megabytes
               Group Name: OGG
                Disk Name: OGG_0000
       Failure Group Name: OGG_0000
              Disk Number: 0
            Header Status: 3
       Disk Creation Time: 2019/03/04 16:52:34.922000
          Last Mount Time: 2019/03/14 13:31:54.634000
    Compatibility Version: 0x0b200000(11020000)
         Disk Sector Size: 512 bytes
         Disk size in AUs: 8192 AUs
         Group Redundancy: 1
      Metadata Block Size: 4096 bytes
                  AU Size: 1048576 bytes
                   Stride: 113792 AUs
      Group Creation Time: 2019/03/04 16:52:34.832000
  File 1 Block 1 location: AU 2
              OCR Present: NO

----------------------------- DISK REPORT N0006 ------------------------------
                Disk Path: /dev/raw/raw6
           Unique Disk ID: 
               Disk Label: 
     Physical Sector Size: 512 bytes
                Disk Size: 20480 megabytes
               Group Name: DATADG
                Disk Name: DATADG_0000
       Failure Group Name: DATADG_0000
              Disk Number: 0
            Header Status: 3
       Disk Creation Time: 2019/03/14 13:56:32.698000
          Last Mount Time: 2019/03/14 13:56:44.019000
    Compatibility Version: 0x0b200000(11020000)
         Disk Sector Size: 512 bytes
         Disk size in AUs: 20480 AUs
         Group Redundancy: 1
      Metadata Block Size: 4096 bytes
                  AU Size: 1048576 bytes
                   Stride: 113792 AUs
      Group Creation Time: 2019/03/14 13:56:32.538000
  File 1 Block 1 location: AU 2
              OCR Present: NO

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

2、导出DATA磁盘组下raw4盘的数据


[grid@rac1 amdu_2019_03_14_13_57_27]$amdu  -diskstring '/dev/raw/raw4' -dump 'DATA'
amdu_2019_03_14_13_59_16/
AMDU-00209: Corrupt block found: Disk N0001 AU [0] block [1] type [0]
AMDU-00201: Disk N0001: '/dev/raw/raw4'

3、查看控制文件名称位置


[oracle@rac1 trace]$ tail -100f alert_rac101.log 
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name:    Linux
Node name:      rac1
Release:        2.6.32-358.el6.x86_64
Version:        #1 SMP Tue Jan 29 11:47:41 EST 2013
Machine:        x86_64
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initrac101.ora
System parameters with non-default values:
  processes                = 150
  spfile                   = "+DATA/rac10/initrac10.ora"
  sga_target               = 572M
  control_files            = "+DATA/rac10/controlfile/current.267.1001289955"
  db_block_size            = 8192
  compatible               = "11.2.0.4.0"
  log_archive_dest_1       = "location=+DATA"
  log_archive_format       = "%t_%s_%r.dbf"
  db_file_multiblock_read_count= 16
  cluster_database         = TRUE
  cluster_database_instances= 2
  db_create_file_dest      = "+DATA"
  db_recovery_file_dest    = "/u01/orabak/"
  db_recovery_file_dest_size= 5G
  thread                   = 1
  enable_goldengate_replication= TRUE
  undo_management          = "AUTO"
  undo_tablespace          = "UNDOTBS1"
  instance_number          = 1
  recyclebin               = "OFF"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=rac10XDB)"
  remote_listener          = "scan-ip:1521"
  job_queue_processes      = 10
  audit_file_dest          = "/u01/app/oracle/admin/rac10/adump"
  db_name                  = "rac10"
  open_cursors             = 300
  pga_aggregate_target     = 190M

4、通过alert日志显示的文件号抽出控制文件

[grid@rac1 amdu_2019_03_14_13_57_27]$ amdu -diskstring  '/dev/raw/raw4' -extract data.267
amdu_2019_03_14_14_03_16/

5、查看控制文件中包含的数据文件


[grid@rac1 amdu_2019_03_14_14_03_16]$ strings DATA_267.f |grep +DATA > DATA.TXT
[grid@rac1 amdu_2019_03_14_14_03_16]$ more  DATA.TXT
+DATA/rac10/onlinelog/group_1.log
+DATA/rac10/datafile/ogg.278.1002046107
+DATA/rac10/onlinelog/group_2.log
+DATA/rac10/datafile/system.265.1001292749
+DATA/rac10/datafile/undotbs1.261.1001292751
+DATA/rac10/datafile/sysaux.264.1001292751
+DATA/rac10/tempfile/temp.270.1001293445
+DATA/rac10/datafile/undotbs2.266.1001292751
+DATA/rac10/datafile/users.259.1001292751
+DATA/rac10/onlinelog/group_3.log
+DATA/rac10/onlinelog/group_4.log
+DATA/rac10/datafile/bj_test_backup.260.1001292751
+DATA/rac10/datafile/test1.258.1001292749
+DATA/rac10/onlinelog/group_1.log
+DATA/rac10/datafile/ogg.278.1002046107
+DATA/rac10/onlinelog/group_2.log
+DATA/rac10/datafile/system.265.1001292749
+DATA/rac10/datafile/undotbs1.261.1001292751
+DATA/rac10/datafile/sysaux.264.1001292751
+DATA/rac10/tempfile/temp.270.1001293445
+DATA/rac10/datafile/undotbs2.266.1001292751
+DATA/rac10/datafile/users.259.1001292751
+DATA/rac10/onlinelog/group_3.log
+DATA/rac10/onlinelog/group_4.log
+DATA/rac10/datafile/bj_test_backup.260.1001292751
+DATA/rac10/datafile/test1.258.1001292749
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_107.339.1002809775
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_37.340.1002809777
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_38.341.1002816769
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_107.339.1002809775
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_37.340.1002809777
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_70.269.1002035871
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_71.271.1002035879
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_72.272.1002035891
+DATA/rac10/archivelog/2019_03_04/thread_2_seq_6.273.1002035893
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_73.274.1002036011
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_74.275.1002043973
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_75.276.1002044015
+DATA/rac10/archivelog/2019_03_04/thread_2_seq_7.277.1002044019
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_76.279.1002046779
+DATA/rac10/archivelog/2019_03_04/thread_2_seq_8.280.1002056101
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_77.281.1002056103
+DATA/rac10/archivelog/2019_03_05/thread_1_seq_78.282.1002103981
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_9.283.1002103985
+DATA/rac10/archivelog/2019_03_05/thread_1_seq_79.284.1002124893
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_10.285.1002124897
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_11.286.1002124899
+DATA/rac10/archivelog/2019_03_05/thread_1_seq_80.287.1002133785
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_12.288.1002133787
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_70.269.1002035871
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_71.271.1002035879
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_72.272.1002035891
+DATA/rac10/archivelog/2019_03_04/thread_2_seq_6.273.1002035893
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_73.274.1002036011
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_74.275.1002043973
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_75.276.1002044015
+DATA/rac10/archivelog/2019_03_04/thread_2_seq_7.277.1002044019
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_76.279.1002046779
+DATA/rac10/archivelog/2019_03_04/thread_2_seq_8.280.1002056101
+DATA/rac10/archivelog/2019_03_04/thread_1_seq_77.281.1002056103
+DATA/rac10/archivelog/2019_03_05/thread_1_seq_78.282.1002103981
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_9.283.1002103985
+DATA/rac10/archivelog/2019_03_05/thread_1_seq_79.284.1002124893
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_10.285.1002124897
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_11.286.1002124899
+DATA/rac10/archivelog/2019_03_05/thread_1_seq_80.287.1002133785
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_12.288.1002133787
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_13.289.1002133789
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_81.290.1002188483
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_14.291.1002190973
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_82.292.1002190977
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_15.293.1002191751
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_16.294.1002191753
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_83.295.1002191755
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_17.296.1002221551
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_84.297.1002221555
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_85.298.1002226695
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_18.299.1002226703
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_19.300.1002226703
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_86.301.1002280155
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_87.302.1002280155
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_88.303.1002280157
+DATA/rac10/archivelog/2019_03_07/thread_2_seq_20.304.1002281063
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_89.305.1002281065
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_90.306.1002295555
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_91.308.1002295557
+DATA/rac10/archivelog/2019_03_07/thread_2_seq_21.307.1002295557
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_22.309.1002365465
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_92.310.1002365467
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_23.311.1002382285
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_93.312.1002382287
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_94.313.1002382295
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_95.314.1002382297
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_24.315.1002382301
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_96.316.1002382303
+DATA/rac10/archivelog/2019_03_05/thread_2_seq_13.289.1002133789
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_81.290.1002188483
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_14.291.1002190973
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_82.292.1002190977
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_15.293.1002191751
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_16.294.1002191753
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_83.295.1002191755
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_17.296.1002221551
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_84.297.1002221555
+DATA/rac10/archivelog/2019_03_06/thread_1_seq_85.298.1002226695
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_18.299.1002226703
+DATA/rac10/archivelog/2019_03_06/thread_2_seq_19.300.1002226703
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_86.301.1002280155
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_87.302.1002280155
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_88.303.1002280157
+DATA/rac10/archivelog/2019_03_07/thread_2_seq_20.304.1002281063
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_89.305.1002281065
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_90.306.1002295555
+DATA/rac10/archivelog/2019_03_07/thread_1_seq_91.308.1002295557
+DATA/rac10/archivelog/2019_03_07/thread_2_seq_21.307.1002295557
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_22.309.1002365465
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_92.310.1002365467
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_23.311.1002382285
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_93.312.1002382287
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_94.313.1002382295
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_95.314.1002382297
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_24.315.1002382301
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_96.316.1002382303
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_25.317.1002382307
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_26.318.1002382313
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_97.319.1002382315
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_98.320.1002382381
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_27.322.1002392193
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_99.321.1002392191
+DATA/rac10/archivelog/2019_03_11/thread_1_seq_100.323.1002615773
+DATA/rac10/archivelog/2019_03_11/thread_2_seq_28.324.1002615775
+DATA/rac10/archivelog/2019_03_11/thread_2_seq_29.325.1002615777
+DATA/rac10/archivelog/2019_03_11/thread_1_seq_101.326.1002627799
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_102.329.1002794561
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_30.331.1002807245
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_103.330.1002807245
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_31.332.1002807249
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_32.333.1002807249
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_104.334.1002807251
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_33.335.1002807885
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_105.336.1002807889
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_106.337.1002807891
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_34.328.1002809289
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_35.327.1002809289
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_25.317.1002382307
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_26.318.1002382313
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_97.319.1002382315
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_98.320.1002382381
+DATA/rac10/archivelog/2019_03_08/thread_2_seq_27.322.1002392193
+DATA/rac10/archivelog/2019_03_08/thread_1_seq_99.321.1002392191
+DATA/rac10/archivelog/2019_03_11/thread_1_seq_100.323.1002615773
+DATA/rac10/archivelog/2019_03_11/thread_2_seq_28.324.1002615775
+DATA/rac10/archivelog/2019_03_11/thread_2_seq_29.325.1002615777
+DATA/rac10/archivelog/2019_03_11/thread_1_seq_101.326.1002627799
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_102.329.1002794561
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_30.331.1002807245
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_103.330.1002807245
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_31.332.1002807249
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_32.333.1002807249
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_104.334.1002807251
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_33.335.1002807885
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_105.336.1002807889
+DATA/rac10/archivelog/2019_03_13/thread_1_seq_106.337.1002807891
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_34.328.1002809289
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_35.327.1002809289
+DATA/rac10/archivelog/2019_03_13/thread_2_seq_36.338.1002809775

6、通过文件号抽出数据文件

amdu -diskstring /dev/raw/raw4 -extract DATA.278
amdu -extract DATA.265
amdu -extract DATA.261
amdu -extract DATA.264
amdu -extract DATA.270
amdu -extract DATA.266
amdu -extract DATA.259
amdu -extract DATA.260
amdu -extract DATA.258

7、重新手动编写pfile，将数据库mount（*.cluster_database=false、*.control_files='/u01/app/oracle/oradata/DATA_267.f'）

8、修改数据文件位置


alter database rename file '+DATA/rac10/datafile/test1.258.1001292749' to '/u01/app/oracle/oradata/DATA_258.f';  
alter database rename file '+DATA/rac10/datafile/users.259.1001292751' to '/u01/app/oracle/oradata/DATA_259.f';  
alter database rename file '+DATA/rac10/datafile/bj_test_backup.260.1001292751' to '/u01/app/oracle/oradata/DATA_260.f'; 
alter database rename file '+DATA/rac10/datafile/undotbs1.261.1001292751' to '/u01/app/oracle/oradata/DATA_261.f';  
alter database rename file '+DATA/rac10/datafile/sysaux.264.1001292751' to '/u01/app/oracle/oradata/DATA_264.f';  
alter database rename file '+DATA/rac10/datafile/system.265.1001292749' to '/u01/app/oracle/oradata/DATA_265.f';  
alter database rename file '+DATA/rac10/datafile/undotbs2.266.1001292751' to '/u01/app/oracle/oradata/DATA_266.f';  
alter database rename tempfile '+DATA/rac10/tempfile/temp.270.1001293445' to '/u01/app/oracle/oradata/DATA_270.f';  
alter database rename file '+DATA/rac10/datafile/ogg.278.1002046107' to '/u01/app/oracle/oradata/DATA_278.f';
SQL>  select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/DATA_265.f
/u01/app/oracle/oradata/DATA_261.f
/u01/app/oracle/oradata/DATA_264.f
/u01/app/oracle/oradata/DATA_266.f
/u01/app/oracle/oradata/DATA_259.f
/u01/app/oracle/oradata/DATA_260.f
/u01/app/oracle/oradata/DATA_258.f
/u01/app/oracle/oradata/DATA_278.f

8 rows selected.

9、由于找不到日志文件文件号，创建新日志文件，清空删除旧日志文件

alter database add logfile thread 1 group 10 '+DATADG' size 50m;
alter database add logfile thread 2 group 11 '+DATADG' size 50m;
alter database add logfile thread 1 group 12 '+DATADG' size 50m;
alter database add logfile thread 2 group 13 '+DATADG' size 50m;

SQL>  alter database  noarchivelog;

SQL> alter database clear logfile group 1;

SQL> alter database clear logfile group 2;

SQL> alter database clear logfile group 3;

SQL> alter database clear logfile group 4;


SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database drop logfile group 4;

Database altered.

10、开库 


SQL> alter database open;

Database altered.

11、11.2版本如果数据文件名人为指定，需要查找ASM file number

ASM 的 File directory 在 AU2，block 6 上
kfed read  dev=/dev/sde1 aun=2 blkn=6 |more
kfbh.endian:                          1 ; 0x000: 0x01
kfbh.hard:                          130 ; 0x001: 0x82
kfbh.type:                            4 ; 0x002: KFBTYP_FILEDIR
...
kfffde[0].xptr.au:                   48 ; 0x4a0: 0x00000030

xptr.au 即 alias directory 所在的 au,从 blkn=0 开始查找

kfed read  dev=/dev/sde1 aun=48 blkn=2 |more
kfade[5].name:        spfileklistdb.ora ; 0x1b0: length=14      
kfade[5].fnum:                            269 ; 0x1e0: 0x0000010a  

12、19c版本在第24个AU记录

[grid@sundc1:/home/grid]$kfed read /dev/asm-diskf aun=24 blknum=0
kfbh.endian:                          1 ; 0x000: 0x01
kfbh.hard:                          130 ; 0x001: 0x82
kfbh.type:                           11 ; 0x002: KFBTYP_ALIASDIR
kfbh.datfmt:                          1 ; 0x003: 0x01
kfbh.block.blk:                       0 ; 0x004: blk=0
kfbh.block.obj:                       6 ; 0x008: file=6
kfbh.check:                  2383240155 ; 0x00c: 0x8e0d5bdb
kfbh.fcn.base:                  6370428 ; 0x010: 0x0061347c
kfbh.fcn.wrap:                        0 ; 0x014: 0x00000000
kfbh.spare1:                          0 ; 0x018: 0x00000000
kfbh.spare2:                          0 ; 0x01c: 0x00000000
kffdnd.bnode.incarn:                  1 ; 0x000: A=1 NUMM=0x0
kffdnd.bnode.frlist.number:  4294967295 ; 0x004: 0xffffffff
kffdnd.bnode.frlist.incarn:           0 ; 0x008: A=0 NUMM=0x0
kffdnd.overfl.number:        4294967295 ; 0x00c: 0xffffffff
kffdnd.overfl.incarn:                 0 ; 0x010: A=0 NUMM=0x0
kffdnd.parent.number:                 0 ; 0x014: 0x00000000
kffdnd.parent.incarn:                 1 ; 0x018: A=1 NUMM=0x0
kffdnd.fstblk.number:                 0 ; 0x01c: 0x00000000
kffdnd.fstblk.incarn:                 1 ; 0x020: A=1 NUMM=0x0
kfade[0].entry.incarn:                5 ; 0x024: A=1 NUMM=0x2
kfade[0].entry.hash:         1959265326 ; 0x028: 0x74c8042e
kfade[0].entry.refer.number:          1 ; 0x02c: 0x00000001
kfade[0].entry.refer.incarn:          5 ; 0x030: A=1 NUMM=0x2
kfade[0].name:                    SUNDC ; 0x034: length=5
kfade[0].fnum:               4294967295 ; 0x064: 0xffffffff
kfade[0].finc:               4294967295 ; 0x068: 0xffffffff
kfade[0].flags:                       8 ; 0x06c: U=0 S=0 S=0 U=1 F=0
kfade[0].ub1spare:                    0 ; 0x06d: 0x00
kfade[0].freeblock:                   0 ; 0x06e: 0x0000
kfade[1].entry.incarn:                7 ; 0x070: A=1 NUMM=0x3
kfade[1].entry.hash:         3620707767 ; 0x074: 0xd7cf9db7
kfade[1].entry.refer.number:         15 ; 0x078: 0x0000000f
kfade[1].entry.refer.incarn:          1 ; 0x07c: A=1 NUMM=0x0
kfade[1].name:                     arch ; 0x080: length=4
kfade[1].fnum:               4294967295 ; 0x0b0: 0xffffffff
kfade[1].finc:               4294967295 ; 0x0b4: 0xffffffff
kfade[1].flags:                       8 ; 0x0b8: U=0 S=0 S=0 U=1 F=0
kfade[1].ub1spare:                    0 ; 0x0b9: 0x00
kfade[1].freeblock:                   0 ; 0x0ba: 0x0000
kfade[2].entry.incarn:                4 ; 0x0bc: A=0 NUMM=0x2
kfade[2].entry.hash:                  0 ; 0x0c0: 0x00000000
kfade[2].entry.refer.number:          0 ; 0x0c4: 0x00000000
kfade[2].entry.refer.incarn:          0 ; 0x0c8: A=0 NUMM=0x0
kfade[2].name:                      ASM ; 0x0cc: length=3
kfade[2].fnum:               4294967295 ; 0x0fc: 0xffffffff
kfade[2].finc:               4294967295 ; 0x100: 0xffffffff
kfade[2].flags:                       4 ; 0x104: U=0 S=0 S=1 U=0 F=0

参考：数据恢复：AMDU数据抽取恢复

How to Restore the Database Using AMDU after Diskgroup Corruption (文档 ID 1597581.1)

ASM utilities · 大专栏

whb234174124
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
Oracle 10g利用amdu抽取数据文件的方法教程
09-09
主要给大家介绍了关于Oracle 10g利用amdu抽取数据文件的相关资料，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
AMDU ASM磁盘数据抽取
最新发布
Nuzbb的博客
01-08 374
ASM 数据抽取 故障修复
oracle 数据文件 属组,kfed找出来asm 磁盘组中数据文件别名对应的文件号—amdu恢复...
weixin_29096377的博客
04-04 269
前段时间有多个朋友问我,在amdu中,如果数据文件命名不是omf的方式,该如何找出来数据文件的asm file_number,从而实现通过amdu对不能mount的磁盘组中的数据文件进行恢复,这里通过测试给出来处理方法.根据我们对asm的理解,asm file_number 6为asm file的别名文件记录所在地,我们通过分析kfed这些au中的记录即可获得相关数据文件的别名对应的asm文件号模...
amdu oracle,11g中的amdu的使用
weixin_39867296的博客
04-13 156
oracle和grid下均有amdu的命令。使用的时候[grid@testorcl11g bin]$ ./amduamdu_2015_04_20_16_59_55/看里面的report.txt文件[grid@testorcl11g amdu_2015_04_20_16_59_55]$ cat report.txt-*-amdu-*-******************************* A...
amdu快速抽取文件思路
sqlora的专栏
07-09 247
简单思路： 通过 amdu -dump DATA -noimage 查看report.txt 或者如下方法: 1.根据alert日志可查看pfile大致内容和控制文件名称号，从而创建基本的pfile参数文件 2.先抽取控制文件amdu -extract DG.270 3.通过控制文件内容获得数据库的数据文件、日志文件分布情况,stringsDG.270|grep DG > ./t.txt 4.根据t.txt结果可以得到其它文件号 5.再amdu -extract xx.xx，后续.
AMDU抽取ASM files(ASM nomount)
小伟的博客
06-16 1463
如何利用amdu来抽取asm files? ASM磁盘组在nomount状态 1. ASM alias 元数据在哪个位置呢？ SQL>  select number_kffxp file#, disk_kffxp disk#, count(disk_kffxp) extents     from x$kffxp     where group_kffxp=1
异常恢复-amdu抽取ASM文件
05-10
AMDU功能介绍： 1. 将ASM DISK上的元数据转储到文件系统上...本文将详细说明AMDU工具打印的各种信息，并讲解如何在ASM instance不可用的情况下配合kfed以及OS 命令直接从磁盘抽取oracle的控制文件/数据文件/参数文件。
amdu for linux
07-05
从Oracle 11g开始，Oracle...AMDU工具也可以用于直接从ASM磁盘组中抽取数据文件，这位ASM的数据恢复提供了极大的便利。我们最近使用这个工具帮助用户挽救了崩溃的数据库。当ASM出现故障时，AMDU就开始大有用武之地。
deepin-15.11-amd64.7z.002
01-01
deepin-15.11 64位国产操作系统，共3卷，第2卷。
Oracle11g常见故障处理
09-30
安装和配置类问题、实例管理类问题、数据管理类管理、数据库恢复类问题、管理工具类问题
紧急救援——AMDU数据抽取恢复
weixin_42329915的博客
06-04 193
AMDU and CHECK NOREPAIR report conflicting corruption results for ASM Diskgroup (Doc ID 1535055.1)
bruce
11-20 741
In this Document   Symptoms   Cause   Solution   References APPLIES TO: Oracle Database - Enterprise Edition - Version 11.1.0.7 and
amdu抽取asm磁盘组中的datafile到本地文件系统
msdnchina的专栏@JiNan,ShanDong
10-28 1348
amdu抽取asm磁盘组中的datafile到本地文件系统
Oracle利器:AMDU抽取ASM数据文件测试
Kay的博客
06-11 1322
Oracle利器:AMDU抽取ASM数据文件测试 在异常情况下RAC集群无法启动，asm实例无法打开，此时asm磁盘组文件也无法使用asmcmd拷贝到文件目录，我们可以使用Oracle自带的工具amdu，在asm实例无法启动或者磁盘组无法mount的情况下对数据进行抽取。 本次通过odu以及amdu，将rac环境下的数据库，在异机单实例下进行恢复。 备注：本次通过odu的试用版，仅仅是获取asm目...
ASM AMDU工具的使用
小伟的专栏
03-15 909
AMDU是ORACLE针对ASM开发的源数据转储工具，其全称为ASM Metadata Dump Utility(AMDU) ASM作为近几年最流行的存储解决方案，大家对他的优缺点都有所了解，其中的问题之一就是ASM是个黑盒。 一旦DISKGROUP无法MOUNT起来就意味着传统方法无法以磁盘为基础导出任何数据。AMDU解决了这一问题.  一.AMDU具体以下三个主要功能：
oracle asm 恢复 Oracle数据恢复:AMDU恢复ASM磁盘组数据
ORACLE数据库数据恢复、性能优化、故障诊断来问问MACLEAN
07-17 1298
  如何在ASM磁盘组损坏后使用AMDU进行数据库恢复 注意：这并不是针对受损ASM磁盘组中的内容使用RMAN备份来恢复方案的替代方案。使用这种工具一般是在常规恢复手段不起效而为了“尽最大努力”而进行的尝试。因此这种修复手段并不能对数据库进行完整性恢复。 1. 从数据库alert.log启动信息中找到相关参数信息，并为已经丢失的数据库建立pfile。 2. 启动数据库到nomount状...
硬盘故障数据库恢复 amdu 使用小记
枫树林
05-03 935
2012年9月份，东南亚印尼现场的磁阵出现问题， ASM实例不能启动，通过amdu 恢复了6T的数据，http://space.itpub.net/?uid-8013558-action-viewspace-itemid-746078 一直没有一像样的amdu 的使用文档。现有转自来自崔华老师 http://www.dbsnake.net/amdu-extract-asm-files-
kfed amdu使用方法小节
renfengjun
10-21 1938
工作RAC环境很多，为了应付未来可能发生的状况，根据网上的文章，研究一下了kfed以及amdu磁盘组恢复工具。
amdu oracle,Oracle AMDU用法
weixin_39966909的博客
04-13 232
学习笔记摘录整理AMDU有以下三种功能：将ASM DISK上的元数据转储到文件系统上以便分析将ASM文件的内容抽取出来并写入到OS文件系统，Diskgroup是否mount均可打印出块的元数据，以块中C语言结构或16进制的形式选项-diskstring和-exclude用以指定那些ASM DISK需要被读取。 选项-direcotry指定上一次运行AMDU所生成的文件夹。 指定的文件夹也可以是包含...
Oracle 12C ASM asmcmd amdu_extract
08-16 104
amdu_extract命令用来从磁盘组中抽取文件，其语法如下: ASMCMD[+DATA/cs/DATAFILE]>helpamdu_extract amdu_extract C...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值