Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to use amdu to extract data files in Oracle. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

1. Enable amdu to be used in an oracle 10g environment

In the Oracle 10g environment, there is no built-in amdu tool, so you need to download it yourself:

For more information, please see the MOS documentation:

Placeholder for AMDU binaries and using with ASM 10g, 11g, 12c (document ID 553639.1)

> $cd > $export LD_LIBRARY_PATH=$LD_LIBRARY_PATH: `pwd` > or $setenv LD_LIBRARY_PATH ${LD_LIBRARY_PATH}: `pwd` > $export PATH=$PATH: `pwd` or setenv PATH ${PATH}: `pwd` > > or > > $cd > $export LIBPATH=$LIBPATH: `pwd` > or $setenv LIBPATH ${LIBPATH}: `pwd` > $export PATH=$PATH: `pwd` or setenv PATH ${PATH}: `pwd`

Note: if it is an AIX platform, it corresponds to setting the LIBPATH environment variable. I am Linux here, so set the LD_LIBRARY_PATH environment variable:

Unzip / tmp/amdu_X86-64.zip export LD_LIBRARY_PATH=$LD_LIBRARY_PATH: `pwd` export PATH=$PATH: `pwd`

two。 Enable kfed to be used in an oracle 10g environment

In an Oracle 10g environment, kfed needs to be compiled:

ASM tools used by Support: KFOD, KFED, AMDU (document ID 1485597.1)

KFED executable comes with installation from 11.1 onwards; for the older version you must build it.

The compilation method is as follows:

$cd $ORACLE_HOME/rdbms/lib$make-f ins_rdbms.mk ikfed

How to extract corrupted ASM disk group data from 3.amdu

How to use the amdu tool to extract database files when the ASM disk group is damaged:

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

1. Create pfile of lost database, from database alert.log startup messages.2. Startup database in nomount3. Get the controlfile number from db alert log, it will show while starting the database here in this eg. Its 256eg., control_files='+DATA/orcl/controlfile/current.256.709676643'If you have controlfile backup already in non-asm location edit the pfile to point to location of non-asm and then mount the databaseIf you dont have controlfile backup then go to step 4 after determining the file# from step 34. $amdu-diskstring-extract DATA.2565. Shutdown the database and change the control_file location to point to the extracted file location6. Startup mount the database7. Once mounted, get the datafile file numbers using "select name from v$datafile" And get online redo logfile from "select * from v$logfile" .8. Extract all datafiles and redolog files in similar manner9. Alter database rename to

10. Open the database

You can actually do experiments to verify the feasibility of MOS:

1. Create a parameter file

two。 Start the database to nomount state

3. Get the number of the control file

4. Extract control file

5. Close the database and modify the control_ file value

6. Start the database to mount state

7. Get the number of data files and log files

8. Extract data files and redo log files

9. Rename the database file to a new location

10. Open the database

The above is how to use amdu to extract data files in the Oracle shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.