Use Oracle AMDU to extract data files from the ASM disk group
Amdu-diskstring '<disk string>'-extract '<diskgroup name>. <file number>'
The data file number can be obtained based on the MySQL instance query v $ asm_file view.
You can also query v $ datafile. If an alias is used, you can use v $ asm_alias;
SQL> select name from v $ datafile;
NAME
--------------------------------------------------------------------------------
+ DATA/db1/datafile/system.256.794361477
+ DATA/db1/datafile/sysaux.257.794361477
+ DATA/db1/datafile/undotbs1.258.794361477
+ DATA/db1/datafile/users.259.794361477 <(= this files need to be extracted
+ DATA/db1/datafile/example.261.794361601
+ DATA/db1/datafile/testasm.263.817147851
+ DATA/db1/datafile/dbfs_ts.264.822088469
For example, we want to extract data files under the users tablespace.
Full File name = "+ DATA/db1/datafile/users.259.794361477"
File Number = "259"
Disk String = "/dev/Oracleasm/disks /*"
Diskgroup Name = "DATA"
Extracted File = DATA_259.f
Amdu-diskstring '/dev/oracleasm/disks/*'-extract 'data. 100'
A folder named amdu _ plus date is generated in the current directory.
[Grid @ dbaasm ~] $ Cd amdu_2013_08_31_00_17_17/
[Grid @ dbaasm amdu_2013_08_31_00_17_17] $ ls-l
Total 2099228
-Rw-r -- 1 grid oinstall 2147491840 Aug 31 DATA_259.f
-Rw-r -- 1 grid oinstall 14514 Aug 31 report.txt
The format of the generated data file is the disk group + data file number, and the suffix is "point f". Then, rename it to the corresponding tablespace name "users. dbf ".
[Grid @ dbaasm amdu_2013_08_31_00_17_17] $ mv DATA_259.f users. dbf
[Grid @ dbaasm amdu_2013_08_31_00_17_17] $ ls-l
Total 2099228
-Rw-r -- 1 grid oinstall 14514 Aug 31 report.txt
-Rw-r -- 1 grid oinstall 2147491840 Aug 31 users. dbf <(======
Last weekend, due to storage failure, the asm disk could not be loaded normally. This method was used to restore data for the customer.
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
Oracle 11g from entry to proficient in PDF + CD source code
Installing Oracle 11g R2 using RHEL6 ASM
Oracle 10g manual creation of the ASM Database
Oracle 10g R2 create ASM instance Step By Step